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 | 1943 | 446882044000 | 1325919000 | 181283000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1943 | 250896249000 | 28644664000 | 104125000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1942 | 14855442000 | 50450000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 121504 | 38856069622000 | 815548989000 | 16219982000000 | 267865 | 1663559 | 0 | 13853 | |
root | show_keys | 1261 | 1757625646000 | 94838578000 | 440529000000 | 1543 | 19088 | 0 | 0 | |
root | show_variables | 1565 | 1421129028000 | 6889023000 | 138836000000 | 1559 | 896987 | 0 | 1565 | |
root | show_fields | 1373 | 1241873985000 | 3797688000 | 508478000000 | 49578 | 252957 | 0 | 0 | |
root | create_table | 4 | 1057105302000 | 350272483000 | 3324000000 | 0 | 0 | 0 | 0 | |
root | set_option | 6148 | 889295692000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 1116 | 772989980000 | 4648127000 | 482914000000 | 6387 | 21172 | 0 | 0 | |
root | create_db | 14 | 423698466000 | 64943844000 | 727000000 | 0 | 0 | 9 | 0 | |
root | show_create_table | 673 | 115796839000 | 758503000 | 363000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1315 | 110465570000 | 360168000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1639 | 108866613000 | 2264915000 | 7862000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 135 | 98228262000 | 3225308000 | 66954000000 | 2 | 178 | 0 | 0 | |
root | grant | 2 | 66731461000 | 38713522000 | 1377000000 | 0 | 0 | 0 | 0 | |
root | insert | 2 | 66172276000 | 34777785000 | 929000000 | 0 | 0 | 2 | 0 | |
root | drop_db | 1 | 59691520000 | 59691520000 | 473000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 68728 | 46941742000 | 379943000 | 0 | 0 | 0 | 0 | 0 | |
root | alter_user | 2 | 45045356000 | 30257987000 | 843000000 | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 44350590000 | 44350590000 | 289000000 | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 31234735000 | 31234735000 | 1301000000 | 0 | 0 | 0 | 0 | |
root | freturn | 22776 | 22622510000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 106 | 18646994000 | 11148674000 | 0 | 0 | 0 | 0 | 0 |
|