Llamarada

Tomar de la élite lo que pertenece a todos

Find Your Slow Mysql Queries

| Comments

MySQL can show you what queries are taking the most time to run on your system, so that you can optimize if you need to do so So connect to the mysql cli (make sure the user mysql is running as has enough privileges) and then enable slow query as shown below:

Enabling MySQL slow query logging
1
2
mysql>  set global slow_query_log_file="/tmp/mysqld-slow.log";
mysql>  set global slow_query_log=1;

Comments