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 | 2126 | 492351702000 | 1392705000 | 198958000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2126 | 243922474000 | 365329000 | 84419000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2125 | 15879307000 | 54895000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 34898 | 14929579174000 | 527304281000 | 4499122000000 | 185743 | 1171837 | 0 | 16317 | |
root | create_table | 10 | 2315401726000 | 469154207000 | 5766000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1603 | 1955758246000 | 98512347000 | 553523000000 | 2036 | 27845 | 0 | 0 | |
root | show_fields | 1873 | 1738721190000 | 4010087000 | 681022000000 | 74972 | 381912 | 0 | 0 | |
root | alter_table | 7 | 1632484120000 | 333063412000 | 1137000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 1880 | 1606255277000 | 6054648000 | 170042000000 | 2982 | 1078007 | 0 | 1880 | |
root | show_tables | 1150 | 587250578000 | 4464627000 | 348217000000 | 5967 | 19498 | 0 | 0 | |
root | set_option | 6543 | 506882119000 | 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 | 921 | 228394639000 | 56335070000 | 1720000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 1988 | 152884611000 | 636855000 | 24011000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1697 | 144346816000 | 284809000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 818 | 24247225000 | 187106000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 35232 | 21192704000 | 341659000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 2307 | 17750328000 | 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 | 99 | 6482639000 | 448683000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 47 | 6223835000 | 653394000 | 3160000000 | 423 | 423 | 0 | 47 |
|