Quote:
Originally Posted by datetopia
If you just refer to managing existing databases and data you can make a script to run REPAIR and OPTIMIZE on all tables.
|
I am currently running about 100 domains in one server and each domain has its own database. Currently what I am doing is accessing the phpMyAdmin once a month using root account to view all databases one by one to see if the tables are having any overhead. If there are, then I will manual choose the tables and optimize it.
Do you have a sample of the script or where can I find such script to be able to assist optimization of all domains databases from the same server at once?
Thanks!