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 | 107933000 | 107933000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 762 | 164884703000 | 2000507000 | 65076000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 741 | 75452808000 | 310675000 | 25993000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 754 | 5308891000 | 43053000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 28448 | 14774157515000 | 707694222000 | 3751815000000 | 95730 | 1565127 | 0 | 8741 | |
root | show_keys | 1275 | 1872775421000 | 153177575000 | 478409000000 | 1262 | 21490 | 0 | 0 | |
root | show_fields | 1242 | 1126884224000 | 6394061000 | 465378000000 | 42224 | 215855 | 0 | 0 | |
root | show_variables | 1121 | 981448692000 | 9723823000 | 101058000000 | 1120 | 643265 | 0 | 1121 | |
root | show_tables | 642 | 508961765000 | 8920463000 | 262584000000 | 12767 | 35634 | 0 | 0 | |
root | set_option | 2878 | 223007958000 | 6147330000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 615 | 129047837000 | 12135269000 | 800000000 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 62391323000 | 62391323000 | 3211000000 | 0 | 0 | 1 | 0 | |
root | Init DB | 898 | 49150199000 | 964716000 | 3370000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 555 | 45982838000 | 823048000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 34495425000 | 21895218000 | 3546000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 43687 | 32177071000 | 1340001000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 159 | 29661656000 | 2223460000 | 16893000000 | 0 | 89 | 0 | 0 | |
root | update | 1 | 19362507000 | 19362507000 | 3992000000 | 0 | 1 | 0 | 0 | |
root | show_warnings | 523 | 16109424000 | 112205000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 11755 | 15237836000 | 1638207000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 9662990000 | 4080686000 | 5231000000 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 72 | 8601338000 | 2354196000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1218 | 8554337000 | 249475000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 16 | 8069347000 | 5862409000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 16 | 6652755000 | 5285966000 | 0 | 0 | 0 | 0 | 0 |
|