A specific table in my database keeps crashing. I suspect it to be a bad buffer setting in the
my.conf file, because it shows this error before crashing (most of the time it needs to be repaired):
18:26:59 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './myDB/myTable.MYI'; try to repair it 18:54:57 [ERROR] /usr/libexec/mysqld: Out of memory (Needed 59542644 bytes) 141020 18:54:57 [ERROR] /usr/libexec/mysqld: Sort aborted
I don't think it is hard disk related, since
tmpdir is set to
/tmp/ and has around 48 GB of free disk space.
mysql> SHOW VARIABLES LIKE 'tmpdir';
Here is a look at the
my.conf settings. Take special note of the parameter
sort_buffer_size which has been set way to high. However, I'm unsure if it will produce this kind of error when set too high. This machine runs Ubuntu with 8 GB RAM.
[mysqld] max_connections = 1500 back_log = 50 skip-locking key_buffer = 819M max_allowed_packet = 16M table_cache = 512 sort_buffer_size = 2048M read_buffer_size = 16M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 16 query_cache_size = 16M thread_concurrency = 8 max_heap_table_size = 512M wait_timeout = 60 interactive_timeout = 60
Any thoughts on this issue?