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 | 296852000 | 296852000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 2354 | 439942597000 | 752196000 | 177905000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2354 | 205074102000 | 436755000 | 72585000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2353 | 14839226000 | 65800000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 77071 | 33535298428000 | 1113734903000 | 9613493000000 | 208882 | 1966469 | 0 | 29448 | |
root | show_fields | 4745 | 4894557589000 | 9396288000 | 1816720000000 | 226224 | 1147027 | 0 | 0 | |
root | show_variables | 4731 | 4023627027000 | 5973044000 | 414088000000 | 4731 | 2715573 | 0 | 4731 | |
root | show_keys | 4324 | 3320073321000 | 78998465000 | 1555184000000 | 4862 | 56027 | 0 | 0 | |
root | show_create_table | 2416 | 493085215000 | 5880043000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 720 | 479767732000 | 6760056000 | 235971000000 | 21988 | 48160 | 0 | 0 | |
root | set_option | 8072 | 463094593000 | 8889639000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 2591 | 114840322000 | 329072000 | 1704000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1182 | 87170612000 | 777511000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 2331 | 68727510000 | 377933000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 3025 | 20492619000 | 649974000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 7199 | 14220089000 | 2159087000 | 0 | 0 | 0 | 0 | 0 | |
root | set | 154 | 6227718000 | 689927000 | 0 | 0 | 27 | 0 | 0 | |
root | show_binlogs | 38 | 5737258000 | 1880386000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1967 | 3270871000 | 966908000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 1 | 2042965000 | 2042965000 | 2001000000 | 9 | 9 | 0 | 1 | |
root | show_master_status | 4 | 945048000 | 466277000 | 0 | 0 | 0 | 0 | 0 | |
root | stmt | 2 | 845160000 | 755182000 | 0 | 0 | 2 | 0 | 0 | |
root | show_slave_status | 4 | 687952000 | 475951000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 1 | 505715000 | 505715000 | 459000000 | 0 | 0 | 0 | 0 | |
root | error | 2 | 397934000 | 362909000 | 0 | 0 | 0 | 0 | 0 |
|