I have been on occasion recieving "Too Many Connections" errors which
lock up mysql.. I know i can set the connections in my.cnf.. atleast
thats what i've seen on this listover the past few months..
For starters.. i dont seem to have a my.cnf according to mysqladmin
Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf
None of these files excist so am assuming its running at the defualt 100
connections.
My main concern is I should never currently be near 100 simultanious
connections. When all is running well i show maybe 5-15 tops since most
connections are processed then dropped.
My thoughts are someone was purposely trying to take up all connections.
This happened 4 times in a day and a half..
I only access mysql through php so decided to start safe_mysqld with
--skip-networking
This seemed to help.. as i didnt have any trouble for over a week
after.. but then it did happen again. and once more a couple days later.
Also.. the last time it happened I couldnt even get into mysql at all
from the command line and I believe 1 connection is always left open for
just that purpose.
I also had a problem because in order to solve the too many connections
I was forced to do a mysqladmin shutdown..
This messed up all my auto-increments on all tables tat were in use at
the time of the problem and caused duplicate entry errors forcing me to
dump and remake the tables to correct the problem..
I am running 3.23.23-beta, for pc-linux-gnu on i686
Any thoughts. idea's, help on how i could correct the problem or fix it
if it happens again without dropping all messed up tables would be
appreciated.
Also.. I imagine I should put a my.cnf file in.. I havnt checked the
mysql site yet to see if they have example my.cnf but if someone could
possibly lead me that way i'd appreciate it (but not important since i
myself havnt looked)
Ter
--------------------------------------------------
Join the growing community of AngelHaven.com.
Sign up for your free AngelHaven E-mail Today...
Visit us at http://www.AngelHaven.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
