MySQL® Database Design and Tuning

MySQL® Database Design and Tuning ...great book. Very helpful. At least read chapters 9 and 12 you'll find items to put into practice, e.g.:

Alter Table <tablename> ENGINE = Innodb; -- to defragment a table

SET AUTOCOMMIT = 0 ; -- for long running db intensive i/o activities