[ljianyih]

Hi,

I've a standard dedicated server under Hostgator and hosting just 1 website or vbulletin forum which is gamesdreams.com (a medium size website with around 10 million monthly pageviews).

Hostgator support team has tried and helped me to upgrade server software and tweak the server configuration over the past few months, but gamesdreams.com is still encountering lots of database errors everyday with frequent downtime.

Can vbulletin experts suggest any major php processes or mysql database connection optimization which can solve the sql over-usage problems that lead to database errors?

I'm needing expert help in this because there are simply too much of database errors sent to my mail everyday with slow website loading speed and frequent downtime from database errors. Any help which can help in solving the sql database problems will be greatly appreciated.

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

There are all sorts of database errors and here is an example (almost all errors are from showthread.php as the pages viewed are mostly the forum thread):

Database error in vBulletin 4.2.1:

Invalid SQL:

                                SELECT *
                                FROM style
                                WHERE (styleid = 1 AND userselect = 1)
                                        OR styleid = 1
                                ORDER BY styleid ASC
                                LIMIT 1;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, May 13th 2013 @ 01:01:41 PM
Error Date    : Monday, May 13th 2013 @ 01:02:25 PM
Script        : http://gamesdreams.com/showthread.php?144763-What-s-the-Saying-Level-97-Answer-Cheat
Referrer      : http://gamesdreams.com/showthread.php?139496-What-s-the-Saying-Answers-Cheats-All-Levels
IP Address    : 66.87.120.156
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

One of the main error sent is the style query as shown above. Since vbulletin css is loaded from php files with sql database queries, is it possible to load all the css from external file instead of loading from database to save database resources?