MySQL Maintenance Tasks for InnoDB with MySQL 5.1
MySQL Maintenance Tasks for InnoDB with MySQL 5.1by LAURENCE posted on JULY 22, 2011From time to time, MySQL 5.1 databases need a little house keeping. We found our production DB had a hard time running a simple join query between two tables with about 400k rows. It was taking between 30 and 100 seconds to run. On QA however, it was taking 58 milliseconds. The columns involved were already index..
2015.08.13