Re: Performance bottlenecks with thousands of small databases

[Justin Keller]

Thanks for the reply.

So after changing innodb_file_per_table = OFF, how do I migrate all the existing databases and tables?

I've changed innodb_flush_log_at_trx_commit to 2, as it is acceptable to flush the log buffer at transaction commit, but only flush to disk every second. Hopefully that will help a bit.

I've also changed query_cache_limit=1M and query_cache_size=64M per your suggestion.

My biggest question is if I flip innodb_file_per_table to OFF, what is the migration strategy to convert all existing databases and tables?

Thanks very much for the help.