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 | 107933000 | 107933000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 2003 | 429737351000 | 2000507000 | 172511000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1868 | 196382861000 | 1097341000 | 67500000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1941 | 13399780000 | 43053000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 66609 | 35517760903000 | 758044163000 | 8674687000000 | 219263 | 2617261 | 0 | 20434 | |
root | alter_table | 32 | 9541221555000 | 585909179000 | 30367000000 | 0 | 0 | 1907 | 0 | |
root | show_keys | 3246 | 3761212398000 | 153177575000 | 1196695000000 | 3226 | 55689 | 0 | 0 | |
root | create_table | 24 | 3027811511000 | 249514068000 | 11372000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 3209 | 2994603345000 | 17510618000 | 1212911000000 | 114463 | 584943 | 0 | 0 | |
root | show_variables | 2931 | 2490994430000 | 9723823000 | 259353000000 | 3480 | 1681827 | 0 | 2931 | |
root | show_tables | 1464 | 1140406648000 | 8920463000 | 596841000000 | 30063 | 87090 | 0 | 0 | |
root | insert | 29 | 899039083000 | 87374118000 | 54477000000 | 0 | 0 | 1293 | 0 | |
root | set_option | 7296 | 512693127000 | 6147330000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 1588 | 333986519000 | 12135269000 | 800000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 2269 | 119193397000 | 964716000 | 5555000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1298 | 104729500000 | 823048000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 148968 | 91439432000 | 1340001000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 62391323000 | 62391323000 | 3211000000 | 0 | 0 | 1 | 0 | |
root | delete | 2 | 57178000000 | 31683360000 | 59000000 | 0 | 2 | 2 | 0 | |
root | show_status | 1 | 47442165000 | 47442165000 | 330000000 | 450 | 450 | 0 | 1 | |
root | show_table_status | 193 | 43697297000 | 2223460000 | 25679000000 | 24 | 233 | 0 | 0 | |
root | show_warnings | 1349 | 41832135000 | 214654000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 36520 | 38342573000 | 1638207000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 34495425000 | 21895218000 | 3546000000 | 0 | 0 | 0 | 0 | |
root | Quit | 3008 | 22577473000 | 804845000 | 0 | 0 | 0 | 0 | 0 |
|