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 | 2341481000 | 2341481000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 574 | 126389934000 | 620963000 | 51230000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 574 | 61173537000 | 707742000 | 21207000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 573 | 3772916000 | 47126000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 20749 | 11994083342000 | 1231772124000 | 2851815000000 | 65981 | 502421 | 0 | 4529 | |
root | show_keys | 852 | 1381558363000 | 122954805000 | 306503000000 | 373 | 7157 | 0 | 0 | |
root | show_fields | 620 | 533110050000 | 5941609000 | 240805000000 | 12452 | 64498 | 0 | 0 | |
root | show_variables | 501 | 471370140000 | 5335267000 | 43870000000 | 501 | 287133 | 0 | 501 | |
root | create_table | 2 | 446925099000 | 229435925000 | 5490000000 | 0 | 0 | 0 | 0 | |
root | set_option | 1662 | 161518628000 | 15485018000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 289 | 151287542000 | 3611500000 | 75722000000 | 3846 | 11418 | 0 | 0 | |
root | create_db | 1 | 85329037000 | 85329037000 | 2312000000 | 0 | 0 | 1 | 0 | |
root | show_create_table | 281 | 70420133000 | 2894514000 | 121000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 529 | 43056865000 | 688566000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 572 | 38136416000 | 327261000 | 3924000000 | 0 | 0 | 0 | 0 | |
root | freturn | 24451 | 32950995000 | 1242173000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 41097 | 25489149000 | 2014553000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 64 | 15515113000 | 7727588000 | 10949000000 | 33 | 232 | 0 | 0 | |
root | show_warnings | 183 | 6571784000 | 569631000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 713 | 4810328000 | 171953000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 47 | 4207955000 | 1322810000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 18 | 3189221000 | 2066889000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 11 | 3086921000 | 1669483000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 23 | 2329469000 | 324097000 | 1182000000 | 207 | 207 | 0 | 23 | |
root | stmt | 2 | 1774820000 | 1684572000 | 0 | 0 | 2 | 0 | 0 |
|