Thousands of tables in a MySQL database
Just read about the potential performance implications of having thousands of tables in a single MySQL database over at Ask Bjørn Hansen’s blog.
We have that type of setup at Alert Logic, but I don’t remember any problems while shutting down the database server. I wonder if the FLUSH TABLES problem only happens that badly under MyISAM instead of InnoDB?
