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