MySQL server is keep crashing on a dedicated server running also apache/php. I am not a MySQL PRO so I need some experts suggestions.
Innodb and MyISAM engines both are used in the website but Innodb is heavily used.
From WHM phpmyadmin I found following red options
Innodb_buffer_pool_pages_dirty 18 Innodb_buffer_pool_reads 31 k Handler_read_rnd 128 k Handler_read_rnd_next 3,013 k Created_tmp_disk_tables 1,534 Sort_merge_passes 10 Opened_tables 807 Table_locks_waited 8
Here is MySQL Configuration
max_connections = 500 safe-show-database skip-locking key_buffer = 700M max_allowed_packet = 32M table_cache = 512 sort_buffer_size = 64M read_buffer_size = 2M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 128M thread_cache_size = 16 query_cache_size= 512M query_cache_limit=1024M thread_concurrency = 8 connect_timeout = 8 wait_timeout = 120 interactive_timeout = 15 wait_timeout = 500 innodb_buffer_pool_size=1024M open_files_limit = 8192 tmp_table_size = 64M long_query_time = 1 log_slow_queries innodb_autoinc_lock_mode = 2 set-variable = innodb_lock_wait_timeout=10 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M
100930 9:44:12 [Warning] /usr/sbin/mysqld: Forcing close of thread 283 user: 'rdf' 100930 9:44:19 [ERROR] /usr/sbin/mysqld: Sort aborted 100930 9:44:19 [ERROR] /usr/sbin/mysqld: Sort aborted 100930 9:44:21 [ERROR] /usr/sbin/mysqld: Sort aborted 100930 9:44:53 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 100930 10:37:16 [ERROR] Cannot find or open table XXXX from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?
I see lots of errors cannot find or open table. I haven't touch MySQL configuration.