Server Overloads

My server overloads twice a day I beleive its from MYSQL does anyone know what might be causing this?  I knwo its not the cron jobs...

It could be a number of things, what type of server do you have, how old, specs, etc.  On the other end is this is the only thing on the server, if so how many members do you have, if not what else is on there that may be using resources.  Finally is it the server that overloads and what happens, a reboot?  a denial of service attack can cause server overloads so do you have a firewall installed.  If you put custom scripts in server are you sure there isn't an accidental infinite loop somewhere?

You can install Profiler module (don't forget to apply modifiction in header.inc.php file) and enable logging for long MySQL queries, later you can investigate logs to find bottlenecks

My server is a VPS but Dolphin 6 ran fine with over 3000 users now twice a day something overloads my server...

I have Profiler installed....   What do I need to mod in the header.inc.php file???

Please follow instructions after Profiler module installation, you need to press (+) to see it

Where do I press + at???

You will have to uninstall profiler, and then reinstall it. At the top of the page where is says it was installed sucessfully, there will be a + next to it so you can see additional information. Thats where you will find the instructions.

Actually it will just be easier to look at the following file in your dolphin installation.

modules\boonex\profiler\install\info\inst_concl.html

Sweet now its installed....

So I never noticed that plus sign for the modules before did others have it as well??

Yes, they all do.