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 | 3417661000 | 3417661000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 4603 | 900936000000 | 1630496000 | 364907000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 4603 | 416071800000 | 531562000 | 145188000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 4602 | 28885733000 | 71358000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 116911 | 45802212408000 | 768702097000 | 14480297000000 | 383923 | 3043990 | 0 | 52508 | |
root | show_fields | 9312 | 9898060669000 | 6761966000 | 3451447000000 | 528190 | 2670550 | 0 | 0 | |
root | show_variables | 9369 | 7746498140000 | 8537486000 | 832478000000 | 9368 | 5377743 | 0 | 9369 | |
root | show_keys | 6717 | 4866798879000 | 88847964000 | 2348508000000 | 11553 | 95067 | 0 | 0 | |
root | show_create_table | 4732 | 951833452000 | 2392343000 | 68000000 | 0 | 0 | 0 | 0 | |
root | set_option | 14813 | 857777881000 | 6345787000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1755 | 613203660000 | 608898297000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 717 | 470180128000 | 5602526000 | 229710000000 | 20040 | 47648 | 0 | 0 | |
root | Init DB | 4960 | 217240091000 | 783693000 | 1899000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 2935 | 212760485000 | 1103246000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 212058759000 | 61684965000 | 2997000000 | 0 | 0 | 4 | 0 | |
root | show_warnings | 4645 | 127926346000 | 401045000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 5271 | 35680590000 | 511697000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 300 | 27089908000 | 1697581000 | 0 | 0 | 50 | 0 | 0 | |
root | show_binlogs | 61 | 22123360000 | 14254537000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 3894 | 17321602000 | 10610925000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 3 | 4552122000 | 2695177000 | 4066000000 | 0 | 4 | 0 | 0 | |
root | show_slave_status | 8 | 2957656000 | 1842130000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 8 | 2510478000 | 2132183000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 18 | 2330219000 | 889379000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 18 | 2222816000 | 169630000 | 750000000 | 18 | 18 | 0 | 0 |
|