Hi Chenri,
> 1. is this value for one database or for overall mysql connections?
The value is for overall mysql connections... so it's not for one
database.
> 2. i'm unable to generate 100 connections, i don't have 100 workstations
yet,
> how do i test it?
Why would you ?
> 3. what will happen if the connection exceed 100 connection?
> (does mysql crash or display database unavailable error message
> or it just queued the connection requests)
No it does not crash...
It will refuse connection number 101... but there is an issue...
depending on the OS there is a "number of connections" that the OS can keep
in state of pending... until the application can accept it... so you can get
a faked number...
Let's say you work with PHP... a PHP script takes under a second to
execute then all connections are closed... so it is possible that the OS can
keep the connection number 101 in state of pending untill there are only 99
active connections on MySQL... yours becoming connection nr 100 ... MySQL
will accept it and serve it...
> 4. how should i measure the cache and ram needed for the value of
connections?
Run it with "acceptable parameters" ... if you see in "SHOW STATUS" high
values for "Aborted_connects" or "Aborted_clients" then you should worry...
Also you might wanna take a look @ Jeremy's "mytop"
(http://jeremy.zawodny.com/mysql/mytop/) !!!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
