Optimisation

====================================================================================

MySQL Optimisation

====================================================================================

MySQL Tuner Script:Script

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

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

Implementing Variable Changes:Changes

/etc/my.cnf

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

MyISAM v InnoDB

InnoDB has row-level locking. MyISAM only has full table-level locking. 

Check table engine: 

SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE  

 
FROM information_schema.TABLES    
WHERE ENGINE = 'MyISAM'MyISAM'; 

TableList table engine intoin text filefile:

mysql

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

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

Changing Table Engine

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