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 | 5355 | 2857936734000 | 535776851000 | 712139000000 | 37887 | 216855 | 0 | 2959 | |
192.168.30.20 | show_keys | 80 | 450601864000 | 91530377000 | 29224000000 | 174 | 2125 | 0 | 0 | |
192.168.30.20 | show_variables | 223 | 238700348000 | 7598706000 | 21554000000 | 223 | 127939 | 0 | 223 | |
192.168.30.20 | show_tables | 774 | 202636008000 | 5152714000 | 96130000000 | 963 | 3730 | 0 | 0 | |
192.168.30.20 | show_fields | 146 | 158785611000 | 3913532000 | 60523000000 | 6628 | 33710 | 0 | 0 | |
192.168.30.20 | set_option | 1533 | 112700525000 | 5640078000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 805 | 78141462000 | 2127707000 | 22503000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 52410033000 | 52410033000 | 954000000 | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_grants | 282 | 25091198000 | 298562000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 66 | 13035940000 | 841027000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 27 | 8903099000 | 2143222000 | 6243000000 | 0 | 12 | 0 | 0 | |
192.168.30.20 | Quit | 1041 | 7547642000 | 202798000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 57 | 6380378000 | 1850057000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 14 | 2512336000 | 1892009000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 66 | 1985853000 | 96778000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 12 | 1032286000 | 196074000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 12 | 695301000 | 133261000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 1 | 427277000 | 427277000 | 382000000 | 9 | 9 | 0 | 1 | |
background | select | 1 | 2957716000 | 2957716000 | 0 | 1 | 1 | 0 | 0 |
|