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 | 1686459000 | 1686459000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 3549 | 777824145000 | 19578302000 | 314451000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 3549 | 359622441000 | 1322371000 | 125181000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 3551 | 24231689000 | 53604000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 101311 | 46254323544000 | 973484393000 | 13828196000000 | 297010 | 2560590 | 0 | 31765 | |
root | alter_table | 84 | 34872935094000 | 1405441863000 | 42430000000 | 0 | 0 | 174 | 0 | |
root | create_table | 56 | 10971255469000 | 462903760000 | 303758000000 | 0 | 0 | 0 | 0 | |
root | drop_db | 33 | 6655972778000 | 952582729000 | 25220000000 | 0 | 0 | 86 | 0 | |
root | show_fields | 4799 | 4573851395000 | 12791349000 | 1835398000000 | 183883 | 938163 | 0 | 0 | |
root | show_variables | 5154 | 4446725263000 | 8692604000 | 458548000000 | 6800 | 2957220 | 0 | 5154 | |
root | show_keys | 4493 | 4324010070000 | 120330298000 | 1642194000000 | 4628 | 84682 | 0 | 0 | |
root | show_tables | 2329 | 2522014495000 | 866374678000 | 1756815000000 | 44515 | 129979 | 0 | 0 | |
root | insert | 44 | 1477764578000 | 113308643000 | 24253000000 | 0 | 0 | 505 | 0 | |
root | set_option | 12883 | 898492106000 | 15928555000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 2388 | 725111168000 | 139866578000 | 3177000000 | 0 | 0 | 0 | 0 | |
root | create_db | 13 | 544187077000 | 66310888000 | 3223000000 | 0 | 0 | 13 | 0 | |
root | Init DB | 3705 | 451647023000 | 244174996000 | 262409000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2109 | 169197905000 | 970728000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 266218 | 165816194000 | 891696000 | 0 | 0 | 0 | 0 | 0 | |
root | create_trigger | 2 | 118677617000 | 66773969000 | 2331000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 444 | 97772254000 | 2356269000 | 59247000000 | 66 | 698 | 0 | 0 | |
root | show_warnings | 2265 | 73665071000 | 781522000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 61338 | 57867094000 | 1999919000 | 0 | 0 | 0 | 0 | 0 | |
root | delete | 2 | 45365814000 | 25887875000 | 2378000000 | 0 | 6 | 2 | 0 | |
root | Quit | 5315 | 35042462000 | 281652000 | 0 | 0 | 0 | 0 | 0 |
|