Question About MySQL Connections

[gobbly2100]

Alot of people I know have some kind of problem with reaching a maximum number of connections to MySQL but what I want to know is this:

HG say they allow 30 connections but what is this limited too?

If I am running various databases on my account is it better if I create a seperate MySQL user for each database?

[Impavidus]

The limit is for each mysql user. If create a user for each mysql datebase, each will then a 30 connections limit. Just do not use pconnect.

[riostyles]

Hello,
Also do not forget to connect with a simple "mysql_connect" involving timeout and disconnection after work. No persistent connection.

[gobbly2100]

What is a simple MySQL_connect?

[riostyles]

Hello,

Originally Posted by gobbly2100

What is a simple MySQL_connect?

http://forums.hostgator.com/showthre...=MySQL_connect
See also
http://br.php.net/manual/en/function.mysql-connect.php

[Serra]

Originally Posted by gobbly2100

If I am running various databases on my account is it better if I create a seperate MySQL user for each database?

Yes, it is better to have different users for each database.

[riostyles]

Originally Posted by Serra

Yes, it is better to have different users for each database.

I second Serra and it is much more secure.
Also per database it is also recommended to create a minimum of two "Groups", meaning users; one admin with full privileges, maybe one person -> you and an "User" acces with just the privileges they require for to do what they have to do.
So you will have for ex.:
basea_jimadmin ->full privilege
basea_everybody -> whats needed
baseb_ etc

Remember that login in with the domain login/Pwd you have also full privilege but only use this in a domain root connect, not in or under a public_html.

Some e-commerce/PRM are disciminating admin / users, some not.