after a search in the forums and finding several people having the same problem, I can’t find a valid answer.
Server version: 5.5.30-30.2-log Percona Server (GPL), Release rel30.2, Revision 508
| long_query_time | 5000.000000 | milliseconds I think
I still get:
select * from lbtest;
Time: 130519 3:32:27
User@Host: jdbcReplication[jdbcReplication] @ [10.64.101.241]
Thread_id: 37942 Schema: view_hc Last_errno: 0 Killed: 0
Query_time: 0.000213 Lock_time: 0.000094 Rows_sent: 1 Rows_examined: 13 Rows_affected: 0 Rows_read: 13
and the logfiles is going to eat up the disk.
I would say, every statement is logged
How do I configure the percona Server to log only query which take longer “x” seconds?
I would assume
| slow_query_log | ON |
| slow_query_log_file | /path/to/logfile |
| long_query_time | 5000.000000 |
but that does not the trick.