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 | 3684354000 | 3684354000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1805 | 419173755000 | 1392705000 | 169397000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1805 | 207797574000 | 341431000 | 71964000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1804 | 13518673000 | 54895000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 29893 | 12884809687000 | 527304281000 | 3882275000000 | 153411 | 987534 | 0 | 13808 | |
root | alter_table | 7 | 1632484120000 | 333063412000 | 1137000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 1621 | 1505619377000 | 4010087000 | 591935000000 | 65493 | 333538 | 0 | 0 | |
root | show_keys | 1372 | 1504928047000 | 98512347000 | 470055000000 | 1703 | 23398 | 0 | 0 | |
root | show_variables | 1598 | 1354487115000 | 6054648000 | 142876000000 | 2700 | 916244 | 0 | 1598 | |
root | create_table | 5 | 1192128495000 | 331469748000 | 4208000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 985 | 487082947000 | 4464627000 | 289149000000 | 4607 | 15354 | 0 | 0 | |
root | set_option | 5557 | 438435849000 | 8586877000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 61 | 307936995000 | 280627080000 | 17854000000 | 54 | 282 | 0 | 0 | |
root | create_db | 4 | 226681399000 | 100985532000 | 1932000000 | 0 | 0 | 3 | 0 | |
root | show_create_table | 786 | 200875415000 | 56335070000 | 396000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 1692 | 131946639000 | 636855000 | 21515000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1460 | 124782813000 | 284809000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 34996 | 21033233000 | 341659000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 702 | 20589962000 | 187106000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 16039901000 | 14071874000 | 304000000 | 900 | 900 | 0 | 2 | |
root | Quit | 1958 | 15000201000 | 653117000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 7574 | 6931182000 | 815761000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 47 | 6223835000 | 653394000 | 3160000000 | 423 | 423 | 0 | 47 | |
root | show_binlogs | 80 | 5470986000 | 448683000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 49 | 4697629000 | 345870000 | 0 | 0 | 0 | 0 | 0 |
|