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 | 1191431000 | 1191431000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 361 | 63603592000 | 595987000 | 25797000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 361 | 30240104000 | 1377016000 | 10323000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 360 | 2266517000 | 67173000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 11365 | 7970083385000 | 620530754000 | 1471160000000 | 39175 | 294704 | 0 | 3977 | |
root | show_keys | 672 | 1501826861000 | 123045480000 | 249264000000 | 665 | 11322 | 0 | 0 | |
root | show_fields | 604 | 590852630000 | 8226645000 | 241585000000 | 21285 | 108784 | 0 | 0 | |
root | show_variables | 537 | 521459193000 | 17985160000 | 47856000000 | 537 | 308217 | 0 | 537 | |
root | show_tables | 359 | 211266817000 | 4404231000 | 105452000000 | 6619 | 18519 | 0 | 0 | |
root | show_table_status | 8 | 142971001000 | 139737787000 | 3245000000 | 5 | 27 | 0 | 0 | |
root | set_option | 1462 | 95855422000 | 6695753000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 303 | 59323059000 | 1903445000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 362 | 28981468000 | 628402000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 471 | 28226530000 | 290436000 | 3966000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 255 | 7599659000 | 85119000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 4 | 4763188000 | 4651577000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 625 | 4377109000 | 188273000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 9 | 2796582000 | 1978566000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 2114525000 | 2114525000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 916515000 | 916515000 | 584000000 | 0 | 2 | 0 | 1 | |
root | error | 6 | 696944000 | 290634000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 2 | 231211000 | 120184000 | 134000000 | 18 | 18 | 0 | 2 | |
root | show_slave_status | 4 | 218002000 | 80079000 | 0 | 0 | 0 | 0 | 0 | |
root | Close stmt | 1 | 11246000 | 11246000 | 0 | 0 | 0 | 0 | 0 |
|