Optimisation

MySQL Tuner Script:

wget -O mysqltuner.pl mysqltuner.pl && perl mysqltuner.pl 

------------------------------------------------------------------------------------------------------------------------------------------------MyISAM v InnoDB

Check table engine: 

SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE  
FROM information_schema.TABLES  
WHERE ENGINE = 'MyISAM'; 

Table engine into text file 

mysql –e "SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE  
FROM information_schema.TABLES  
WHERE ENGINE = 'MyISAM';" > mysql_tableengine.txt 

------------------------------------------------------------------------------------------------------------------------------------------------