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

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