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 | 2231 | 518867128000 | 1392705000 | 209476000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2231 | 257099851000 | 365329000 | 88932000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2230 | 16555468000 | 54895000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 36886 | 15598835128000 | 527304281000 | 4736869000000 | 196028 | 1235906 | 0 | 17321 | |
root | create_table | 10 | 2315401726000 | 469154207000 | 5766000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1709 | 2021092698000 | 98512347000 | 589087000000 | 2216 | 29677 | 0 | 0 | |
root | show_fields | 2002 | 1862636870000 | 4010087000 | 727732000000 | 80660 | 410832 | 0 | 0 | |
root | show_variables | 2025 | 1724149839000 | 6054648000 | 182824000000 | 3127 | 1161216 | 0 | 2025 | |
root | alter_table | 7 | 1632484120000 | 333063412000 | 1137000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 1200 | 624546960000 | 4464627000 | 370055000000 | 6443 | 21457 | 0 | 0 | |
root | set_option | 6885 | 533344929000 | 8586877000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 75 | 312529830000 | 280627080000 | 20836000000 | 54 | 290 | 0 | 0 | |
root | create_db | 6 | 297153798000 | 100985532000 | 2038000000 | 0 | 0 | 4 | 0 | |
root | show_create_table | 991 | 239365544000 | 56335070000 | 1720000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 2098 | 159291320000 | 636855000 | 24243000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1800 | 152632794000 | 284809000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 883 | 26038983000 | 187106000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 35232 | 21192704000 | 341659000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 2430 | 18459387000 | 653117000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 16039901000 | 14071874000 | 304000000 | 900 | 900 | 0 | 2 | |
root | Prepare | 2 | 7925019000 | 6649435000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 7614 | 6992070000 | 815761000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 105 | 6832845000 | 448683000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 47 | 6223835000 | 653394000 | 3160000000 | 423 | 423 | 0 | 47 |
|