Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm running a Linux (512MB of RAM) server with MySQL 5.1.

I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would fail if more than one user connected. I checked the log files and it showed there were too many connections.

So, I then checked my.cnf and I see the following:

[mysqld]
max_user_connections=1
max_connections=1

innodb_file_per_table
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I haven't opened up my.cnf since I installed MySQL over 4 months ago.

1) Why in the world would max_user_connections and max_connections randomly get set to 1?

2) Next question is, what should I set those two values to?

3) Should I be worried that this random change will happen again?

* NOTE: I noticed this started after I changed some things in my SSH config file to allow for a more secure public/private key connection while using SFTP. Could that have really made a difference in the MySQL Config?

Thanks for any help you can provide!

share|improve this question
    
Does the timestamp on the my.cnf file show it was modified? –  Phil Mar 15 '13 at 14:14
    
@Phil: Stupid me, I'm not sure... I edited my.cnf already, before checking the timestamp... DARN!! –  FastTrack Mar 15 '13 at 14:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.