Why my server load increases Rapidly

[soft2050]

hmm! i think ur right humour.
at current mysql size is: 800mb.
i already deleted 300 mb from db size.

now i think i need to stop reposting of articles.

but i also don't think db size is main cause.
as elite archive.com has db size of 1.19 Gb
and his site runs fast.

even he is on vps

[CJ]

delete the old posts(too old ones) they dont bring much to site.

[Doublecrosser]

my site has 1.2gb db , and its working fine,
optimize your tables, that should do it.

[Mr Happy]

Don't be crazy and go deleting any posts. Why the hell would you suggest that?

If you have it so all new members recieve a PM or you do regularly send mass PM's to all members then your PM table is one of the biggest tables even for members which are banned or never visit. Delete all old PM's will greatly reduce the size of any DB but won't affect your site speed too much.

Until you find the problem put a flood control limit on Search of 20 or 30 seconds like you see on Warez-BB and other large sites. Search is one of the most resource heavy parts of vBulletin 4. In fact vBulletin 4 search looks like it's coded by a 5 year old and designed for sites with less than 100 members. This will hopefully reduce your server load until you find the problem. Upgrade to the latest version of vBulletin too.

Next disable all mods for a while. While the search is poorly coded if it was the cause of the problem you'd site would be constantly struggling and not have random high peaks. 90% of the time the culprit is a poorly coded mod of some type. We have to find what this poorly coded mod is. I can't really tell much more as the forum is offline but if you do the above you'll at least get it back online and we'll be able to examine it more and go from their.

[soft2050]

i don't use vbulletin.
its datalife engine v9
let me dewlete all pm's as i have many times mass pmed users

also, can there be problem because many users use autoposters for dle to post in many site.
?
will it help if i disable them by posting int he site (autoposters only)

[greatseeder]

Hard reboot the server

[sloddl]

there can be many things... but i wouldn't say that it's ddos... as your site doesn't get that much traffic. maybe google crawls your site too much... some urls which takes long to load/execute (some default searches or big sitemaps if not cached)... or just some bad coded php code. or maybe that your server host isn't configured right.

is it CPU or memory?

+ try to disable as many plugins as possible.

[DownALL]

1. make this feedburner http://www.dl4everything.com/rss.xml
2. disable all unecesary mudules (most u can)
3. optimyze your db every 3 days (is to big you need high cpu)
4. Remove categories tree menu add categories in main.tpl by hand.
5. use gzip mudule, minify module.