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 | 1017531000 | 1017531000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1442 | 346166028000 | 1323124000 | 140207000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1442 | 168105702000 | 387858000 | 57620000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1442 | 10399689000 | 61194000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 39897 | 22032673593000 | 1029616978000 | 5089734000000 | 136394 | 2782404 | 0 | 13472 | |
root | show_keys | 1860 | 2117095345000 | 166785642000 | 672703000000 | 2080 | 29667 | 0 | 0 | |
root | show_fields | 2103 | 2029808906000 | 18709999000 | 789886000000 | 85129 | 433185 | 0 | 0 | |
root | show_variables | 2169 | 1912842438000 | 4610163000 | 202784000000 | 2720 | 1244775 | 0 | 2169 | |
root | create_table | 4 | 703511248000 | 196168056000 | 7331000000 | 0 | 0 | 0 | 0 | |
root | alter_table | 1 | 432756209000 | 432756209000 | 103000000 | 0 | 0 | 0 | 0 | |
root | set_option | 4846 | 393936370000 | 6353658000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 457 | 368737802000 | 4892439000 | 189360000000 | 9980 | 25069 | 0 | 0 | |
root | show_create_table | 1057 | 207727105000 | 2605922000 | 973000000 | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 184346213000 | 54370862000 | 2166000000 | 0 | 0 | 4 | 0 | |
root | insert | 6 | 172070227000 | 41647643000 | 2577000000 | 0 | 0 | 5 | 0 | |
root | show_grants | 1072 | 81418586000 | 1327856000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1327 | 70639003000 | 483319000 | 3021000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1018 | 32057952000 | 178492000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 22958278000 | 22958278000 | 231000000 | 450 | 450 | 0 | 1 | |
root | show_table_status | 24 | 17537170000 | 3310798000 | 12487000000 | 0 | 221 | 0 | 0 | |
root | freturn | 5016 | 14485516000 | 5011422000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1787 | 13962189000 | 279524000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 154 | 7442539000 | 2022414000 | 0 | 0 | 27 | 0 | 0 | |
root | show_binlogs | 58 | 6437946000 | 2058882000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 18 | 5070001000 | 2774616000 | 3736000000 | 162 | 162 | 0 | 18 |
|