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 | 65776000 | 65776000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 902 | 178484873000 | 1326458000 | 73151000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 902 | 84321682000 | 456902000 | 29263000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 900 | 5607082000 | 57342000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 26495 | 9760273448000 | 344293536000 | 3030771000000 | 78344 | 515353 | 0 | 13281 | |
root | show_fields | 1801 | 1808565009000 | 5834197000 | 663326000000 | 90083 | 456206 | 0 | 0 | |
root | show_variables | 1853 | 1573340097000 | 10756831000 | 162400000000 | 1853 | 1063622 | 0 | 1853 | |
root | show_keys | 1696 | 1238345802000 | 48414692000 | 582543000000 | 1834 | 18362 | 0 | 0 | |
root | set_option | 2924 | 186978364000 | 5887036000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 933 | 186931762000 | 1667324000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 158 | 106179211000 | 12982668000 | 47765000000 | 3604 | 11383 | 0 | 0 | |
root | Init DB | 986 | 41630062000 | 287972000 | 682000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 458 | 33363931000 | 368819000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 919 | 26406343000 | 94828000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1046 | 7497619000 | 587012000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 17 | 2910428000 | 1899489000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 2192 | 2075760000 | 430807000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 319 | 878929000 | 449767000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 432424000 | 222562000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 233285000 | 119924000 | 0 | 0 | 0 | 0 | 0 |
|