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 | 1544 | 360503387000 | 1325919000 | 146496000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1544 | 208483868000 | 28644664000 | 89665000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1543 | 11858504000 | 50450000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 64280 | 22863608821000 | 815548989000 | 8596624000000 | 181159 | 1114146 | 0 | 10866 | |
root | show_keys | 954 | 1525830052000 | 94838578000 | 335704000000 | 1187 | 14690 | 0 | 0 | |
root | show_variables | 1200 | 1099895683000 | 6889023000 | 107605000000 | 1196 | 687813 | 0 | 1200 | |
root | create_table | 4 | 1057105302000 | 350272483000 | 3324000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 1046 | 953296380000 | 3797688000 | 388466000000 | 38176 | 194741 | 0 | 0 | |
root | set_option | 4878 | 804384608000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 877 | 623506421000 | 4648127000 | 388287000000 | 5094 | 16785 | 0 | 0 | |
root | create_db | 12 | 321706953000 | 64943844000 | 626000000 | 0 | 0 | 7 | 0 | |
root | Init DB | 1291 | 88310423000 | 2264915000 | 6618000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 509 | 87141277000 | 758503000 | 363000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1030 | 87126278000 | 313361000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 116 | 84226458000 | 3225308000 | 57155000000 | 1 | 141 | 0 | 0 | |
root | grant | 2 | 66731461000 | 38713522000 | 1377000000 | 0 | 0 | 0 | 0 | |
root | insert | 2 | 66172276000 | 34777785000 | 929000000 | 0 | 0 | 2 | 0 | |
root | alter_user | 2 | 45045356000 | 30257987000 | 843000000 | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 44350590000 | 44350590000 | 289000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 52730 | 35768662000 | 379943000 | 0 | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 31234735000 | 31234735000 | 1301000000 | 0 | 0 | 0 | 0 | |
root | freturn | 16067 | 18405558000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 92 | 17879141000 | 11148674000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 461 | 13736902000 | 158643000 | 0 | 0 | 0 | 0 | 0 |
|