I tweaked my.cnf on a server.
Changed wait_timeout from 80 to 75
and increased key_buffer to 1280M from 1024M
max_connections is set to 500
Max_used_connections was reported at 370 (from 'mysqladmin variables')
thread_cache is set to 48
I ran 'mysqladmin flush-hosts' as the mysql root user and got the following
output:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug'
Problem seems to have disappeared once I reverted back to my old settings
(and I don't get the regular [every 10min] php pconnect errors).
Max_used_connections is now at 439.
System is MySQL 3.23.51 built from source, Rh 7.3, custom 2.4.19 kernel.
What I'm unsure about is the errors from php pconnect and the inability to
flush hosts when I hadn't hit any connection limits. I have over 2GB RAM
free (as reported by 'top')
Any ideas/suggestions?
_________________________________________________________________
Chat online in real time with MSN Messenger http://messenger.msn.co.uk
---------------------------------------------------------------------
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
