Hello folks,

I hope I can get some help to track this problem....

I ran a phpNuke website with an phpBB forum using mYSQL 4.0.18 and ISAM tabels.
The page is quite busy as produced daily around 1.5 GB traffic. Most of the time there are at least 10 users online in the forum.

And here is the problem. From time to time a table is corrupt and I need to ran myisamchk to fix it. The crashed tables are usually the session tables or the user table. Very rarely any other. So far I was lucky and could always fix the problem quickly.

Now, what do I need to do to
a) help find the problem
b) fix that thing


Regarding a:
Here is my my.cnf:
----- my.cnf -----
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M

[...]

# The safe_mysqld script
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

---- my.cnf ----

In the mysald.log is nothing statet that the server deamon crashed.
The system in runing on a Celeren 2000 MHz with SuSe 9.2 on it.
I use the YaST Online Update to keep things up to date.



To b)

Could it help to change from ISAM to INDB??


Thanks for your help!!

Daniel