index corruption?

[Jasper]

Hi everyone,
I am running MySQL 5.0.19 downloaded as a binary on my RHEL 3 with 6GB RAM and Dual 2.8GHz Pentiums on a HP DL380 and the data directory is on an external Compaq RAID. I am constantly getting index corruptions. On average my table inserts are about 1.6 lines per day.

also the top shows:
Mem: 5932084k av, 5913932k used, 18152k free, 0k shrd, 5036k buff
4574436k actv, 569680k in_d, 95716k in_c
Swap: 2044072k av, 52k used, 2044020k free 5485960k cache

Mysql is consuming all the memory. Restarting the system, and run a query, the used goes from about 100Megs to almost 6Gigs.

my my.cnf looks like:
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-external-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_s -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

You could also look at following options:

- ALTER TABLE ... ENGINE=InnoDB.

- Switch to a linux kernel 2.6.16 with all preemption turned on:
CONFIG_PREEMPT=y
CONFIG_PREEMPT_BKL=y
Or, if this is already the case, turn it off. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --