Debian Codegraph @

test/slow-logs/slow023.log

raw
1 /usr/sbin/mysqld, Version: 5.6.19-1~dotdeb.1-log ((Debian)). started with:
2 Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
3 Time Id Command Argument
4 # User@Host: bookblogs[bookblogs] @ localhost [] Id: 56601
5 # Query_time: 0.321092 Lock_time: 0.000038 Rows_sent: 0 Rows_examined: 0
6 use dbnamea;
7 SET timestamp=1415210700;
8 SELECT field FROM table_a WHERE some_other_field = 'yahoo' LIMIT 1;
9 # User@Host: bookblogs[bookblogs] @ localhost [] Id: 56604
10 # Query_time: 0.253052 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
11 SET timestamp=1415210700;
12 SET NAMES utf8;
13 # User@Host: percona-agent[percona-agent] @ localhost [] Id: 56603
14 # Query_time: 0.316450 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
15 SET timestamp=1415210700;
16 SET GLOBAL slow_query_log=ON;
17 # User@Host: bookblogs[bookblogs] @ localhost [] Id: 56604
18 # Query_time: 0.000037 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
19 SET timestamp=1415210700;
20 SELECT @@SESSION.sql_mode;
21 # User@Host: bookblogs[bookblogs] @ localhost [] Id: 56601
22 # Query_time: 0.000297 Lock_time: 0.000141 Rows_sent: 1 Rows_examined: 1
23 SET timestamp=1415210700;
24 SELECT field FROM table_b WHERE another_field = 'bazinga' AND site_id = 1;
25 # User@Host: backup[backup] @ localhost [] Id: 56458
26 # Query_time: 0.000558 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
27 SET timestamp=1415210700;
28 use `dbnameb`;
29 # User@Host: backup[backup] @ localhost [] Id: 56458
30 # Query_time: 0.000204 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
31 SET timestamp=1415210700;
32 select @@collation_database;
33 # User@Host: bookblogs[bookblogs] @ localhost [] Id: 56601
34 # Query_time: 0.000164 Lock_time: 0.000059 Rows_sent: 1 Rows_examined: 1
35 SET timestamp=1415210700;
36 SELECT another_field FROM table_c WHERE a_third_field = 'tiruriru' AND site_id = 1;