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 | 1686459000 | 1686459000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 933 | 189702399000 | 1310063000 | 76464000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 933 | 88826645000 | 332992000 | 30772000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 936 | 6341323000 | 37257000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 27120 | 15138384664000 | 616257083000 | 3750458000000 | 92931 | 937689 | 0 | 8907 | |
root | alter_table | 22 | 12995673464000 | 1405441863000 | 30013000000 | 0 | 0 | 90 | 0 | |
root | create_table | 17 | 3485042827000 | 462903760000 | 291179000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1279 | 1859092952000 | 120330298000 | 469039000000 | 1324 | 23925 | 0 | 0 | |
root | show_variables | 1467 | 1307472726000 | 8692604000 | 129282000000 | 1467 | 841932 | 0 | 1467 | |
root | show_fields | 1332 | 1295182451000 | 12791349000 | 514482000000 | 51324 | 261824 | 0 | 0 | |
root | insert | 20 | 708034382000 | 113308643000 | 17838000000 | 0 | 0 | 211 | 0 | |
root | show_tables | 590 | 435980747000 | 3680850000 | 231500000000 | 13331 | 37517 | 0 | 0 | |
root | show_create_table | 668 | 317470521000 | 139866578000 | 90000000 | 0 | 0 | 0 | 0 | |
root | create_db | 5 | 270252466000 | 66310888000 | 2465000000 | 0 | 0 | 5 | 0 | |
root | set_option | 3396 | 261774708000 | 15928555000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1030 | 56490049000 | 387513000 | 5719000000 | 0 | 0 | 0 | 0 | |
root | create_trigger | 1 | 51903648000 | 51903648000 | 1275000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 588 | 46272947000 | 723207000 | 0 | 0 | 0 | 0 | 0 | |
root | delete | 1 | 25887875000 | 25887875000 | 188000000 | 0 | 3 | 1 | 0 | |
root | show_table_status | 117 | 24166997000 | 2101705000 | 14855000000 | 0 | 158 | 0 | 0 | |
root | jump_if_not | 37462 | 23085006000 | 452698000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 654 | 21584469000 | 391675000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 15280785000 | 7588718000 | 2960000000 | 0 | 0 | 0 | 0 | |
root | freturn | 9638 | 12120961000 | 1999919000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1388 | 9229143000 | 164939000 | 0 | 0 | 0 | 0 | 0 |
|