Debian Codegraph @

test/slow-logs/slow013.log

raw
1 # Time: 140224 22:39:34
2 # User@Host: root[root] @ localhost [] Id: 208333
3 # Schema: db950 Last_errno: 0 Killed: 0
4 # Query_time: 21.876617 Lock_time: 0.002991 Rows_sent: 1605306 Rows_examined: 1605306 Rows_affected: 1605306
5 # Bytes_sent: 14
6 use db950;
7 SET timestamp=1393281574;
8 select 950,q.* from qcm q INTO OUTFILE '/mnt/pct/exp/qcm_db950.txt';
9 # Time: 140224 22:39:59
10 # User@Host: root[root] @ localhost [] Id: 208345
11 # Schema: db961 Last_errno: 0 Killed: 0
12 # Query_time: 20.304536 Lock_time: 0.103324 Rows_sent: 1197472 Rows_examined: 1197472 Rows_affected: 1197472
13 # Bytes_sent: 14
14 use db961;
15 SET timestamp=1393281599;
16 select 961,q.* from qcm q INTO OUTFILE '/mnt/pct/exp/qcm_db961.txt';
17 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
18 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
19 Time Id Command Argument
20 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
21 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
22 Time Id Command Argument
23 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
24 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
25 Time Id Command Argument
26 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
27 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
28 Time Id Command Argument
29 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
30 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
31 Time Id Command Argument
32 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
33 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
34 Time Id Command Argument
35 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
36 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
37 Time Id Command Argument
38 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
39 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
40 Time Id Command Argument
41 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
42 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
43 Time Id Command Argument
44 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
45 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
46 Time Id Command Argument
47 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
48 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
49 Time Id Command Argument
50 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
51 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
52 Time Id Command Argument
53 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
54 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
55 Time Id Command Argument
56 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
57 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
58 Time Id Command Argument
59 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
60 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
61 Time Id Command Argument
62 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
63 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
64 Time Id Command Argument
65 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
66 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
67 Time Id Command Argument
68 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
69 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
70 Time Id Command Argument
71 /usr/local/Percona-Server-5.6-r518-46-tokudb.generic.x86_64/bin/mysqld, Version: 5.6.15-62.0-tokudb-7.1.0-tokudb-log (binary). started with:
72 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
73 Time Id Command Argument
74 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
75 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
76 Time Id Command Argument
77 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
78 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
79 Time Id Command Argument
80 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
81 Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
82 Time Id Command Argument
83 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
84 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
85 Time Id Command Argument
86 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
87 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
88 Time Id Command Argument
89 # Time: 140311 16:07:40
90 # User@Host: debian-sys-maint[debian-sys-maint] @ localhost [] Id: 50
91 # Schema: Last_errno: 1146 Killed: 0
92 # Query_time: 94.381440 Lock_time: 0.000174 Rows_sent: 0 Rows_examined: 17799 Rows_affected: 1
93 # Bytes_sent: 11
94 SET timestamp=1394554060;
95 select count(*) into @discard from `information_schema`.`PARTITIONS`;
96 /usr/sbin/mysqld, Version: 5.6.16-64.0-1.precise-log ((Ubuntu)). started with:
97 Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
98 Time Id Command Argument
99 # Time: 140312 20:28:40
100 # User@Host: root[root] @ localhost [] Id: 45006
101 # Schema: db1 Last_errno: 0 Killed: 0
102 # Query_time: 407.540262 Lock_time: 0.122377 Rows_sent: 34621308 Rows_examined: 34621308 Rows_affected: 34621308
103 # Bytes_sent: 19
104 use db1;
105 SET timestamp=1394656120;
106 select 1,q.* from qcm q INTO OUTFILE '/mnt/pct/exp/qcm_db1.txt';
107 # Time: 140312 20:29:40
108 # User@Host: root[root] @ localhost [] Id: 45321
109 # Schema: db1006 Last_errno: 0 Killed: 0
110 # Query_time: 60.507698 Lock_time: 0.002719 Rows_sent: 4937738 Rows_examined: 4937738 Rows_affected: 4937738
111 # Bytes_sent: 14
112 use db1006;
113 SET timestamp=1394656180;
114 select 1006,q.* from qcm q INTO OUTFILE '/mnt/pct/exp/qcm_db1006.txt';