MySQL Error

[Boofo]

Ask then what you max db connections is set to.

[fanhockeycoach]

thanks for all your help so far. I have two more questions:

1. In the config.php file under master database server name, what is the difference if I put in the servername compared to IP address? Does it change anything if I use one or the other?

2. What is a slave database?

--------------- Added [DATE]1305652716[/DATE] at [TIME]1305652716[/TIME] ---------------

Originally Posted by Boofo

Ask then what you max db connections is set to.

What should it be set too?

[Boofo]

Originally Posted by fanhockeycoach

thanks for all your help so far. I have two more questions:

1. In the config.php file under master database server name, what is the difference if I put in the servername compared to IP address? Does it change anything if I use one or the other?

2. What is a slave database?

What should it be set too?

It should look like this:

// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

You don't have a slave database as that would be on another server, IIRC.

My max_connections are set to 300, but I am on a VPS, and that is probably overkill. Hostagator has their shared accounts set to 25, IIRC.

[fanhockeycoach]

Originally Posted by Boofo

Ask then what you max db connections is set to.

My max is 10. So what does that mean?

[Boofo]

It means you need to get a new host. If you get very many users on at the same time, you will keep having those kinds of errors.

[fanhockeycoach]

I got 100 VB Database errors yesterday and might site wasn't showing up. I got another 20+ today.

My host shows I am only using 58 of my 300 mb. Would adding another 1000MB help reduce these errors or should I be looking for a new host?