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 | 1191431000 | 1191431000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 2224 | 433425451000 | 2525643000 | 177568000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2224 | 198446487000 | 1377016000 | 69865000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2223 | 21472041000 | 6983353000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 99678 | 59087075838000 | 1002952477000 | 13136910000000 | 300070 | 2991493 | 0 | 27978 | |
root | show_keys | 5078 | 5249645744000 | 442734558000 | 2325885000000 | 5167 | 87766 | 0 | 0 | |
root | show_fields | 4579 | 4300477235000 | 8226645000 | 1763115000000 | 160721 | 821663 | 0 | 0 | |
root | show_variables | 3926 | 3384904637000 | 17985160000 | 343510000000 | 3924 | 2252663 | 0 | 3926 | |
root | show_tables | 2446 | 1767680464000 | 4810436000 | 932722000000 | 49653 | 143598 | 0 | 0 | |
root | set_option | 9458 | 573563330000 | 6695753000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 2296 | 485580339000 | 16005103000 | 687000000 | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 283288763000 | 59360842000 | 5220000000 | 0 | 0 | 6 | 0 | |
root | jump_if_not | 338445 | 219207154000 | 1246044000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 185700361000 | 139737787000 | 32352000000 | 7 | 332 | 0 | 0 | |
root | create_table | 1 | 163041239000 | 163041239000 | 3960000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 3292 | 160672346000 | 347986000 | 6207000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1910 | 147895318000 | 1283441000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 3 | 93704203000 | 39017249000 | 548000000 | 0 | 0 | 3 | 0 | |
root | freturn | 79363 | 78809639000 | 852367000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1861 | 58501049000 | 228793000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 4124 | 27784391000 | 229245000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 11764313000 | 3633462000 | 4371000000 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 39 | 9806710000 | 4679129000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 5 | 7446203000 | 2405328000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 58 | 7387826000 | 4651577000 | 0 | 0 | 0 | 0 | 0 |
|