开发者

Does unused database hurt MySQL server performance in any way?

开发者 https://www.devze.com 2023-01-05 09:14 出处:网络
If there are some unu开发者_运维问答sed databases on MySQL server is it better to remove those from server?If they\'re unused then by all means remove them.

If there are some unu开发者_运维问答sed databases on MySQL server is it better to remove those from server?


If they're unused then by all means remove them.

However, leaving them around shouldn't hurt day-to-day performance as they aren't referenced by any application.

They will have an impact on the server performance in areas such as backups etc. as they are more data that has to be checked and copied etc.


Yes it CAN hurt performance because it will mean more RAM is being used and if you are low on RAM this can cause issues.

For example, lets say you have website_new and unused website_old databases. If you had innodb pool set to 3GB then you would need to increase that if the website_old is left sitting there.

Keeping old DBs around will force you to skew your my.cnf config to maintain performance.

hope this helps

0

精彩评论

暂无评论...
验证码 换一张
取 消