If there are some unused databases on MySQL server is it better to remove those from server?
+4
A:
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.
ChrisF
2010-06-30 09:56:08
I also suppose it shouldn't, but needed more of a "sure" answer.
f13o
2010-06-30 10:14:39
When ChrisF says "shouldn't", he says that because it's just possible there might be a difference (the internal tables will be a bit bigger, there might be an issue with disk fragmentation, that sort of thing), but if your disk is large enough don't worry about it, because any difference is extremely unlikely to be visible to the naked eye.
Brian Hooper
2010-06-30 14:18:24