Musings of a Manchester Drupal guy

Drupal, Open Source, Analytics, Social Media.

Thursday, March 09, 2006

Programatically optimising tables in mysql with sql

LOCK TABLE ec_products READ;
OPTIMIZE TABLE ec_products;
UNLOCK TABLES;