SELECT * FROM `x$user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 3926666000 | 3926666000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 948 | 217956343000 | 1469970000 | 89581000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 894 | 102789867000 | 780095000 | 36070000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 956 | 6697764000 | 44652000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 17296 | 7071087054000 | 409500490000 | 2071164000000 | 71445 | 396378 | 0 | 7674 | |
root | drop_db | 26 | 5776037709000 | 1545877902000 | 18785000000 | 0 | 0 | 68 | 0 | |
root | show_keys | 1072 | 1878271154000 | 85891963000 | 370438000000 | 1917 | 20109 | 0 | 0 | |
root | show_fields | 1518 | 1499879719000 | 10973879000 | 552301000000 | 73852 | 374630 | 0 | 0 | |
root | show_variables | 1499 | 1276525510000 | 5722996000 | 136908000000 | 4853 | 860342 | 0 | 1499 | |
root | set_option | 3024 | 238262412000 | 8096194000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 219 | 134132908000 | 4385985000 | 67015000000 | 3705 | 11479 | 0 | 0 | |
root | show_create_table | 740 | 130311600000 | 1791832000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 687 | 48912884000 | 267744000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 924 | 47192029000 | 328428000 | 1713000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 4 | 32976515000 | 31940508000 | 1256000000 | 2 | 12 | 0 | 0 | |
root | show_warnings | 696 | 20066545000 | 113057000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 15067764000 | 14536257000 | 277000000 | 900 | 900 | 0 | 2 | |
root | Quit | 1098 | 10432269000 | 2122999000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 28 | 4696303000 | 636460000 | 1730000000 | 27 | 29 | 0 | 1 | |
root | show_binlogs | 58 | 3918174000 | 594135000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 28 | 3651039000 | 1014547000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 3 | 3569993000 | 3334090000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 13 | 2711420000 | 2020791000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 13 | 2411504000 | 1317975000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 1 | 1984924000 | 1984924000 | 1919000000 | 9 | 9 | 0 | 1 |
|