Current Server hardware
MySQL Ver 14.12 Distrib 5.0.27
RHEL vs 5
584GB Raid 5 storage
8GB of RAM (I’m working on getting a 64bit OS to install so I can use all 8GB)
Dual 5130 processors (2.0GHz Intel Dual-Core Xeon)
max_allowed_packet = 14M
max_connections = 600
ft_min_word_len = 3
key_buffer_size = 2000M
sort_buffer = 9M
#read_rnd_buffer_size = 3M
table_cache = 350
log-error = /var/log/mysql/error.log
expire_logs_days = 3
Default to using old password format for compatibility with mysql 3.x
clients (those using the mysqlclient10 compatibility package).
Everything is stored in MyISAM.
Tables range from small to largest being 500k Rows with size of 1.9GB (incl indexes) which is wrote to constantly.
(any other info I’ll gladly provide if needed).
Here’s my dilemma. The server runs fine for long periods of time… then all of a sudden tables Lock and queries build up … and just don’t catch up and easiest thing to do is do a restart of mysql to clear everything out.
I’ve noticed that sometimes when I run a large search on a table after after 60 seconds of searching that table (I’d like to get that down) Tables start locking and won’t unlock unless I kill the Search.
The search is searching over three FULL Text indexes in Boolean mode.
I am thinking my config is screwed up and needs tweaked but I’m at a miss on how to fine tune.
so I seek help here.