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 | 2604161000 | 2604161000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 853 | 198633737000 | 1325919000 | 81003000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 853 | 98665668000 | 571681000 | 33622000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 852 | 6447502000 | 47599000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 15927 | 7851978787000 | 613709433000 | 2207856000000 | 82184 | 500603 | 0 | 6015 | |
root | show_keys | 525 | 1142166020000 | 94838578000 | 189261000000 | 682 | 8236 | 0 | 0 | |
root | set_option | 2704 | 651501769000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_variables | 639 | 602196554000 | 6889023000 | 59072000000 | 637 | 366282 | 0 | 639 | |
root | show_fields | 565 | 530564535000 | 3797688000 | 215282000000 | 20865 | 106399 | 0 | 0 | |
root | create_table | 2 | 523948986000 | 350272483000 | 3007000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 497 | 349597841000 | 3444090000 | 216613000000 | 2837 | 8969 | 0 | 0 | |
root | create_db | 11 | 304240267000 | 64943844000 | 626000000 | 0 | 0 | 6 | 0 | |
root | show_table_status | 86 | 59897588000 | 3225308000 | 40602000000 | 0 | 88 | 0 | 0 | |
root | Init DB | 727 | 53327960000 | 2264915000 | 4882000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 590 | 49688804000 | 309401000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 269 | 45690416000 | 609981000 | 200000000 | 0 | 0 | 0 | 0 | |
root | insert | 1 | 34777785000 | 34777785000 | 523000000 | 0 | 0 | 1 | 0 | |
root | jump_if_not | 28915 | 18977409000 | 311886000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 55 | 15791381000 | 11148674000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 8201 | 11156496000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 242 | 7176085000 | 67960000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 969 | 6757220000 | 206960000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 49 | 4824073000 | 255125000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 49 | 3150185000 | 153833000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 16 | 2451357000 | 719677000 | 0 | 0 | 0 | 0 | 0 |
|