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 | 2287 | 534509913000 | 2330265000 | 219588000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2287 | 267195327000 | 530053000 | 93095000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2286 | 16138614000 | 86971000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 42016 | 17439853865000 | 511098814000 | 5144428000000 | 188055 | 1585342 | 0 | 21842 | |
root | drop_db | 31 | 6431885961000 | 1227823022000 | 24174000000 | 0 | 0 | 76 | 0 | |
root | alter_table | 8 | 3131051778000 | 432039776000 | 3567000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 2622 | 2343205361000 | 6354110000 | 240663000000 | 4828 | 1503201 | 0 | 2622 | |
root | show_fields | 2408 | 2157848810000 | 3702090000 | 919546000000 | 80911 | 413897 | 0 | 0 | |
root | create_table | 8 | 2157052218000 | 610872923000 | 2702000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 2146 | 2134285837000 | 79242097000 | 796665000000 | 2264 | 34516 | 0 | 0 | |
root | show_tables | 808 | 576294011000 | 4867886000 | 340646000000 | 7353 | 28277 | 0 | 0 | |
root | set_option | 7138 | 559948714000 | 10980976000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 15 | 482665444000 | 46418651000 | 2022000000 | 0 | 0 | 26 | 0 | |
root | create_db | 5 | 314470488000 | 94395073000 | 383000000 | 0 | 0 | 5 | 0 | |
root | Init DB | 2078 | 307381042000 | 182624657000 | 189995000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 1249 | 224000100000 | 5482783000 | 1563000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1697 | 148827414000 | 13027271000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 124 | 57305308000 | 2935941000 | 32213000000 | 140 | 758 | 0 | 0 | |
root | show_warnings | 1092 | 35294503000 | 286800000 | 0 | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 27754264000 | 27754264000 | 1475000000 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 20310748000 | 18289880000 | 421000000 | 900 | 900 | 0 | 2 | |
root | Quit | 2554 | 19156868000 | 262151000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 58 | 12660839000 | 867694000 | 4193000000 | 27 | 89 | 0 | 31 | |
root | Prepare | 58 | 11870504000 | 3184100000 | 0 | 0 | 0 | 0 | 0 |
|