Hi all,
I'm working on a site at the moment that experiences a strange problem
when the traffic passes a certain point.
Active connections are usually < 50, but at about 9pm every evening (our
peak time) they suddenly leap up to max_connections. I wrote a script to
log the output from show full processlist when the number of connections
passes 100 and ~90% of them are selects against one particular table in
the "statistics" state.
What would cause a large number of queries to linger in this state?
In case it's relevant I should say that the database in question is
being replicated to another server on the LAN.
The my.cnf file looks like this...
[mysqld]
log-bin=mysql-bin
server-id=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-slow-queries
long_query_time = 5
long_query_time
query_cache_size = 256M
innodb_buffer_pool_size=1G
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=32M
innodb_thread_concurrency=4
set-variable = max_allowed_packet=32M
set-variable = max_connections=1000
set-variable = thread_concurrency=4
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks.
-Stut
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
