Hi,

It can handle.  You can extend the file size also. File size limit depends
on the OS.  Obviously the performance depends on both the processor speed
and the memory.  Table optimization,indexing will improve performance.

Thanks
ViSolve DB Team
----- Original Message ----- From: "kalin mintchev" <[EMAIL PROTECTED]>
To: "ViSolve DB Team" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Monday, February 05, 2007 4:07 PM
Subject: Re: mysql limits



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]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to