论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-01-10 23:34 |只看该作者 |倒序浏览

不知道改怎么叙述，cpu占用经常到100%以上

服务器是个人服务器，8G内存

相关几个命令反馈如下：

[root@host ~]# ps -eaf |grep mysql
root    21825    1  0 11:48 ?       00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --

pid-file=/var/lib/mysql/host.52gc.cn.pid
mysql 21962 21825 34 11:48 ?       03:57:37 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --

user=mysql --log-error=/var/lib/mysql/host.52gc.cn.err --pid-file=/var/lib/mysql/host.52gc.cn.pid --

socket=/var/lib/mysql/mysql.sock
root    27523 26278  0 23:03 pts/1 00:00:00 mysql -u da_admin -p
root    28897 28168  0 23:27 pts/0 00:00:00 grep mysql

mysql> show status;
+----------------------------+------------+

| Variable_name             | Value    |
+----------------------------+------------+

| Aborted_clients          | 199       |
| Aborted_connects          | 3       |
| Binlog_cache_disk_use    | 0       |
| Binlog_cache_use          | 0       |
| Bytes_received          | 432       |
| Bytes_sent                | 8537    |
| Com_admin_commands       | 0       |
| Com_assign_to_keycache    | 0       |
| Com_alter_db             | 0       |
| Com_alter_db_upgrade    | 0       |
| Com_alter_event          | 0       |
| Com_alter_function       | 0       |
| Com_alter_procedure       | 0       |
| Com_alter_server          | 0       |
| Com_alter_table          | 0       |
| Com_alter_tablespace    | 0       |
| Com_analyze             | 0       |
| Com_backup_table          | 0       |
| Com_begin                | 0       |
| Com_binlog                | 0       |
| Com_call_procedure       | 0       |
| Com_change_db             | 0       |
| Com_change_master       | 0       |
| Com_check                | 0       |
| Com_checksum             | 0       |
| Com_commit                | 0       |
| Com_create_db             | 0       |
| Com_create_event          | 0       |
| Com_create_function       | 0       |
| Com_create_index          | 0       |
| Com_create_procedure    | 0       |
| Com_create_server       | 0       |
| Com_create_table          | 0       |
| Com_create_trigger       | 0       |
| Com_create_udf          | 0       |
| Com_create_user          | 0       |
| Com_create_view          | 0       |
| Com_dealloc_sql          | 0       |
| Com_delete                | 0       |
| Com_delete_multi          | 0       |
| Com_do                   | 0       |
| Com_drop_db             | 0       |
| Com_drop_event          | 0       |
| Com_drop_function       | 0       |
| Com_drop_index          | 0       |
| Com_drop_procedure       | 0       |
| Com_drop_server          | 0       |
| Com_drop_table          | 0       |
| Com_drop_trigger          | 0       |
| Com_drop_user             | 0       |
| Com_drop_view             | 0       |
| Com_empty_query          | 0       |
| Com_execute_sql          | 0       |
| Com_flush                | 0       |
| Com_grant                | 0       |
| Com_ha_close             | 0       |
| Com_ha_open             | 0       |
| Com_ha_read             | 0       |
| Com_help                | 0       |
| Com_insert                | 0       |
| Com_insert_select       | 0       |
| Com_install_plugin       | 0       |
| Com_kill                | 0       |
| Com_load                | 0       |
| Com_load_master_data    | 0       |
| Com_load_master_table    | 0       |
| Com_lock_tables          | 0       |
| Com_optimize             | 0       |
| Com_preload_keys          | 0       |
| Com_prepare_sql          | 0       |
| Com_purge                | 0       |
| Com_purge_before_date    | 0       |
| Com_release_savepoint    | 0       |
| Com_rename_table          | 0       |
| Com_rename_user          | 0       |
| Com_repair                | 0       |
| Com_replace             | 0       |
| Com_replace_select       | 0       |
| Com_reset                | 0       |
| Com_restore_table       | 0       |
| Com_revoke                | 0       |
| Com_revoke_all          | 0       |
| Com_rollback             | 0       |
| Com_rollback_to_savepoint  | 0       |
| Com_savepoint             | 0       |
| Com_select                | 0       |
| Com_set_option          | 0       |
| Com_show_authors          | 0       |
| Com_show_binlog_events    | 0       |
| Com_show_binlogs          | 0       |
| Com_show_charsets       | 0       |
| Com_show_collations       | 0       |
| Com_show_column_types    | 0       |
| Com_show_contributors    | 0       |
| Com_show_create_db       | 0       |
| Com_show_create_event    | 0       |
| Com_show_create_func    | 0       |
| Com_show_create_proc    | 0       |
| Com_show_create_table    | 0       |
| Com_show_create_trigger | 0       |
| Com_show_databases       | 0       |
| Com_show_engine_logs    | 0       |
| Com_show_engine_mutex    | 0       |
| Com_show_engine_status    | 0       |
| Com_show_events          | 0       |
| Com_show_errors          | 0       |
| Com_show_fields          | 0       |
| Com_show_function_status | 0       |
| Com_show_grants          | 0       |
| Com_show_keys             | 0       |
| Com_show_master_status    | 0       |
| Com_show_new_master       | 0       |
| Com_show_open_tables    | 0       |
| Com_show_plugins          | 0       |
| Com_show_privileges       | 0       |
| Com_show_procedure_status  | 0       |
| Com_show_processlist    | 14       |
| Com_show_profile          | 0       |
| Com_show_profiles       | 0       |
| Com_show_slave_hosts    | 0       |
| Com_show_slave_status    | 0       |
| Com_show_status          | 1       |
| Com_show_storage_engines | 0       |
| Com_show_table_status    | 0       |
| Com_show_tables          | 0       |
| Com_show_triggers       | 0       |
| Com_show_variables       | 0       |
| Com_show_warnings       | 0       |
| Com_slave_start          | 0       |
| Com_slave_stop          | 0       |
| Com_stmt_close          | 0       |
| Com_stmt_execute          | 0       |
| Com_stmt_fetch          | 0       |
| Com_stmt_prepare          | 0       |
| Com_stmt_reprepare       | 0       |
| Com_stmt_reset          | 0       |
| Com_stmt_send_long_data | 0       |
| Com_truncate             | 0       |
| Com_uninstall_plugin    | 0       |
| Com_unlock_tables       | 0       |
| Com_update                | 0       |
| Com_update_multi          | 0       |
| Com_xa_commit             | 0       |
| Com_xa_end                | 0       |
| Com_xa_prepare          | 0       |
| Com_xa_recover          | 0       |
| Com_xa_rollback          | 0       |
| Com_xa_start             | 0       |
| Compression             | OFF       |
| Connections             | 402513    |
| Created_tmp_disk_tables | 0       |
| Created_tmp_files       | 996       |
| Created_tmp_tables       | 0       |
| Delayed_errors          | 0       |
| Delayed_insert_threads    | 0       |
| Delayed_writes          | 0       |
| Flush_commands          | 1       |
| Handler_commit          | 0       |
| Handler_delete          | 0       |
| Handler_discover          | 0       |
| Handler_prepare          | 0       |
| Handler_read_first       | 0       |
| Handler_read_key          | 0       |
| Handler_read_next       | 0       |
| Handler_read_prev       | 0       |
| Handler_read_rnd          | 0       |
| Handler_read_rnd_next    | 0       |
| Handler_rollback          | 0       |
| Handler_savepoint       | 0       |
| Handler_savepoint_rollback | 0       |
| Handler_update          | 0       |
| Handler_write             | 0       |
| Key_blocks_not_flushed    | 0       |
| Key_blocks_unused       | 341952    |
| Key_blocks_used          | 86733    |
| Key_read_requests       | 2156791175 |
| Key_reads                | 81135    |
| Key_write_requests       | 395490    |
| Key_writes                | 230558    |
| Last_query_cost          | 0.000000 |
| Max_used_connections    | 179       |
| Not_flushed_delayed_rows | 0       |
| Open_files                | 2029    |
| Open_streams             | 0       |
| Open_table_definitions    | 513       |
| Open_tables             | 1591    |
| Opened_files             | 264618    |
| Opened_table_definitions | 0       |
| Opened_tables             | 0       |
| Prepared_stmt_count       | 0       |
| Qcache_free_blocks       | 19157    |
| Qcache_free_memory       | 61322880 |
| Qcache_hits             | 2849218 |
| Qcache_inserts          | 1579730 |
| Qcache_lowmem_prunes    | 43676    |
| Qcache_not_cached       | 35452    |
| Qcache_queries_in_cache | 37296    |
| Qcache_total_blocks       | 94476    |
| Questions                | 6565615 |
| Rpl_status                | NULL    |
| Select_full_join          | 0       |
| Select_full_range_join    | 0       |
| Select_range             | 0       |
| Select_range_check       | 0       |
| Select_scan             | 0       |
| Slave_open_temp_tables    | 0       |
| Slave_retried_transactions | 0       |
| Slave_running             | OFF       |
| Slow_launch_threads       | 0       |
| Slow_queries             | 0       |
| Sort_merge_passes       | 0       |
| Sort_range                | 0       |
| Sort_rows                | 0       |
| Sort_scan                | 0       |
| Table_locks_immediate    | 4407988 |
| Table_locks_waited       | 61545    |
| Tc_log_max_pages_used    | 0       |
| Tc_log_page_size          | 0       |
| Tc_log_page_waits       | 0       |
| Threads_cached          | 126       |
| Threads_connected       | 2       |
| Threads_created          | 179       |
| Threads_running          | 1       |
| Uptime                   | 38677    |
| Uptime_since_flush_status  | 38677    |
+----------------------------+------------+

225 rows in set (0.02 sec)