| 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'; |