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 | 446780000 | 446780000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 814 | 181739854000 | 1050420000 | 74032000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 814 | 89179284000 | 439083000 | 30416000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 813 | 6511439000 | 34617000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 24236 | 9111378106000 | 232924149000 | 3312207000000 | 79656 | 509707 | 0 | 5796 | |
root | show_keys | 507 | 858797175000 | 60834234000 | 179055000000 | 563 | 6720 | 0 | 0 | |
root | create_table | 5 | 567597566000 | 225563990000 | 5740000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 561 | 506992118000 | 4791512000 | 50913000000 | 560 | 321489 | 0 | 561 | |
root | show_fields | 515 | 463694235000 | 5555303000 | 189261000000 | 17755 | 90569 | 0 | 0 | |
root | create_db | 5 | 266093927000 | 65055377000 | 3625000000 | 0 | 0 | 5 | 0 | |
root | show_tables | 471 | 263624153000 | 4117104000 | 160650000000 | 2264 | 6297 | 0 | 0 | |
root | set_option | 2539 | 199163761000 | 6442641000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 675 | 53113602000 | 2687663000 | 7339000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 564 | 48033180000 | 859174000 | 0 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 71247 | 47790689000 | 2450054000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 250 | 45471309000 | 2488000000 | 799000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 69 | 29997695000 | 2294908000 | 19923000000 | 1 | 62 | 0 | 0 | |
root | freturn | 19372 | 21497088000 | 367435000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 903 | 7831205000 | 514068000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 216 | 6065785000 | 57397000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 26 | 4572604000 | 1858014000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 21 | 4225403000 | 445945000 | 2126000000 | 189 | 189 | 0 | 21 | |
root | show_master_status | 31 | 3830419000 | 2023033000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 31 | 3288298000 | 564461000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 14 | 3058867000 | 1173923000 | 0 | 0 | 0 | 0 | 0 |
|