Max_user_connections

[bromios]

Response 1:

 

You may want to run through the following list so as to ensure that your web site is configured most efficiently.

 

- Each application that interfaces with a database should be using its own individual MySQL database username to connect to the database. Sharing a single database user with multiple applications will result in you prematurely hitting the set user limit of 15.

 

- You should not be using your system username and password for authentication purposes within your applications configuration. This will also result in premature consumption of set limits.

 

- You should ensure that your applications are configured to connect without Persistent database connections. Contact the developer of the application for assistance if required.

 

Response 2

 

The issue appears to be that your queries are simply taking a very long time to complete, rather then being persistent. Our server shows your user in the slow-query log quite often. Here is an excerpt:

 

# Time: 071107 9:44:04

# User@Host: shampooe_dk[shampooe_dk] @ localhost []

# Query_time: 6248 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

use shampooe_swidish;

delete from whos_online where time_last_click < '1194439496';

 

# Time: 071107 6:29:19

# User@Host: shampooe_dk[shampooe_dk] @ localhost []

# Query_time: 432 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

use shampooe_swidish;

select configuration_key as cfgKey, configuration_value as cfgValue from configurati

on;

 

# User@Host: shampooe_dk[shampooe_dk] @ localhost []

# Query_time: 274 Lock_time: 216 Rows_sent: 0 Rows_examined: 0

use shampooe_swidish;

select banners_id, date_scheduled from banners where date_scheduled != '';

 

You may be able to resolve this by just optimizing your queries and database tables.

 

 

Now look my configure.php

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'XXXXXXX');

define('DB_SERVER_PASSWORD', 'XXXXXXXX');

define('DB_DATABASE', 'shampooe_swidish');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql');

 

 

If any body can help me!

 

Regards

[Jan Zonjee]

If any body can help me!

This thread: A Store Speed Optimization in Progress, Step by step from a vanilla install! has a lot of tips on that subject.