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 | 1364040000 | 1364040000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 372 | 85893868000 | 790319000 | 35122000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 372 | 41870752000 | 332195000 | 14000000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 370 | 2675443000 | 66403000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 11739 | 7288122454000 | 455158530000 | 1468877000000 | 63155 | 951153 | 0 | 3591 | |
root | show_keys | 575 | 1321917659000 | 124674312000 | 212498000000 | 602 | 8919 | 0 | 0 | |
root | show_fields | 518 | 435642708000 | 3615640000 | 193249000000 | 13259 | 68403 | 0 | 0 | |
root | show_variables | 438 | 383126562000 | 4501120000 | 38769000000 | 990 | 251181 | 0 | 438 | |
root | show_table_status | 9 | 298295884000 | 293353282000 | 3872000000 | 33 | 370 | 0 | 0 | |
root | create_table | 1 | 266790620000 | 266790620000 | 5532000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 285 | 204254424000 | 3064416000 | 105834000000 | 5275 | 17440 | 0 | 0 | |
root | drop_db | 1 | 146649137000 | 146649137000 | 495000000 | 0 | 0 | 1 | 0 | |
root | set_option | 1432 | 118236419000 | 5351868000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 104993298000 | 58192506000 | 116000000 | 0 | 0 | 2 | 0 | |
root | show_create_table | 250 | 49772539000 | 2281101000 | 596000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 476 | 29995376000 | 605946000 | 3001000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 325 | 24775773000 | 319088000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 18202226000 | 18202226000 | 194000000 | 450 | 450 | 0 | 1 | |
root | jump_if_not | 22350 | 14018035000 | 231642000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 17 | 9509944000 | 6077570000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 5757 | 6124809000 | 527259000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 176 | 5853144000 | 206033000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 61 | 5118790000 | 1987632000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 17 | 4721886000 | 2446954000 | 1121000000 | 153 | 153 | 0 | 17 | |
root | Quit | 581 | 3885225000 | 214239000 | 0 | 0 | 0 | 0 | 0 |
|