Our database is loaded by full-text search requests. The problem was that MySQL server CPU usage was constantly about 100% with close to 0% of Memory usage. research brought me to the article Mysql full text search cause high usage CPU Among answers I found an interesting tool mysqltuner.pl Get the script and run $… Continue reading MySQL database optimisation