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 | 3392924000 | 3392924000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 92 | 14514835000 | 380530000 | 5863000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 92 | 5940255000 | 234312000 | 2091000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 87 | 461618000 | 16397000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 1586 | 1195005703000 | 342625343000 | 255201000000 | 5796 | 63491 | 0 | 865 | |
root | create_table | 1 | 610872923000 | 610872923000 | 149000000 | 0 | 0 | 0 | 0 | |
root | insert | 6 | 201084576000 | 41694646000 | 1027000000 | 0 | 0 | 6 | 0 | |
root | show_keys | 51 | 111742072000 | 38907708000 | 21123000000 | 42 | 629 | 0 | 0 | |
root | show_variables | 96 | 108632638000 | 5004170000 | 10481000000 | 96 | 55104 | 0 | 96 | |
root | show_fields | 53 | 61373815000 | 3051588000 | 24300000000 | 2131 | 10839 | 0 | 0 | |
root | create_db | 1 | 46998378000 | 46998378000 | 84000000 | 0 | 0 | 1 | 0 | |
root | set_option | 299 | 32956133000 | 10980976000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 47 | 12796019000 | 1497077000 | 7163000000 | 233 | 865 | 0 | 0 | |
root | show_create_table | 27 | 12080649000 | 5482783000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 101 | 8477224000 | 737374000 | 2162000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 87 | 6886667000 | 116421000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 35 | 5403403000 | 786271000 | 2862000000 | 0 | 0 | 0 | 0 | |
root | Prepare | 3 | 3568306000 | 3184100000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 38 | 1235038000 | 58972000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 3 | 1221476000 | 867694000 | 509000000 | 0 | 6 | 0 | 3 | |
root | Quit | 105 | 864345000 | 162673000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 4 | 607731000 | 404518000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 1 | 256575000 | 256575000 | 0 | 0 | 0 | 0 | 0 | |
root | change_db | 3 | 231648000 | 114752000 | 50000000 | 0 | 0 | 0 | 0 | |
root | Close stmt | 3 | 56429000 | 36552000 | 0 | 0 | 0 | 0 | 0 |
|