MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Performance bottlenecks with thousands of small databases
Posted by: Justin Keller
Date: March 19, 2014 11:15PM

Thanks, a little worried about running this on production with over 2,500 databases and 30,000 tables. Not even sure if this is going to help with our root problem. In fact, going to a single ibdata file may degrade performance further instead of improve it. Thoughts?

**Update**
I ran lsof -a -p 32297 | wc -l and wow, so many open file descriptors. 30,192.



Edited 1 time(s). Last edit at 03/19/2014 11:21PM by Justin Keller.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.