Mysql using /tmp/mysql.sock for connections?

[Sensei]

In some testing I'm doing, I have multiple domains and im using in my msyql connections

localhost:/tmp/mysql.sock

Now I was wondering if there was a limit with the number of connections here and if there was a better way?

[PLBlaze]

Sensei,

Not sure if i get the question right but i will try to answer.

The socket is used just to listen to incoming connections that mysql's port 3306 use.It should not matter from what domain they come as long as the user/host has the rights to access the database.If i'm right,by default mysql limits connections to 100 but they could be increased when compiling mysql.Maybe there are some limits but i'm newbie to mysql and don't really know.At least i tried...Hope this helps.

Have you tried to look on mysql's site (http://www.mysql.com) ?

[Sensei]

So when I put /tmp/mysql.sock into whatever program's config, this just lets that program know how to connect to mysql and has no bearing on connection loads. That actually can be done on mysql startup.

[PLBlaze]

Right, some programs expect mysql.sock under /tmp and will refuse to work/startup if the socket is in another folder/directory.Same goes for the port mysql listens (3306) i belive.Yet again hope this helps.