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 | 1208603000 | 1208603000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 125 | 31698167000 | 1990154000 | 13402000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 125 | 14492445000 | 401242000 | 4903000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 125 | 864252000 | 21641000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 3130 | 2554591136000 | 338034250000 | 402404000000 | 14580 | 69557 | 0 | 846 | |
root | show_keys | 173 | 754906929000 | 68611265000 | 68938000000 | 207 | 3180 | 0 | 0 | |
root | show_fields | 157 | 146520192000 | 4251144000 | 63202000000 | 4780 | 24539 | 0 | 0 | |
root | show_variables | 126 | 130411065000 | 6921615000 | 13846000000 | 126 | 72303 | 0 | 126 | |
root | set_option | 456 | 41830245000 | 7801362000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 63 | 40892892000 | 3500602000 | 19167000000 | 1254 | 3908 | 0 | 0 | |
root | show_create_table | 76 | 17229084000 | 2482562000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 91 | 6651304000 | 236747000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 118 | 6589663000 | 439199000 | 721000000 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 3 | 5422403000 | 5195409000 | 143000000 | 27 | 27 | 0 | 3 | |
root | jump_if_not | 7475 | 3842269000 | 220828000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 2074 | 2516520000 | 844925000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 55 | 2114433000 | 196622000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 178 | 1200972000 | 147893000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 13 | 1167282000 | 516168000 | 0 | 0 | 0 | 0 | 0 |
|