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 | 107933000 | 107933000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 89 | 21248368000 | 2000507000 | 7385000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 89 | 8610425000 | 291649000 | 2962000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 87 | 543047000 | 35322000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 3060 | 2312023864000 | 539056631000 | 447464000000 | 12940 | 126090 | 0 | 1135 | |
root | show_keys | 183 | 954566450000 | 153177575000 | 94314000000 | 207 | 3219 | 0 | 0 | |
root | show_fields | 163 | 172930344000 | 6394061000 | 77004000000 | 4892 | 25119 | 0 | 0 | |
root | show_variables | 135 | 162520412000 | 9723823000 | 15735000000 | 134 | 77448 | 0 | 135 | |
root | show_tables | 98 | 89204971000 | 8920463000 | 41683000000 | 2064 | 6395 | 0 | 0 | |
root | set_option | 380 | 46778124000 | 6147330000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 28703546000 | 21895218000 | 3546000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 80 | 17759362000 | 1125872000 | 20000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 96 | 8798003000 | 347657000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 130 | 8335199000 | 347919000 | 1159000000 | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 8206001000 | 4080686000 | 5231000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 29 | 4034980000 | 633962000 | 1998000000 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 13 | 3454423000 | 2354196000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 62 | 2166804000 | 99082000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 165 | 975168000 | 78773000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 2 | 236337000 | 153820000 | 121000000 | 18 | 18 | 0 | 2 |
|