Ciao guys,
I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run
it, and had a 'too many connections' warning. So, I just set the
max_connections variable to 200. And since then, no problem.
Here is the /etc/my.cnf file under the [mysqld] group:
set-variable=key_buffer=16777216
set-variable=max_connections=200
set-variable=table_cache=2048
I want to ask you if there's a way to keep this under control. I mean.
What should I do to do this? I use to give a look at the status and
extended-status with mysqladmin, but are there any attributes I should keep
an eye on?
And, why does max_used_connections always says: 100? Kinda weird, isn't it?
Ciao and thanks!
-Gabriele
Ciao,
Ciao
-Gabriele
-------------------------------------------------
Gabriele Bartolini - Computer Programmer
U.O. Rete Civica - Comune di Prato
Prato - Italia - Europa
e-mail: [EMAIL PROTECTED]
http://www.po-net.prato.it
-------------------------------------------------
A "Supernova" is the celestial
equivalent of "rm -rf /*" with
root permissions.
-------------------------------------------------
---------------------------------------------------------------------
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
