Re: MySQL 4.1 to 5.1 large scale upgrade
Posted by: Rick James
Date: April 02, 2011 11:37PM

> even if I split it up into all the databases, I pretty much have the same exact problem anyway.
I don't think so...
The files are
If you have 1000 dbnames, each with 1000 tables (3000 files), then SHOW TABLES for _one_ database will wade through only 3000 files, not a million.

Getting SHOW TABLES for _all_ databases will take longer, but will have only a small impact. Maintenance scripts will need to loop through the databases, then through the tables.

Options: ReplyQuote

Written By
Re: MySQL 4.1 to 5.1 large scale upgrade
April 02, 2011 11:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.