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 | 791 | 182777103000 | 1469970000 | 75156000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 737 | 85563459000 | 780095000 | 30067000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 799 | 5653483000 | 44652000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 14638 | 6225670626000 | 409500490000 | 1765990000000 | 61126 | 354196 | 0 | 6433 | |
root | drop_db | 26 | 5776037709000 | 1545877902000 | 18785000000 | 0 | 0 | 68 | 0 | |
root | show_keys | 912 | 1787662707000 | 85891963000 | 320762000000 | 1598 | 16843 | 0 | 0 | |
root | show_fields | 1274 | 1274586726000 | 10973879000 | 472914000000 | 60862 | 308844 | 0 | 0 | |
root | show_variables | 1248 | 1079596240000 | 5722996000 | 114909000000 | 4602 | 716268 | 0 | 1248 | |
root | set_option | 2511 | 203814025000 | 8096194000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 185 | 112194070000 | 4076497000 | 56134000000 | 3304 | 10271 | 0 | 0 | |
root | show_create_table | 618 | 110321083000 | 1791832000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 572 | 41227447000 | 267744000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 763 | 38966896000 | 328428000 | 1309000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 2 | 32737025000 | 31940508000 | 1118000000 | 2 | 12 | 0 | 0 | |
root | show_warnings | 582 | 17053899000 | 113057000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 15067764000 | 14536257000 | 277000000 | 900 | 900 | 0 | 2 | |
root | Quit | 913 | 9063546000 | 2122999000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 28 | 4696303000 | 636460000 | 1730000000 | 27 | 29 | 0 | 1 | |
root | Prepare | 28 | 3651039000 | 1014547000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 3 | 3569993000 | 3334090000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 46 | 3281895000 | 594135000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 10 | 2583960000 | 2020791000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 10 | 2193990000 | 1317975000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 1 | 1984924000 | 1984924000 | 1919000000 | 9 | 9 | 0 | 1 |
|