Top "Mysql-slow-query-log" questions

a log of SQL statements that took more than `long_query_time` seconds to execute that are automatically saved to mysql.

Why I could not alter the variable long_query_time variable at runtime

I am using MySQL version 5.1.66. I saw that the long_query_time variable is dynamic, but when I tried set …

mysql mysql-slow-query-log
mysql 5.7 log-slow-queries error

I'm trying to enable Slow Query Logging on mysql 5.7 and getting this error: 2016-04-27T14:55:51.934612Z 0 [ERROR] unknown variable …

mysql my.cnf mysql-slow-query-log
How to interpret slow query log information generated by MySQL?

So my understanding of slow query log is that it logs info about all those queries that took >= time (…

mysql database-performance mysql-slow-query-log
mysql view super slow

this is the query for Unified Medical Language System(UMLS) to find a word related to normalized word. this query …

mysql sql database mysql-slow-query-log
Why does `log_slow_queries` break `my.cnf`?

Why can't I use slow_query_log on MySQL 5.6 on CentOS 6.4? [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/…

mysql performance my.cnf mysql-slow-query-log
Automatic kill/timeout slow queries in MySQL

Is there some configuration that can be done at MySQL side to automatically kill or timeout queries that are extremely …

mysql performance mysql-slow-query-log
MySQL SUM Query is extremely slow

There is a table called transactions with ~6 million rows. Below query counts the current user balance. Here is the log …

mysql performance mysql-slow-query-log
How to flush data from mysql.slow_log table in mysql?

Hi i am working on MySQL version 5.5, can somebody please help me to clear/flush data from mysql.slow_log …

mysql mysql-workbench mysql-slow-query-log