SELECT * FROM `x$host_summary_by_statement_type`
|
host | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
192.168.30.20 | select | 34544 | 14782847077000 | 296367688000 | 4617074000000 | 141282 | 806807 | 0 | 11131 | |
192.168.30.20 | alter_table | 12 | 3780934878000 | 536045462000 | 3707000000 | 0 | 0 | 20 | 0 | |
192.168.30.20 | show_keys | 1294 | 2718801875000 | 186984351000 | 489139000000 | 1460 | 22080 | 0 | 0 | |
192.168.30.20 | show_variables | 1418 | 1389193879000 | 25786119000 | 134796000000 | 1404 | 812651 | 0 | 1418 | |
192.168.30.20 | show_fields | 1367 | 1265690839000 | 4804227000 | 529862000000 | 44684 | 228896 | 0 | 0 | |
192.168.30.20 | create_table | 5 | 1199029389000 | 410014977000 | 6293000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 2088 | 910717628000 | 4624988000 | 471330000000 | 10692 | 32834 | 0 | 0 | |
192.168.30.20 | set_option | 4641 | 338409778000 | 4843082000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 681 | 284545744000 | 142212790000 | 70000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2594 | 215473571000 | 367323000 | 52465000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 4 | 198555810000 | 58106977000 | 1747000000 | 0 | 0 | 4 | 0 | |
192.168.30.20 | insert | 5 | 196444957000 | 59364366000 | 2463000000 | 0 | 0 | 21 | 0 | |
192.168.30.20 | show_grants | 972 | 78104408000 | 387637000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 47 | 69869497000 | 21049048000 | 32188000000 | 84 | 504 | 0 | 0 | |
192.168.30.20 | flush | 1 | 44536583000 | 44536583000 | 5254000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | update | 1 | 31001533000 | 31001533000 | 238000000 | 0 | 1 | 1 | 0 | |
192.168.30.20 | Quit | 3057 | 22550592000 | 204080000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 570 | 19812045000 | 343533000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 32 | 8601009000 | 553042000 | 3127000000 | 18 | 46 | 0 | 14 | |
192.168.30.20 | Prepare | 32 | 7750662000 | 947530000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 7569 | 6932211000 | 515911000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 63 | 5053318000 | 1338092000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 53 | 4694668000 | 241405000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 1263 | 4242519000 | 1178942000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 41 | 3830473000 | 311157000 | 1800000000 | 369 | 369 | 0 | 41 |
|