I have my website develop in PHP with MYSQL, these are MYSQL values:

datadir=/data/mysql
socket=/data/mysql/mysql.sock
max_connections = 600
wait_timeout = 60
interactive_timeout=1800
skip-name-resolve
skip-bdb
default-time-zone=America/Caracas
log-slow-queries=/var/log/mysql-slow-queries.log
long_query_time=15
log-queries-not-using-indexes
query_cache_type=1
query_cache_size=32M
thread_cache_size=30
table_cache=4096
join_buffer_size=6M
key_buffer_size=12M
server-id = 1
log-bin=/data/mysql/drbd
expire_logs_days = 5
max_binlog_size = 100M
[client]
socket=/data/mysql/mysql.sock

When I start the database service that starts smoothly with a low number of connections and so remains for a few minutes, but then so sopresiva connections to the database increases reaching the maximum of connections and I have to re-restart the server.
I’ve checked the security aspect and not an attack, will have any suggestions or ideas of what might be causing thereby increase the number of connections?
Thanks a lot

http://www.mysqlperformanceblog.com/2007/02/05/why-do-you-need-many-apache-children/

Could you refer to me some article to check it out about this topic, the idea is make a balance between apache conections and MySQL max_conections.

Thanks in advance.

Andrews – this article is only about changing max_connections when MySQL server is using all of the available slots and you need to log into it to fix it (say kill some mysql queries) without restarting mysql server. Apache httpd settings is entirely different (and actually more important) topic, but there’s no simple answer here i.e. it depends on why you are hitting the max connections limit in the first place.

Aurimas

Aurimas excellent article,

I have read almost all the comments because a few days ago we had the same problem with our new web site, but I have a question about this change and I will share with you to see if you can answer it.

When doing this kind of change? No need to change some other side of apache? Considering that increasing the number of connections is possible that the workload increase on the web server or not?

gdb -p 17391 -ex “set max_connections=5000″ -batch

Aurimas

gdb -p $(cat data/mysql_sandbox5087.pid) -ex “set max_connections=5000” -batch

> gdb -p $17391 -ex “set max_connections=5000” -batch
GNU gdb Red Hat Linux (6.3.0.0-1.162.el4rh)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type “show copying” to see the conditions.
There is absolutely no warranty for GDB. Type “show warranty” for details.
This GDB was configured as “i386-redhat-linux-gnu”…set max_connections=5000: No such file or directory.

/mysql/data/-batch: No such file or directory.
(gdb)

I have tried “–batch” and putting a complete command syntax for all still returns the above error.

We can’t restart the DB or the server. What should I do next?

What I’d do is to change connections to higher value so you can connect and when change it again using MySQL way so it is resized as needed.
I would be careful calling functions in GDB unless you’re sure it is safe – mutexes etc may cause unwanted side effects.


gdb -p $(pidof mysqld) \
-ex "set max_connections=5000" \
-ex "call resize_thr_alarm(5030)" -batch


?