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 | 1230336000 | 1230336000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 904 | 230283864000 | 619363000 | 93815000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 904 | 115524505000 | 389719000 | 39400000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 904 | 6377059000 | 50667000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 13714 | 7047263470000 | 205179585000 | 1938313000000 | 77799 | 722577 | 0 | 7149 | |
root | show_keys | 614 | 1474195938000 | 128555224000 | 256819000000 | 1020 | 11643 | 0 | 0 | |
root | show_fields | 800 | 807996036000 | 5320855000 | 351994000000 | 24371 | 124932 | 0 | 0 | |
root | show_variables | 759 | 693717121000 | 3986476000 | 70550000000 | 748 | 434679 | 0 | 759 | |
root | create_table | 3 | 646056308000 | 257658836000 | 2633000000 | 0 | 0 | 0 | 0 | |
root | set_option | 2726 | 250535975000 | 5809065000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 241 | 177888975000 | 2776181000 | 114018000000 | 1545 | 4920 | 0 | 0 | |
root | create_db | 1 | 95670186000 | 95670186000 | 4809000000 | 0 | 0 | 1 | 0 | |
root | show_create_table | 396 | 79101519000 | 9768133000 | 477000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 702 | 63616315000 | 436788000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 720 | 46096108000 | 425422000 | 1877000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 44 | 30489630000 | 3118565000 | 17629000000 | 60 | 352 | 0 | 0 | |
root | show_create_func | 116 | 18603264000 | 7694906000 | 4580000000 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 130 | 15042779000 | 2063375000 | 1543000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 281 | 13922306000 | 5090294000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 53 | 9793143000 | 2337942000 | 3593000000 | 477 | 477 | 0 | 53 | |
root | Quit | 913 | 7484434000 | 212825000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 11 | 3467693000 | 1711319000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 39 | 2782456000 | 437510000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 24 | 2633667000 | 274030000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 11 | 2262362000 | 421000000 | 674000000 | 0 | 22 | 0 | 11 |
|