Quote:
|
Originally Posted by lse123
by saying "clients" you mean Web Servers(in case locally) ? either these run same time or at differ time each?
|
Clients = one connection to MySQL.
If your Tomcat makes one connection to MySQL, it's one client.
Then at the same time (or not at the same time), you have PHP/Apache connects to the same MySQL server, then it's the second client.
Then you may also have other clients, like
SQLyog connecting to MySQL ... it's also (you guessed it) a client.
Also, you may have
PDNS running and connecting to the same MySQL. Needless to say, it's also another client.
As far as MySQL concerns, it doesn't care if Tomcat/Java or PHP/Apache or SQLyog or PDNS or any other software you can imagine connects to it (as long as the credentials checks). It just count how many connections are open at any given time. If something is connecting to it, it'll check the credentials and check if it can still make connections. If yes, then you're in. If not, then MySQL will throw
too many connection erros.