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 | 1700566000 | 1700566000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1402 | 263457297000 | 5791004000 | 107041000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1402 | 113231947000 | 410985000 | 40324000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1401 | 9351334000 | 103934000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 46592 | 22158422974000 | 180269961000 | 6402506000000 | 180455 | 1603361 | 0 | 17295 | |
root | show_fields | 2475 | 2490027101000 | 9182968000 | 1012417000000 | 89767 | 457491 | 0 | 0 | |
root | show_variables | 2411 | 2167676866000 | 4442475000 | 223919000000 | 2409 | 1383452 | 0 | 2411 | |
root | show_keys | 2832 | 2058966848000 | 52988472000 | 1089952000000 | 2131 | 29860 | 0 | 0 | |
root | create_table | 8 | 1315760388000 | 223561546000 | 9208000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 918 | 596428017000 | 4711092000 | 318992000000 | 21385 | 51514 | 0 | 0 | |
root | set_option | 5237 | 333083751000 | 23305107000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 1249 | 259958829000 | 2594774000 | 102000000 | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 123389903000 | 66569881000 | 3639000000 | 0 | 0 | 2 | 0 | |
root | Init DB | 1677 | 85682282000 | 2157268000 | 5107000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1012 | 82791152000 | 1053593000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1142 | 36633695000 | 148603000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 26605806000 | 3868190000 | 17079000000 | 45 | 272 | 0 | 0 | |
root | set | 646 | 26208163000 | 1575857000 | 0 | 0 | 123 | 0 | 0 | |
root | jump_if_not | 25686 | 23358823000 | 715390000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 2085 | 15422516000 | 318522000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 6112 | 10570504000 | 34783000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 52 | 10358602000 | 2315768000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 10199106000 | 2692214000 | 2632000000 | 0 | 0 | 0 | 0 | |
root | stmt | 23 | 7653166000 | 2167858000 | 0 | 0 | 23 | 0 | 0 | |
root | show_create_func | 22 | 3944920000 | 674459000 | 877000000 | 0 | 0 | 0 | 0 |
|