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 | 107933000 | 107933000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1773 | 381147775000 | 2000507000 | 153042000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1638 | 173394075000 | 1097341000 | 59376000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1710 | 11692679000 | 43053000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 61218 | 32110095581000 | 758044163000 | 7994296000000 | 196550 | 2470999 | 0 | 18267 | |
root | alter_table | 32 | 9541221555000 | 585909179000 | 30367000000 | 0 | 0 | 1907 | 0 | |
root | show_keys | 2886 | 3532376877000 | 153177575000 | 1069071000000 | 2787 | 48557 | 0 | 0 | |
root | create_table | 24 | 3027811511000 | 249514068000 | 11372000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 2841 | 2626819547000 | 6394061000 | 1079558000000 | 99273 | 507511 | 0 | 0 | |
root | show_variables | 2612 | 2234816702000 | 9723823000 | 231403000000 | 3161 | 1498742 | 0 | 2612 | |
root | show_tables | 1325 | 1026904577000 | 8920463000 | 536946000000 | 27037 | 76437 | 0 | 0 | |
root | insert | 29 | 899039083000 | 87374118000 | 54477000000 | 0 | 0 | 1293 | 0 | |
root | set_option | 6445 | 461286149000 | 6147330000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 1401 | 292507471000 | 12135269000 | 800000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 2003 | 105657470000 | 964716000 | 5340000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1162 | 94187339000 | 823048000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 148665 | 91282741000 | 1340001000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 62391323000 | 62391323000 | 3211000000 | 0 | 0 | 1 | 0 | |
root | delete | 2 | 57178000000 | 31683360000 | 59000000 | 0 | 2 | 2 | 0 | |
root | show_status | 1 | 47442165000 | 47442165000 | 330000000 | 450 | 450 | 0 | 1 | |
root | show_table_status | 192 | 42553882000 | 2223460000 | 25342000000 | 0 | 111 | 0 | 0 | |
root | freturn | 36478 | 38296139000 | 1638207000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1202 | 37305526000 | 214654000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 34495425000 | 21895218000 | 3546000000 | 0 | 0 | 0 | 0 | |
root | update | 1 | 19362507000 | 19362507000 | 3992000000 | 0 | 1 | 0 | 0 |
|