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 | 3182001000 | 3182001000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 987 | 190920985000 | 774106000 | 76734000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 987 | 88431049000 | 511338000 | 30300000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1007 | 6695210000 | 40615000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 29252 | 16979109809000 | 706647406000 | 4032689000000 | 105696 | 749877 | 0 | 8752 | |
root | alter_table | 32 | 9333927094000 | 745826138000 | 25932000000 | 0 | 0 | 1907 | 0 | |
root | create_table | 27 | 3676248984000 | 269087361000 | 11975000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1166 | 2946412670000 | 1218477282000 | 1659572000000 | 1148 | 21788 | 0 | 0 | |
root | show_fields | 1177 | 1143981104000 | 4460779000 | 461219000000 | 43912 | 224216 | 0 | 0 | |
root | show_variables | 1151 | 1020982432000 | 5279970000 | 103083000000 | 1149 | 660380 | 0 | 1151 | |
root | insert | 27 | 817053161000 | 100576525000 | 41277000000 | 0 | 0 | 1291 | 0 | |
root | show_tables | 631 | 446585370000 | 5548043000 | 237437000000 | 12880 | 36470 | 0 | 0 | |
root | show_create_table | 591 | 445994633000 | 131159647000 | 389000000 | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 355079790000 | 80089968000 | 2698000000 | 0 | 0 | 7 | 0 | |
root | set_option | 3644 | 251575706000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 977 | 54057853000 | 501516000 | 5664000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 585 | 46405848000 | 830281000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 179 | 35221206000 | 2150781000 | 21625000000 | 2 | 123 | 0 | 0 | |
root | jump_if_not | 46732 | 31050380000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 521 | 16879310000 | 165187000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 12568 | 15523316000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 48 | 15351723000 | 13157425000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1435 | 9732999000 | 221817000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 53 | 9587258000 | 3018340000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 8008951000 | 1553651000 | 2596000000 | 0 | 0 | 0 | 0 |
|