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 | 60392000 | 60392000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 692 | 138821607000 | 740827000 | 55468000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 692 | 65427609000 | 666904000 | 23055000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 691 | 4543806000 | 36554000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 24386 | 12933957318000 | 456168715000 | 3470911000000 | 65090 | 695212 | 0 | 6518 | |
root | drop_db | 26 | 5198287064000 | 1059795268000 | 4069000000 | 0 | 0 | 68 | 0 | |
root | show_keys | 877 | 1415808870000 | 98400053000 | 322808000000 | 809 | 15301 | 0 | 0 | |
root | show_fields | 857 | 810931980000 | 4638222000 | 325660000000 | 33127 | 168951 | 0 | 0 | |
root | show_variables | 906 | 794398110000 | 5529823000 | 78826000000 | 906 | 519981 | 0 | 906 | |
root | show_tables | 421 | 305848887000 | 6007552000 | 154964000000 | 9968 | 30503 | 0 | 0 | |
root | create_table | 1 | 220958687000 | 220958687000 | 3193000000 | 0 | 0 | 0 | 0 | |
root | set_option | 2443 | 171605943000 | 11178566000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 427 | 101009835000 | 7009173000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 1 | 54223119000 | 54223119000 | 2762000000 | 0 | 0 | 15 | 0 | |
root | Init DB | 738 | 48998564000 | 981915000 | 8114000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 56636 | 39546016000 | 1966976000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 37354852000 | 37354852000 | 1852000000 | 0 | 0 | 1 | 0 | |
root | show_grants | 452 | 35311402000 | 267846000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 14802 | 21866184000 | 4579214000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 167 | 20514491000 | 682850000 | 10781000000 | 0 | 136 | 0 | 0 | |
root | show_warnings | 394 | 12480439000 | 172936000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 33 | 8329377000 | 2170049000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 7816043000 | 1005539000 | 1502000000 | 0 | 0 | 0 | 0 | |
root | Quit | 1043 | 6986618000 | 245379000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 4751729000 | 491435000 | 1157000000 | 0 | 0 | 0 | 0 |
|