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 | 473358000 | 473358000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 519 | 114919950000 | 797323000 | 46099000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 519 | 54637914000 | 377166000 | 18870000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 519 | 4371749000 | 189139000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 12322 | 8143519766000 | 930955355000 | 1806856000000 | 60199 | 351088 | 0 | 3625 | |
root | show_keys | 380 | 2458555090000 | 164543163000 | 174602000000 | 464 | 6653 | 0 | 0 | |
root | show_variables | 351 | 356339902000 | 4377306000 | 31751000000 | 11571 | 200886 | 0 | 351 | |
root | create_table | 2 | 344080945000 | 198181154000 | 2232000000 | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 312602801000 | 76523251000 | 568000000 | 0 | 0 | 5 | 0 | |
root | show_fields | 325 | 299709083000 | 4442955000 | 134157000000 | 7641 | 39579 | 0 | 0 | |
root | show_tables | 350 | 219113774000 | 5456305000 | 122482000000 | 3817 | 13056 | 0 | 0 | |
root | insert | 2 | 146335589000 | 107854518000 | 1325000000 | 0 | 0 | 22 | 0 | |
root | set_option | 1713 | 138799250000 | 7292894000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 8 | 51533682000 | 41335663000 | 1661000000 | 3600 | 3600 | 0 | 8 | |
root | show_create_table | 189 | 43732008000 | 2328595000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 507 | 40302854000 | 512054000 | 5991000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 419 | 36514540000 | 271874000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 40432 | 27550626000 | 993706000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 29 | 12396150000 | 2328233000 | 7704000000 | 0 | 12 | 0 | 0 | |
root | freturn | 10358 | 11886359000 | 1020576000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 85 | 5919717000 | 833768000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 632 | 4589045000 | 155516000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 33 | 4462480000 | 476962000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 109 | 4166951000 | 179667000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 2 | 3618083000 | 3366529000 | 0 | 0 | 0 | 0 | 0 |
|