炳粉是什么:帮我看一下MYSQL STATUS,有什么问题

来源:百度文库 编辑:高校问答 时间:2024/04/30 20:54:28
| Aborted_connects | 1465 |
上面这个有些偏大,怎么解决?
mysql> show status;
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 8 |
| Aborted_connects | 1465 |
| Bytes_received | 22024176 |
| Bytes_sent | 103249868 |

| Com_change_db | 59483 |
| Com_create_table | 31 |
| Com_delete | 3549 |
| Com_drop_table | 31 |
| Com_insert | 10181 |
| Com_replace | 205 |
| Com_select | 74194 |
| Com_show_databases | 4 |
| Com_show_processlist | 9 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 8 |
| Com_show_tables | 6 |
| Com_show_variables | 1 |
| Com_update | 46462 |
| Com_update_multi | 0 |
| Connections | 61074 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 711 |
| Handler_delete | 1470 |
| Handler_read_first | 2837 |
| Handler_read_key | 5507277 |
| Handler_read_next | 2295720 |
| Handler_read_prev | 97236 |
| Handler_read_rnd | 562158 |
| Handler_read_rnd_next | 451451341 |
| Handler_rollback | 0 |
| Handler_update | 47245 |
| Handler_write | 1444476 |
| Key_blocks_used | 59297 |
| Key_read_requests | 17568233 |
| Key_reads | 59092 |
| Key_write_requests | 99282 |
| Key_writes | 57909 |
| Max_used_connections | 118 |
| Open_files | 282 |
| Open_streams | 0 |
| Open_tables | 200 |
| Opened_tables | 2139 |

| Questions | 255802 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 1274 |
| Select_range_check | 0 |
| Select_scan | 8346 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 8 |
| Sort_merge_passes | 0 |
| Sort_range | 4639 |
| Sort_rows | 43796796 |
| Sort_scan | 6045 |
| Table_locks_immediate | 156806 |
| Table_locks_waited | 1456 |
| Threads_cached | 5 |
| Threads_connected | 19 |
| Threads_created | 1691 |
| Threads_running | 1 |
| Uptime | 16000 |