Re: MySQL 4.1 to 5.1 large scale upgrade

[Rick James]

> 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
.../mysql/data/dbname/tblname.{frm,MYI,MYD}
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.