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 | 18252 | 8028856396000 | 527304281000 | 2391545000000 | 98176 | 635869 | 0 | 9074 | |
192.168.30.20 | alter_table | 7 | 1632484120000 | 333063412000 | 1137000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 5 | 1192128495000 | 331469748000 | 4208000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_fields | 1004 | 951400369000 | 4010087000 | 366876000000 | 42442 | 215887 | 0 | 0 | |
192.168.30.20 | show_keys | 826 | 895319831000 | 56412226000 | 286810000000 | 1058 | 13844 | 0 | 0 | |
192.168.30.20 | show_variables | 981 | 843572382000 | 6054648000 | 88102000000 | 1533 | 562485 | 0 | 981 | |
192.168.30.20 | show_tables | 1882 | 576987035000 | 4464627000 | 287694000000 | 3124 | 10465 | 0 | 0 | |
192.168.30.20 | show_table_status | 32 | 301663045000 | 280627080000 | 14208000000 | 49 | 245 | 0 | 0 | |
192.168.30.20 | set_option | 3703 | 298976467000 | 8586877000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2311 | 226930357000 | 636855000 | 63796000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 165744868000 | 100985532000 | 1888000000 | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_create_table | 474 | 144349975000 | 56335070000 | 396000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 967 | 83805494000 | 284809000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2490 | 18875124000 | 653117000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_status | 1 | 14071874000 | 14071874000 | 86000000 | 450 | 450 | 0 | 1 | |
192.168.30.20 | show_warnings | 429 | 12734764000 | 187106000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 36 | 5025795000 | 653394000 | 2572000000 | 324 | 324 | 0 | 36 | |
192.168.30.20 | show_binlogs | 55 | 3899453000 | 448683000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 29 | 3806686000 | 2330142000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 32 | 3148854000 | 345870000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 3631 | 2494887000 | 341659000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 32 | 2422961000 | 389839000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 504 | 1414062000 | 815761000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 1 | 1275584000 | 1275584000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 1 | 128690000 | 128690000 | 33000000 | 0 | 2 | 0 | 1 |
|