At 09:44 PM 2/4/2007, kalin mintchev wrote:
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....
Put as much memory in the machine as possible. Building indexes for a table
of that size will consume a lot of memory and if you don't have enough
memory, building the index will be done on the hard disk where it is 100x
slower. I've had 100M row tables without too much problem. However when I
tried 500M rows the indexes could not be built (took days) because I too
little RAM.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
