Ning Ma blog

my technology tips

MYSQL

MySQL’s query cache vs memcached

I did some research about MySQL’s query cache. Some people said it will speed up page load times by 5-15%. Query cache is used to cache SELECT results and later return them without actual executing the same query once again. Having the query cache enabled may result in significant speed improvements, But if tables change […]

check mysql tem files and tables

Try to execute show processlist;, maybe there are some long lasting threads that were not killed for some reason. Similarly execute SHOW SESSION STATUS LIKE ‘Created%’; to check if mysql hasn’t created to many temporary tables. Server restart automatically closes all open temp tables and kills threads, so the application might run quicker.

dump and import mysql database avoid error codes