| 1 |
# User@Host: percona-agent[percona-agent] @ localhost [] |
| 2 |
# Thread_id: 37911936 Schema: Last_errno: 0 Killed: 0 |
| 3 |
# Query_time: 0.004599 Lock_time: 0.000100 Rows_sent: 1473 Rows_examined: 1473 Rows_affected: 0 Rows_read: 1473 |
| 4 |
# Bytes_sent: 70092 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 |
| 5 |
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No |
| 6 |
# Filesort: No Filesort_on_disk: No Merge_passes: 0 |
| 7 |
# No InnoDB statistics available for this query |
| 8 |
SET timestamp=1413583349; |
| 9 |
SELECT TABLE_SCHEMA, TABLE_NAME, ROWS_READ, ROWS_CHANGED, ROWS_CHANGED_X_INDEXES FROM INFORMATION_SCHEMA.TABLE_STATISTICS; |
| 10 |
# User@Host: root[root] @ localhost [] |
| 11 |
# Thread_id: 57434695 Schema: cod7_plos15 Last_errno: 0 Killed: 0 |
| 12 |
# Query_time: 0.000022 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 |
| 13 |
# Bytes_sent: 1333 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 |
| 14 |
# QC_Hit: Yes Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No |
| 15 |
# Filesort: No Filesort_on_disk: No Merge_passes: 0 |
| 16 |
# No InnoDB statistics available for this query |
| 17 |
use cod7_plos15; |
| 18 |
SET timestamp=1413583349; |
| 19 |
SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field_info:bundle_extra:user:user'); |
| 20 |
# User@Host: root[root] @ localhost [] |
| 21 |
# Thread_id: 57434695 Schema: cod7_plos15 Last_errno: 0 Killed: 0 |
| 22 |
# Query_time: 0.005241 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 |
| 23 |
# Bytes_sent: 52 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 |
| 24 |
# InnoDB_trx_id: 3AC1F89B8 |
| 25 |
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No |
| 26 |
# Filesort: No Filesort_on_disk: No Merge_passes: 0 |
| 27 |
# InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 |
| 28 |
# InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 |
| 29 |
# InnoDB_pages_distinct: 8 |
| 30 |
SET timestamp=1413583349; |
| 31 |
UPDATE captcha_sessions SET timestamp='1413583348', solution='1' |
| 32 |
WHERE (csid = '28439'); |
| 33 |
# User@Host: percona-agent[percona-agent] @ localhost [] |
| 34 |
# Thread_id: 37911936 Schema: Last_errno: 0 Killed: 0 |
| 35 |
# Query_time: 0.011565 Lock_time: 0.000115 Rows_sent: 2146 Rows_examined: 2146 Rows_affected: 0 Rows_read: 2146 |
| 36 |
# Bytes_sent: 102084 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 |
| 37 |
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No |
| 38 |
# Filesort: No Filesort_on_disk: No Merge_passes: 0 |
| 39 |
# No InnoDB statistics available for this query |
| 40 |
SET timestamp=1413583349; |
| 41 |
SELECT TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, ROWS_READ FROM INFORMATION_SCHEMA.INDEX_STATISTICS; |