Question : Using LEMP on popular cloud-service virtual server, with MyISAM tables. The problem is that sometimes once in few […]
Tag: slow-log
slow log contains query, but query time is less than long_query_time
Question : mysql> select @@long_query_time; +——————-+ | @@long_query_time | +——————-+ | 2.000000 | +——————-+ 1 row in set (0.00 sec) […]
simple query is not using indexes
Question : My query is not using indexes. it was taking around 5 seconds. output is 500 rows only. it […]
MySql Not Logging Slow Queries
Question : I’ve set up slow query logging for MySQL 5.7: [mysqld] slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow_query_log.log long_query_time = […]
How To Exclude Queries Returned From mysqldumpslow Command
Question : I would like to ignore queries in the mysql-slow log that originate from running the command mysqldumpslow by […]
How to manage a growing MySQL slow_log table?
Question : I see MySQL supports storing slow_log as a table (internally using mysql/slow_log.CSV file), and this appears convenient, but […]
MySQL slow_log table: querying takes forever
Question : I’m running a query on the slow_log: SELECT start_time FROM mysql.slow_log WHERE start_time < TIMESTAMP ‘2016-01-31 00:00:00’ Without […]
time executing inserts + slow SSH
Question : _ Hello, my setup is a slow SSH to some linux machine. From there I start a mysql […]
optimize wordpress mysql queries for millions of rows
Question : I run a wordpress woocommcerce site with millions of rows in tables. After I made partition, there still […]
Why would mysql “show global status” query be taking 15 minutes?
Question : I’m reviewing the slow log, and on one of my slaves the average time for SHOW GLOBAL STATUS […]