Hey everyone,
I'd appreciate it if anyone on this list might be able to help us out with a
problem we've been having with mysql lately.
We are using mysql as a backend for a content management system on our site.
We've been using it for awhile, and it has been working fine. However, we
recently launched a new version of our site, and have begun to see some
strange behavior. Every few hours (and when we restart mysql) mysql will
suddenly open roughly a hundred child processes and bring the server to a
complete standstill ("top" will show an idle time of 0% all the processes
will be running around 30% each). This will last for a few minutes, and
then each of the child processes will go away. Everything will be fine for
a few hours, and then it will happen again.
We are running Apache 1.3, MySQL 4.0.12 and PHP 4.3.2 on Redhat 8. The
server is a dual pentium 4 box with 2Gigs of memory. Our main content table
has roughly 20,000 entries and numerious fulltext indexes. The data is
about 37M and the indexes 22M.
Here are the settings we're currently running with; though we've tried some
other variations - all with the same results.
# The MySQL server
[mysqld]
# port = @MYSQL_TCP_PORT@
# socket = @MYSQL_UNIX_ADDR@
socket=/var/lib/mysql/mysql.sock
#skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 128
sort_buffer_size = 4M
read_buffer_size = 1M
myisam_sort_buffer_size = 16M
thread_cache = 8
query_cache_size= 50M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
datadir=/var/lib/mysql
log-slow-queries
Our mysql instances do seem to be rather large - around 150M - though we
chalked this up to extensive sorting, etc. that needs to be done. Since we
have 2Gigs of member - this really isn't a problem for us.
After it has gone through this process of opening all these child
processes - bring the machine to a stand still and then coming back - SQL
queries will be extremely fast after that.
Any help would be greatly appreciated.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
