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 | 65776000 | 65776000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 2235 | 441175515000 | 1326458000 | 180858000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2235 | 209995486000 | 456902000 | 73553000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2234 | 14756945000 | 627555000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 64841 | 23592458328000 | 344293536000 | 7386283000000 | 194636 | 1280551 | 0 | 32805 | |
root | show_fields | 4393 | 4399617483000 | 7105612000 | 1620950000000 | 218565 | 1106926 | 0 | 0 | |
root | show_variables | 4514 | 3789362308000 | 10756831000 | 394741000000 | 4514 | 2590994 | 0 | 4514 | |
root | show_keys | 4166 | 2892100474000 | 49679425000 | 1442272000000 | 4409 | 44164 | 0 | 0 | |
root | show_create_table | 2276 | 463596927000 | 8802293000 | 74000000 | 0 | 0 | 0 | 0 | |
root | set_option | 7277 | 438800279000 | 5887036000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 477 | 308227410000 | 12982668000 | 152626000000 | 10421 | 30330 | 0 | 0 | |
root | Init DB | 2437 | 103418811000 | 287972000 | 1383000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1016 | 74049890000 | 368819000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 70922155000 | 70922155000 | 4256000000 | 0 | 0 | 1 | 0 | |
root | show_warnings | 2232 | 64348979000 | 227854000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 2641 | 18036770000 | 587012000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 8 | 8949677000 | 3406939000 | 6737000000 | 0 | 14 | 0 | 0 | |
root | set | 150 | 7073637000 | 529802000 | 0 | 0 | 25 | 0 | 0 | |
root | jump_if_not | 5855 | 5057036000 | 430807000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 45 | 4660153000 | 1899489000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 845 | 1681812000 | 449767000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 14 | 1010584000 | 222562000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 4 | 814227000 | 416115000 | 556000000 | 36 | 36 | 0 | 4 | |
root | show_master_status | 14 | 526475000 | 119924000 | 0 | 0 | 0 | 0 | 0 | |
root | jump | 20 | 1866000 | 112000 | 0 | 0 | 0 | 0 | 0 |
|