[snakes1100]

Originally Posted by ljianyih

Yup, the css are already stored as files.

The problem that leads to the database errors and slow loading time of gamesdreams.com is basically the piles up of php and mysql processes. There are too much processes to be handled and the piles up of database processes eventually consume all the server memory and leads to mysql server gone away and server downtime problem (often when vbulletin errors appear, the forum pages are encountering very slow loading speed, and after more than 1 minute of waiting time, the errors appear leading to chain effect affecting all other pages with errors for a period of time).

I've contacted hostgator experts to tweak lots of the server setting, but the problem still persist as the mysql has limited memory and resources to handle high number of php or mysql processes.

Is there any major changes or sql optimization I can make on my GamesDreams vbulletin forum so that the database queries will be reduced? The error mentioned is just one of several different types of errors, and max_user_connection limit is another error type with many others (Greatly increasing the limit caused even more errors after the test out). All these errors are mainly caused by the piles up of processes, memory being consumed, server speed greatly slowed down, page cannot load with database errors, and finally leading to website downtime.

GamesDreams is just a medium size website and I believe a standard dedicated server hosting only this vbulletin forum should be able to support it nicely. Even with a much better dedicated server, I'm wondering how huge vbulletin forum like digitalpoint get loaded so smoothly (as GamesDreams is encountering hundreds and thousands of mysql database errors with frequent downtime even it has just moderate traffic).

As i stated earlier, hostgator couldnt optimize a server if theyre lives depended on it.

Unfortunately no, there isnt any major changes you can simply make to SQL to make it perform the way you want it to, the entire server needs to be checked to see whats going on.

As we have no details on your server, its hardware or any other details about the server, its not a simple thing to diagnose from here.