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 | 2341481000 | 2341481000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 553 | 121849203000 | 620963000 | 49301000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 553 | 59019829000 | 707742000 | 20468000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 552 | 3638681000 | 47126000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 19842 | 10901757377000 | 1231772124000 | 2723733000000 | 63170 | 483512 | 0 | 4308 | |
root | show_keys | 786 | 1339161611000 | 122954805000 | 281962000000 | 363 | 6792 | 0 | 0 | |
root | show_fields | 581 | 492675861000 | 3770822000 | 225442000000 | 11812 | 61167 | 0 | 0 | |
root | show_variables | 476 | 449498805000 | 5335267000 | 41839000000 | 476 | 272804 | 0 | 476 | |
root | create_table | 2 | 446925099000 | 229435925000 | 5490000000 | 0 | 0 | 0 | 0 | |
root | set_option | 1601 | 157771352000 | 15485018000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 281 | 144581939000 | 3611500000 | 72325000000 | 3578 | 10870 | 0 | 0 | |
root | create_db | 1 | 85329037000 | 85329037000 | 2312000000 | 0 | 0 | 1 | 0 | |
root | show_create_table | 261 | 63539555000 | 2894514000 | 121000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 505 | 41286546000 | 688566000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 546 | 36753723000 | 327261000 | 3924000000 | 0 | 0 | 0 | 0 | |
root | freturn | 24351 | 32837428000 | 1242173000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 40585 | 25157809000 | 2014553000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 64 | 15515113000 | 7727588000 | 10949000000 | 33 | 232 | 0 | 0 | |
root | show_warnings | 172 | 6131211000 | 569631000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 684 | 4686664000 | 171953000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 46 | 4144583000 | 1322810000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 18 | 3189221000 | 2066889000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 11 | 3086921000 | 1669483000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 21 | 2178291000 | 324097000 | 1110000000 | 189 | 189 | 0 | 21 | |
root | stmt | 2 | 1774820000 | 1684572000 | 0 | 0 | 2 | 0 | 0 |
|