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 | 3926666000 | 3926666000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 74 | 13109353000 | 622156000 | 5663000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 70 | 4805409000 | 278817000 | 1711000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 71 | 350784000 | 16914000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 1885 | 1139156779000 | 77056626000 | 261440000000 | 9233 | 48000 | 0 | 845 | |
root | show_keys | 141 | 400128724000 | 85891963000 | 53895000000 | 189 | 1818 | 0 | 0 | |
root | show_fields | 155 | 173074540000 | 2409752000 | 63800000000 | 7191 | 36478 | 0 | 0 | |
root | show_variables | 145 | 158341085000 | 5722996000 | 13874000000 | 145 | 83230 | 0 | 145 | |
root | set_option | 280 | 20034566000 | 3098738000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 44 | 17332816000 | 1641284000 | 8814000000 | 636 | 1954 | 0 | 0 | |
root | show_create_table | 77 | 16670365000 | 1791832000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 72 | 5731547000 | 184920000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 106 | 5666723000 | 328428000 | 546000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 68 | 1933906000 | 52704000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 6 | 902622000 | 594135000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 115 | 826607000 | 184573000 | 0 | 0 | 0 | 0 | 0 |
|