MySQL Performance: MySQL => Too Many Connections

Too Many Connections [message #3756]

Wed, 03 December 2008 18:22

amandabee
Messages: 4
Registered: November 2008
Location: New York, NY

Junior Member

I'm trying to troubleshoot a server that just keeps cracking up.

We get errors to the tune of "Could not select database;
Could not connect: Too many connections" printing to the screen, but when I go off and

show proccesses

the problem has cleared up. I'm not even sure how to tell where the problem is coming from.

I was ready to pin the blame on our Phorum forums, but I limited the phorum's mysql user to 5 connections and it is still happening.

Can I tweak my logs at all to see where these scrums are coming from?

And: the timeouts of 3600 seem crazy long to me, but they were set by a predecessor.

Thanks!
Amanda

my my.cnf is at http://phpfi.com/384659 or below.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#ABH Edit 2008-01-09
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5

# Rackspace edit per #060815-01133
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
wait_timeout = 3600
interactive_timeout = 3600
# End Rackspace edit

[mysql.server]
user=mysql
basedir=/var/lib
max_connections=200

[mysqld_safe]
#ABH Edit 2008-01-09
#err-log=/var/log/mysqld.log
err-log=/var/log/mysql/err-mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

## ABH EDIT 2008-4-16
# The following can be used as easy to replay backup logs or for replication.
#server-id              = 1
log_bin                 = /var/log/mysql/mysql-bin.log

# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name

Report message to a moderator