MySQL 4.0.13 on Win2K server w/ SP3
Please help. I'm having problems with tables that keep crashing for apparently no reason. I'll repair the table(s) with myisamchk and they'll work for a short while and then I'll need to repair them again. This has only recently been happening.
If I do a show table status, for the crashed tables everything shows up as null except the comment will be "Can't open file 'table.MYI' (errno: 130)'
After I repair the table
+----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment |
+----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
| dfhis | MyISAM | Fixed | 26181205 | 172 | 4503167260 | 738734374911 | 1295857664 | 0 | [NULL] | 2003-10-27 06:01:35 | 2003-10-31 09:28:21 | 2003-10-31 09:28:21 | | |
+----------------------------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------------------------------------------------------+
MY.INI
[WinMySQLAdmin]
Server=F:/mysql/bin/mysqld-max-nt.exe
[mysqld]
set-variable = key_buffer=768M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1024
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
server-id = 1
basedir=F:/mysql/
datadir=F:/mysql/data/
tmpdir=F:/temp
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
I have 3GB RAM, Dual 1.13 GH, Win2000 server w/ SP3