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 | 922471000 | 922471000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 112 | 17997738000 | 496345000 | 7512000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 112 | 6871706000 | 93801000 | 2497000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 111 | 748816000 | 22526000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 1958 | 1000132776000 | 39920079000 | 279598000000 | 10627 | 63064 | 0 | 769 | |
root | show_keys | 64 | 534988389000 | 96989772000 | 24232000000 | 82 | 969 | 0 | 0 | |
root | show_fields | 172 | 143026631000 | 3223549000 | 70706000000 | 2390 | 13004 | 0 | 0 | |
root | show_variables | 62 | 73735369000 | 6517267000 | 5962000000 | 62 | 35588 | 0 | 62 | |
root | show_tables | 47 | 28286673000 | 1551922000 | 14789000000 | 931 | 4728 | 0 | 0 | |
root | set_option | 360 | 26621292000 | 4881729000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 107 | 8116183000 | 115301000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 70 | 6010414000 | 129345000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 123 | 5522374000 | 159806000 | 428000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 32 | 5102103000 | 294235000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 126 | 878702000 | 19896000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 24 | 724629000 | 51146000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 99951000 | 54539000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 56979000 | 30522000 | 0 | 0 | 0 | 0 | 0 |
|