MySQL - Admin Button to Optimize Tables
Brought to you by:
canajun2eh,
yalnifj
Menu
▾
▴
#1123 MySQL - Admin Button to Optimize Tables
Every so often on the forums a performance issue comes up that is solved by running the optimize command on the MySQL database. Since it is a straight forward MySQL command, we should have an admin function within PGV to run this (if the database is MySQL). See http://yoast.com/wordpress/optimize-db/ for a similar tool for WordPress.
My only concern is someone doing so and trashing their MySQL DB's and blaming PGV for their carelessness in not backing up data prior to making any modifications to the tables. phpMyAdmin and MySQL warn that not even what may be considered routine maintenance should be performed without a backup.
Perhaps we should incorporate a backup routine in the process.
-Stephen