Database causing server load

[GoPantheoN]

Thank you for suggestions sloddl. I will do them asap.

@ Mr Happy, ya I will first prune the pms, they are the having large size next to posts.

List of mods



I installed the Periodic Pm pruner but its incompatible for vB 4

@ sloddl, the server runs on apache

[aishamontreal]

Try install any Cache Mod, this will reduces drastically requests to your database

[GoPantheoN]

The tables at high sizes.

searchcore_text - Data Length : 238.65 MB Index length: 150.96 MB

Post - Data Length : 248.79 MB Index length: 9.01 MB

Does the searchcore_text contains the search data?

@ aishamontreal : Sorry,I forgot to mention that I have enabled even the datastore option in vBulletin

[GoPantheoN]

Just now Optimised and repaired the db using vBull Maintenance option. For now the server seems to be low.

[GoPantheoN]

Can some one tell me whats this table for ?

searchcore_text - Data Length : 238.65 MB Index length: 150.96 MB

Few has asked my question http://www.vbulletin.org/forum/showthread.php?t=238063 but no reply.

[Lock Down]

Try this link: http://tracker.vbulletin.com/browse/VBIV-698

Claims that 4.04 has cut that table way down removing unused fulltext indexes.

[NewEraCracker]

Is your host using MySQL 5.0 or 5.1?
(Check in Cpanel)

[GoPantheoN]

@ Lock Down Thank you for the link, checking it.

@ NewEraCracker MySQL 5.0.91

Now also the db got disabled, so only the site gets redirected to the installation location.

[GoPantheoN]

I opened ticket to enable the db, then the server load went up to 40, the again my db got disabled and lol now the server load is only 0.8

I guess the only way is moving to a VPS.

[innocent_kid]

i suggest u to move to vps asap