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 | 370 | 65896148000 | 595987000 | 26724000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 370 | 31345272000 | 1377016000 | 10698000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 369 | 2316480000 | 67173000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 11613 | 8044452321000 | 620530754000 | 1502366000000 | 40114 | 301253 | 0 | 4058 | |
root | show_keys | 695 | 1516571663000 | 123045480000 | 257784000000 | 692 | 11657 | 0 | 0 | |
root | show_fields | 623 | 605213041000 | 8226645000 | 248398000000 | 21720 | 111040 | 0 | 0 | |
root | show_variables | 553 | 533990976000 | 17985160000 | 49241000000 | 553 | 317401 | 0 | 553 | |
root | show_tables | 365 | 214620397000 | 4404231000 | 107101000000 | 6786 | 18990 | 0 | 0 | |
root | show_table_status | 8 | 142971001000 | 139737787000 | 3245000000 | 5 | 27 | 0 | 0 | |
root | set_option | 1498 | 98428250000 | 6695753000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 313 | 60577654000 | 1903445000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 371 | 29618621000 | 628402000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 483 | 28809060000 | 290436000 | 3966000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 263 | 7824049000 | 85119000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 4 | 4763188000 | 4651577000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 640 | 4457526000 | 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 |
|