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 | 484286000 | 484286000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1507 | 213013129000 | 1234521000 | 88257000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1507 | 89352459000 | 1129691000 | 31876000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1506 | 8944394000 | 42954000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 57888 | 28121230169000 | 630358842000 | 8289038000000 | 163656 | 1844300 | 0 | 20198 | |
root | show_fields | 3611 | 3983676640000 | 7049399000 | 1491286000000 | 160153 | 814804 | 0 | 0 | |
root | show_keys | 3134 | 3301045251000 | 91050214000 | 1212745000000 | 4012 | 67431 | 0 | 0 | |
root | show_variables | 3274 | 2958526852000 | 6532076000 | 289680000000 | 3273 | 1879171 | 0 | 3274 | |
root | show_tables | 1449 | 752175367000 | 6154227000 | 383217000000 | 31103 | 95623 | 0 | 0 | |
root | show_create_table | 1833 | 389663016000 | 1960186000 | 105000000 | 0 | 0 | 0 | 0 | |
root | set_option | 6372 | 282783681000 | 8187420000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 2259 | 107760482000 | 571377000 | 5833000000 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 79777080000 | 79777080000 | 82000000 | 0 | 0 | 1 | 0 | |
root | show_grants | 721 | 61862203000 | 1792635000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 1616 | 50038997000 | 270582000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 61974 | 44916012000 | 6649901000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 2760 | 22472118000 | 884464000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 16092 | 18779339000 | 345199000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 30 | 8518872000 | 1724641000 | 5466000000 | 0 | 6 | 0 | 0 | |
root | show_binlogs | 26 | 6778229000 | 2183737000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 1 | 4802853000 | 4802853000 | 3850000000 | 0 | 0 | 0 | 0 | |
root | show_master_status | 3 | 2432057000 | 1988675000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 4 | 1692980000 | 989743000 | 1500000000 | 36 | 36 | 0 | 4 | |
root | show_slave_status | 3 | 201814000 | 73712000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 2 | 134682000 | 72514000 | 0 | 0 | 0 | 0 | 0 |
|