Optimisation

MySQL Tuner Script:

 

 

 

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

Check whichtable tablesengine: are using MYISAM and print to file:

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 

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