Question : I need some help understanding what’s going on with my “slow query” log in MySQL. I have set […]
Tag: slow-log
mysql user host field in slow query log
Question : Mysql shows the following value in the slow query log # User@Host: user[user] @ [127.0.0.1] I’m assuming one […]
Delete Slow Query Log File
Question : I was logging slow queries of my system. Now I have few queries to be optimized and reset […]
Reviewing all new MySql queries on staging environment
Question : The problem I am trying to solve: It’s well known that not all developers know what is EXPLAIN […]
Write a slow query to test slow query logging?
Question : Is there a simple query that would take > 2 sec so that I can test the slow […]
Identify slow query without slow query logs in mysql server
Question : I am wondering is there any other way to to check our slow queries without logging slow query. […]
How to properly debug and inspect SQL Queries in PHP File?
Question : My website AdminPanel has a PHP file which takes almost 30-40 seconds in loading. I doubt the queries […]
MySQL Explain has different row count than slow query log
Question : I have this entry in slow query log: # User@Host: user[host] @ [ip] # Thread_id: 1514428 Schema: db […]
mysqldump select queries appearing in slow query log after upgrade
Question : We recently upgraded from MariaDB 5.5 to MariaDB 10.5 Since doing so, we have a couple of select […]
Enabling “log_queries_not_using_indexes” disables “long_query_time”?
Question : I noticed that, in Mysql, when enabling log_queries_not_using_indexes, slow_query_log and long_query_time, the generated slow query log file will […]