Optimize Overhead for database
Hi
Once awhile I will check using phpMyAdmin to check on individual database tables and find there are some overhead for some fields. So I will manual select them and click to optimize.
I find this method is a little troublesome as I have about 100 databases and going through one at a time to check if there are overhead and selecting them to optimize. This really takes up a lot of my time.
So I am wondering if there is a better method where I can do it automatically?
Any suggestion? Or this is the only method?
Thanks!
|