thanks... my question was more like IF mysql can handle that amount of records - about 100 million... and if it's just a question of cpu power and memory?....
> Hi, > > The limit for the table can be set when you create the table itself. > the MAX_ROWS and AVG_ROW_LENGTH variables (m X n matrix) will decide the > table size. > > MAX_ROWS limts the maximum number of rows in that table. The > AVG_ROW_LENGTH > variable decides the length of the row. The specified value can be used > by > a single column itself or depends on the size of the columns. > > Thanks > ViSolve DB Team. > ----- Original Message ----- > From: "kalin mintchev" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Monday, February 05, 2007 9:14 AM > Subject: mysql limits > > >> hi all... >> >> i just wanted to ask here if somebody has experience in pushing the >> mysql >> limits... i might have a job that needs to have a table (or a few >> tables) >> holding about a 100 million records. that's a lot of records.... is >> there >> any limitation of some kind that wouldn;t allow mysql to handle that >> kind >> of amounts or it all depends on memory and cpu... or how are the >> searches >> - speed and otherwise - affected by such numbers? >> >> thanks.... >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]