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 | 3182001000 | 3182001000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 219 | 38427411000 | 774106000 | 15817000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 219 | 17026761000 | 511338000 | 5854000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 221 | 1283227000 | 22922000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 7501 | 4899165957000 | 706647406000 | 1127059000000 | 22483 | 162343 | 0 | 2074 | |
root | show_keys | 230 | 1731918178000 | 1218477282000 | 1308392000000 | 175 | 4221 | 0 | 0 | |
root | show_variables | 234 | 226164156000 | 5279970000 | 21255000000 | 234 | 134274 | 0 | 234 | |
root | show_fields | 217 | 214718144000 | 3590442000 | 84090000000 | 8120 | 41467 | 0 | 0 | |
root | set_option | 819 | 68164630000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 133 | 66579820000 | 2764692000 | 33651000000 | 2928 | 8481 | 0 | 0 | |
root | show_create_table | 108 | 22516792000 | 749590000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 220 | 14596614000 | 300868000 | 2842000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 16140 | 14339221000 | 839952000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 167 | 13478284000 | 506163000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 84 | 9839176000 | 666046000 | 5439000000 | 0 | 0 | 0 | 0 | |
root | freturn | 4512 | 7340805000 | 632065000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 150 | 5992566000 | 655653000 | 0 | 0 | 25 | 0 | 0 | |
root | show_binlogs | 14 | 4107745000 | 2689621000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 3602145000 | 3351586000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 103 | 3234331000 | 60784000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 7 | 2980103000 | 1999732000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 2 | 2640233000 | 2578081000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 7 | 2125079000 | 1920291000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 327 | 1820947000 | 105438000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 7 | 1805314000 | 1314465000 | 253000000 | 0 | 14 | 0 | 7 |
|