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 | 107933000 | 107933000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 312 | 70372463000 | 2000507000 | 27065000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 312 | 32210834000 | 303268000 | 11065000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 314 | 2156467000 | 43053000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 13629 | 7116749453000 | 539056631000 | 1880728000000 | 40108 | 458382 | 0 | 4017 | |
root | show_keys | 615 | 1383728968000 | 153177575000 | 243410000000 | 574 | 10342 | 0 | 0 | |
root | show_fields | 581 | 561444840000 | 6394061000 | 232667000000 | 20127 | 102926 | 0 | 0 | |
root | show_variables | 510 | 470994460000 | 9723823000 | 48069000000 | 509 | 292698 | 0 | 510 | |
root | show_tables | 284 | 249386298000 | 8920463000 | 120825000000 | 6818 | 19399 | 0 | 0 | |
root | set_option | 1259 | 116890821000 | 6147330000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 285 | 56913128000 | 1347437000 | 121000000 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 54 | 34495425000 | 21895218000 | 3546000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 280 | 23668949000 | 347657000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 402 | 22235219000 | 361314000 | 2001000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 19908 | 16204119000 | 1340001000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 127 | 14995735000 | 633962000 | 7656000000 | 0 | 67 | 0 | 0 | |
root | show_create_func | 44 | 9662990000 | 4080686000 | 5231000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 244 | 7798995000 | 112205000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 5488 | 7086964000 | 412417000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 5931806000 | 5862409000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 41 | 5658161000 | 2354196000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 5318694000 | 5285966000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 549 | 3748357000 | 249475000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 5 | 2569622000 | 2142947000 | 2302000000 | 45 | 45 | 0 | 5 | |
root | Prepare | 1 | 986734000 | 986734000 | 0 | 0 | 0 | 0 | 0 |
|