CODEWITHSUNDEEP
mysql
semmelbroesel
semmelbroesel

Reputation: 557

MySQL Slow Log issues - long_query_time does not go into effect

I have followed a few tutorials in tracking down slow queries through the slow query log.

I have tried changing long_query_time to the value of 1 for testing purposes, but whatever I do, a query only makes it into the log when the default time of 10 is reached.

I tried:

set @@GLOBAL.long_query_time = 1;
set global long_query_time = 1;

When using either of these commands:

show variables like '%long%';
show global variables like '%long%';

I get the result that the variable was changed.

I have the exact same query running, just adding more LEFT JOIN entries to make it run longer. Whenever the query runs 10 seconds or longer, it is logged, but it does NOT show up in the log when it runs less than that, even though all my variables appear to say they are changed.

I am logged into MySQL as root as I make these changes.

I restarted Apache and MySQL, still no dice.

My version information is:

Server version: 5.1.63-log SUSE MySQL RPM

When I query both the session and the global variables (I tried both), I get this:

mysql> show variables like '%long%';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| long_query_time    | 1.000000 |
| max_long_data_size | 1048576  |
+--------------------+----------+
2 rows in set (0.00 sec)

mysql> show global variables like '%long%';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| long_query_time    | 1.000000 |
| max_long_data_size | 1048576  |
+--------------------+----------+
2 rows in set (0.00 sec)

The general logging feature is obviously on, and it is redirected to TABLE or I wouldn't get an entry in the log at all.

The setting log_queries_not_using_indexes if turned on starts logging EVERY query even if it does not take 1 second to execute.

What am I missing?

Thanks!

Upvotes: 2

Views: 4737

Answers (1)

DShost
DShost

Reputation: 473

The configuration below turns MySQL to log queries which execution time is more than half second:

slow_query_log = 1
long_query_time = 0.5
log-slow-queries = /var/log/mysql/log-slow-queries.log
log_queries_not_using_indexes = 0

Upvotes: 1

Related Questions