Does having many databases affect MySQL performance?
-
I have huge unused databases in MySQL. Do they affect my MySQL engine performance even if they are unused? Do they consume memory on their own? Thanks
-
Answer:
The only performance hit I can see is on the INFORMATION_SCHEMA database (See my post http://dba.stackexchange.com/questions/3335/how-is-information-schema-implemented-in-mysql/3336#3336) If you have queries that poll for the existence of tables, gets the table sizes (Example: See my post http://dba.stackexchange.com/questions/8661/mysql-workbench-database-sizes/8662#8662), and things of this nature, MySQL will spend time sifting through the OS for such metadata. Getting metadata on InnoDB tables and partitioned MyISAM tables will make the INFORMATION_SCHEMA take the worst hit as it must open many file handles. Other than that, you regular queries on your working dataset should be fine.
perpetual_dream at Database Administrators Visit the source
Related Q & A:
- How to completely backup all mysql databases?Best solution by Server Fault
- Why Can't I find my databases from Mysql on linux?Best solution by Database Administrators
- How can information systems affect a company’s bottom line (such as financial performance?Best solution by Yahoo! Answers
- How can an I.S. department affect a company's bottom line,like their performance?Best solution by Yahoo! Answers
- How many different career fields do human relations and interpersonal skills affect?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.