Help! Server Crashing & DB Corrupting!
 

<div>I've been having this issue for a few weeks now and I just learnt that you guys can help me optimize my DB. Hurray!

My server guys are recommending that I get another dedicated server for mysql alone, but decided that I shld check with you guys first. So here goes:

1. Dedicated server, one single site.
2. Server details:
Intel Q9300 Quad-Core CPU
- 4 x 2.5Ghz cores, 6MB Cache
6GB DDR2-667 ECC RAM
2x250gb SATA-2 16MB Cache HDD
Linux
Apache/2.2.11 (Unix)
PHP/5.2.9
3. VB3.8.1
4.
5.-
6.
Quote:
top - 22:20:16 up 4:23, 3 users, load average: 8.61, 9.05, 8.92
Tasks: 299 total, 4 running, 294 sleeping, 0 stopped, 1 zombie
Cpu0 : 45.8%us, 8.2%sy, 0.0%ni, 43.8%id, 2.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 46.1%us, 7.8%sy, 0.0%ni, 44.3%id, 1.8%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 46.1%us, 8.8%sy, 0.0%ni, 36.1%id, 8.9%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 49.6%us, 6.1%sy, 0.0%ni, 41.9%id, 1.8%wa, 0.1%hi, 0.5%si, 0.0%st
Mem: 8312600k total, 7401864k used, 910736k free, 147684k buffers
Swap: 2096440k total, 9156k used, 2087284k free, 3831328k cached
7. Quote:
Aborted_clients 5 Aborted_connects 3 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 806114835 Bytes_sent 2109938834 Com_admin_commands 2176 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_call_procedure 0 Com_change_db 239731 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 0 Com_create_db 0 Com_create_function 0 Com_create_index 0 Com_create_table 19 Com_create_user 0 Com_dealloc_sql 0 Com_delete 7319 Com_delete_multi 5 Com_do 0 Com_drop_db 2 Com_drop_function 0 Com_drop_index 0 Com_drop_table 19 Com_drop_user 0 Com_execute_sql 0 Com_flush 27 Com_grant 132 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 41269 Com_insert_select 19 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 1111 Com_optimize 0 Com_preload_keys 0 Com_prepare_sql 0 Com_purge 0 Com_purge_before_date 0 Com_rename_table 0 Com_repair 1195 Com_replace 8543 Com_replace_select 0 Com_reset 0 Com_restore_table 0 Com_revoke 0 Com_revoke_all 0 Com_rollback 0 Com_savepoint 0 Com_select 635224 Com_set_option 195 Com_show_binlog_events 0 Com_show_binlogs 1 Com_show_charsets 31 Com_show_collations 31 Com_show_column_types 0 Com_show_create_db 0 Com_show_create_table 6 Com_show_databases 48 Com_show_errors 0 Com_show_fields 246 Com_show_grants 51 Com_show_innodb_status 0 Com_show_keys 14 Com_show_logs 0 Com_show_master_status 0 Com_show_ndb_status 0 Com_show_new_master 0 Com_show_open_tables 0 Com_show_privileges 0 Com_show_processlist 50 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 4 Com_show_storage_engines 0 Com_show_tables 79 Com_show_triggers 0 Com_show_variables 117 Com_show_warnings 1 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_reset 0 Com_stmt_send_long_data 0 Com_truncate 34 Com_unlock_tables 1111 Com_update 80365 Com_update_multi 19 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 179231 Created_tmp_disk_tables 32761 Created_tmp_files 13 Created_tmp_tables 77650 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 6375 Handler_discover 0 Handler_prepare 0 Handler_read_first 51385 Handler_read_key 268202730 Handler_read_next 559816769 Handler_read_prev 707060 Handler_read_rnd 94977492 Handler_read_rnd_next 286285307 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 32680032 Handler_write 26396487 Innodb_buffer_pool_pages_data 0 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 0 Innodb_buffer_pool_pages_free 0 Innodb_buffer_pool_pages_latched 0 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_total 0 Innodb_buffer_pool_read_ahead_rnd 0 Innodb_buffer_pool_read_ahead_seq 0 Innodb_buffer_pool_read_requests 0 Innodb_buffer_pool_reads 0 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 0 Innodb_data_fsyncs 0 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 0 Innodb_data_reads 0 Innodb_data_writes 0 Innodb_data_written 0 Innodb_dblwr_pages_written 0 Innodb_dblwr_writes 0 Innodb_log_waits 0 Innodb_log_write_requests 0 Innodb_log_writes 0 Innodb_os_log_fsyncs 0 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 0 Innodb_page_size 0 Innodb_pages_created 0 Innodb_pages_read 0 Innodb_pages_written 0 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_rows_deleted 0 Innodb_rows_inserted 0 Innodb_rows_read 0 Innodb_rows_updated 0 Key_blocks_not_flushed 0 Key_blocks_unused 827626 Key_blocks_used 100215 Key_read_requests 702455524 Key_reads 135703 Key_write_requests 374936 Key_writes 231281 Last_query_cost 0.000000 Max_used_connections 174 Ndb_cluster_node_id 0 Ndb_config_from_host Ndb_config_from_port 0 Ndb_number_of_data_nodes 0 Not_flushed_delayed_rows 0 Open_files 661 Open_streams 0 Open_tables 512 Opened_tables 6680 Prepared_stmt_count 0 Qcache_free_blocks 7107 Qcache_free_memory 39300728 Qcache_hits 1477212 Qcache_inserts 583278 Qcache_lowmem_prunes 0 Qcache_not_cached 53701 Qcache_queries_in_cache 24592 Qcache_total_blocks 58485 Questions 2674654 Rpl_status NULL Select_full_join 9 Select_full_range_join 1 Select_range 257833 Select_range_check 0 Select_scan 140680 Slave_open_temp_tables 0 Slave_retried_transactions 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 32 Sort_merge_passes 0 Sort_range 146887 Sort_rows 566564060 Sort_scan 88245 Table_locks_immediate 1544842 Table_locks_waited 84412 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threads_cached 97 Threads_connected 32 Threads_created 174 Threads_running 4 Uptime 14760 Uptime_since_flush_status 14760
auto_increment_increment 1 auto_increment_offset 1 automatic_sp_privileges ON back_log 50 basedir / binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ collation_connection latin1_swedish_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci completion_type 0 concurrent_insert 1 connect_timeout 10 datadir /var/lib/mysql/ date_format %Y-%m-%d datetime_format %Y-%m-%d %H:%i:%s default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 div_precision_increment 4 keep_files_on_create OFF engine_condition_pushdown OFF expire_logs_days 0 flush OFF flush_time 0 ft_boolean_syntax + ->