MySQL error

V6.1.4, VPS...sites are running but kicking out these errors.

Mysql error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/coffee13/public_html/roundtable/periodic/notifies.php
            [line] => 22
            [args] => Array
                (
                    [0] => /home/coffee13/public_html/roundtable/inc/db.inc.php
                )

            [function] => require_once
        )

)


Called script: /home/coffee13/public_html/roundtable/periodic/notifies.php
Request parameters:

Array
(
)


</div>            </div>

Quote · 29 Sep 2008

Please read about 'Can't connect to local MySQL server' in internet (google) or use search of this site to find cause.

This is asked not in first time.

All problem that your host lost connection with your database.

Try or expand timeout of connection to your SQL or wrote about it to your host support.

Quote · 30 Sep 2008

This is a problem with your web host.

----
Quote · 30 Sep 2008

Hi Andrey,

-

Can you detail here how I expand timeout connection please?

-

Thanks.

-

Lorren

-

Please read about 'Can't connect to local MySQL server' in internet (google) or use search of this site to find cause.

This is asked not in first time.

All problem that your host lost connection with your database.

Try or expand timeout of connection to your SQL or wrote about it to your host support.

Quote · 30 Sep 2008

OK, so I have read everything related to the error on here. It is your host (I'm on VPS and just restarted server); can be because of too many connections (that's why I'm on a VPS, have changed pconnect to connect).

-

What other coding items do I need to look at or change?

-

Thanks,

-

Lorren

Quote · 30 Sep 2008

Servers have been restarted and it is up and running, but there must be some coding that I need to adjust.

-

Can anyone please tell me what to change and why?

-

Thanks.

-

~~ Lorren

Quote · 30 Sep 2008

You can decrease count of connections to your SQL ..

for example try to begin remove blocks from index page .. that can show any statistic .. ,aybe here something unnecessary

Just make your pages more light and faster

Quote · 1 Oct 2008

Hi Andrey,

-

Thanks for the response.

-

Here is what my host said about the MySQL issue...Any more thoughts on this? Since it appears to be somewhat related to the spy on homepage...perhaps Chris (topher) can chime in on this one also.

-

~~ Lorren

-

When services begin to go down on servers, such as MySQL, it is usually due to high resource usage. I've looked at your account's resource usage over the last several days and have found several errors related to your memory usage. Your apache log files indicate that most of the errors were given when the following page was accessed:

/home/lrepton2/public_html/community/cc_forum_spy.php

I don't however see this as a constant memory usage, but rather quick and large spikes. High memory usage is most often attached to heavily php and MySQL driven sections of your website, such as a blog or a forum. If you have a large forum for example, you may have been crawled by a search engine. When this happens, the search engine is requesting 100's of pages in your account in a small amount of time. If you are getting spidered by search engines there is a simple fix that can be applied. The fix would entail you placing a file called "robots.txt" in your home directory, this file would tell
certain(or all) search engines to disregard your site or certain directories. Usually you can get by with only excluding galleries or forums. For more information on this you can look over the following information.

Link: http://www.robotstxt.org/

You can decrease count of connections to your SQL ..

for example try to begin remove blocks from index page .. that can show any statistic .. ,aybe here something unnecessary

Just make your pages more light and faster

Quote · 3 Oct 2008
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.