Most webmasters can have the problem that some tables aren't optimized or have overhead. This will cauze your server/VPS to work slower than usual since it can't use all it's resources. If you do this command once a week then you should be fine and your databases would stay optimized ...