The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
11-13-2008, 07:43 PM
|
|||
|
|||
help database making over load
ok my site is down and i get a message this site has used max cpu usage.. i called my host and ask them whats wrong they saying ur database is overloading the server meaning its searching too much if it don't found some thing it keeps looking n looking for it.. he said optimize the tables n queries
any one know how to do this ? thanks in advance... i have 3.7.3 atm installed and my db is arounfd159 mb and has around 30 mods installed in it. 
|
|
#2
11-13-2008, 08:05 PM
|
||||
|
||||
|
There is a repair/optimize option in your admin cp > maintenance > repair/optimize tables You won't have access to that right now if your site is down. Do you have phpMyAdmin? You may select the tables and do an optimize at the bottom of the list of tables.
|
|
#3
11-13-2008, 08:31 PM
|
||||
|
||||
|
There are tons of settings and configuration options you can use to optimize vBulletin with before you hit your server load.
If you are on shared hosting, what kind of traffic are you getting? Most shared companies will shut a vBulletin forum down after about 15-25 concurrent connections are being hit often, and its usually about the time when CPU usage is to high as well. And what modifications do you have installed?
|
|
#4
11-14-2008, 12:41 AM
|
|||
|
|||
|
ty guys for your prompt reply
ok i did the repair and optimizing the tables and these are the mods i am using Quote:
|
|
#5
11-14-2008, 02:39 AM
|
||||
|
||||
|
Um... wow! That's a lot of mods! I'd try disabling the server intensive ones and see if that helps (I only have one or two of those, so I'm not positive if I've listed the correct ones) - any stats mod like Advanced Stats, who read a thread, arcade and casino, vbplaza, activity mod, vbshout, image resizer..... you know, you've just got a *ton* of mods that look server intensive. I can totally understand your host saying you are maxing out the cpu. Try just disabling all your mods and see how the site runs for a few days:
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php PHP Code:
|
|
#7
11-14-2008, 06:50 AM
|
||||
|
||||
|
|
|
#8
11-14-2008, 10:46 AM
|
|||
|
|||
|
Quote:
wow thanks bro i will uninstall that mod  lets see whats effect that has on site. but is there any other mod to re size the images ? that wont effect the server --------------- Added [DATE]1226688057[/DATE] at [TIME]1226688057[/TIME] --------------- nop still over laoding server --------------- Added [DATE]1226709976[/DATE] at [TIME]1226709976[/TIME] --------------- ok this is what they said Code:
top - 14:13:47 up 12:04, 4 users, load average: 59.62, 43.81, 35.38 Tasks: 406 total, 54 running, 345 sleeping, 1 stopped, 6 zombie Cpu(s): 85.4% us, 12.8% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 1.8% si Mem: 8199836k total, 4310624k used, 3889212k free, 107184k buffers Swap: 4192924k total, 0k used, 4192924k free, 1507248k cached Thank you,
|
 |
«
Previous Thread
|
Next Thread
»
Linear Mode
|
|
All times are GMT. The time now is 05:31 PM.