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 | 4589 | 695010802000 | 1266093000 | 286125000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 4509 | 303680002000 | 998897000 | 109654000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 4549 | 26862287000 | 41525000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 192492 | 124616446516000 | 1480179184000 | 28618063000000 | 668261 | 4810990 | 0 | 61737 | |
root | show_fields | 10273 | 10456370548000 | 9926351000 | 4285844000000 | 358358 | 1831588 | 0 | 0 | |
root | show_keys | 11581 | 9752537935000 | 107099728000 | 4655944000000 | 11739 | 185033 | 0 | 0 | |
root | show_variables | 8851 | 8733180195000 | 666191314000 | 782754000000 | 9944 | 5078962 | 0 | 8851 | |
root | show_tables | 5175 | 2999370886000 | 5185984000 | 1569787000000 | 121654 | 350517 | 0 | 0 | |
root | create_table | 8 | 2449773521000 | 1171306006000 | 11988000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 5191 | 1121621469000 | 5809147000 | 1053000000 | 0 | 0 | 0 | 0 | |
root | insert | 36 | 981998806000 | 46667149000 | 4300000000 | 0 | 0 | 30 | 0 | |
root | set_option | 20432 | 894378885000 | 3788278000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 13 | 667128403000 | 86065393000 | 6057000000 | 0 | 0 | 12 | 0 | |
root | Init DB | 7115 | 329245881000 | 1119106000 | 12318000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2775 | 228210413000 | 1531345000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 238721 | 187367120000 | 6234674000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 4188 | 136584233000 | 1317271000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 228 | 78714548000 | 2952862000 | 46610000000 | 171 | 1519 | 0 | 0 | |
root | freturn | 58491 | 66738605000 | 1815133000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 9062 | 59473313000 | 558250000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 139 | 39064075000 | 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_create_func | 67 | 10429623000 | 2152114000 | 1076000000 | 0 | 0 | 0 | 0 |
|