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 | 992262000 | 992262000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 5192 | 783492692000 | 1266093000 | 321837000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 5112 | 342411304000 | 1555578000 | 123261000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 5150 | 30278239000 | 41525000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 218513 | 142826915004000 | 1480179184000 | 32540895000000 | 765954 | 5675640 | 0 | 70394 | |
root | show_fields | 11796 | 12080299549000 | 9926351000 | 4937817000000 | 411524 | 2103468 | 0 | 0 | |
root | show_keys | 13276 | 11085333821000 | 107099728000 | 5348683000000 | 13557 | 214083 | 0 | 0 | |
root | show_variables | 10058 | 9851112390000 | 666191314000 | 894619000000 | 11150 | 5771633 | 0 | 10058 | |
root | show_tables | 5978 | 3480443892000 | 5185984000 | 1821734000000 | 140404 | 412590 | 0 | 0 | |
root | create_table | 8 | 2449773521000 | 1171306006000 | 11988000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 5961 | 1291710644000 | 5809147000 | 1443000000 | 0 | 0 | 0 | 0 | |
root | set_option | 23224 | 1012730684000 | 3788278000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 37 | 986612115000 | 46667149000 | 6750000000 | 0 | 0 | 30 | 0 | |
root | create_db | 14 | 717687639000 | 86065393000 | 8063000000 | 0 | 0 | 13 | 0 | |
root | Init DB | 8150 | 377778698000 | 1119106000 | 13113000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 3135 | 258548354000 | 1531345000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 276692 | 213343563000 | 6234674000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 264 | 167485953000 | 68500620000 | 59640000000 | 254 | 2095 | 0 | 0 | |
root | show_warnings | 4777 | 157733190000 | 1922646000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 67150 | 75135076000 | 1815133000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 10313 | 68803316000 | 2048261000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 152 | 44686885000 | 15047485000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 25478499000 | 24977917000 | 242000000 | 900 | 900 | 0 | 2 | |
root | show_create_proc | 80 | 16455690000 | 2784658000 | 4195000000 | 0 | 0 | 0 | 0 | |
root | show_master_status | 110 | 10648280000 | 3024726000 | 0 | 0 | 0 | 0 | 0 |
|