Activity Stream
48,167 MEMBERS
64905 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 25

Hybrid View

GoPantheoN Database causing server load 30th Aug 2010, 06:39 PM
NewEraCracker Yes. You should move to a VPS as... 30th Aug 2010, 06:42 PM
GoPantheoN Will 850mb pwn shared hosting ? 30th Aug 2010, 06:50 PM
CJ u can always remove threads with... 30th Aug 2010, 06:50 PM
GoPantheoN Oh ok I will start to remove the... 30th Aug 2010, 06:56 PM
sloddl 1. does it cause high CPU load or... 30th Aug 2010, 06:59 PM
Mr Happy Their's lots of stuff you can do. ... 30th Aug 2010, 06:59 PM
GoPantheoN It causes high CPU load and also... 30th Aug 2010, 07:05 PM
sloddl 1. configue max. processes... 30th Aug 2010, 07:06 PM
sloddl if your server runs lighttpd then... 30th Aug 2010, 07:08 PM
GoPantheoN Thank you for suggestions sloddl. I... 30th Aug 2010, 07:12 PM
aishamontreal Try install any Cache Mod, this... 30th Aug 2010, 07:17 PM
GoPantheoN The tables at high sizes. ... 30th Aug 2010, 07:19 PM
GoPantheoN Just now Optimised and repaired the... 30th Aug 2010, 07:41 PM
GoPantheoN Can some one tell me whats this... 31st Aug 2010, 11:43 AM
Lock Down Try this link:... 2nd Sep 2010, 10:23 PM
NewEraCracker Is your host using MySQL 5.0 or... 2nd Sep 2010, 10:26 PM
GoPantheoN @ Lock Down... 4th Sep 2010, 05:03 AM
GoPantheoN I opened ticket to enable the db,... 4th Sep 2010, 07:22 AM
innocent_kid i suggest u to move to vps asap 4th Sep 2010, 07:29 AM
GoPantheoN Ya but I think VPS costs a bit more... 4th Sep 2010, 07:34 AM
$@ND!P? well now a days u can get vps... 4th Sep 2010, 07:46 AM
GoPantheoN @ $@ND!P™ : Ya first am going see... 4th Sep 2010, 07:52 AM
devilmaycry buy from myoffshorehost.in and we... 4th Sep 2010, 08:00 AM
GoPantheoN For now from the suggestion I got... 4th Sep 2010, 11:00 AM
Previous Post Previous Post   Next Post Next Post
  1.     
    #1
    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
    GoPantheoN Reviewed by GoPantheoN on . Database causing server load I am having a warez forum with 120K threads, 3.6K members and the db size is around 850 mb. The site is currently on a shared hosting in a server that has 8 cores. The db got disabled often and I had to open a ticket for enabling the db. Now they noticed me that my db is using too much of resources and so its getting disabled. This already happened and so I removed vBseo which caused the high load last time. I have checked this thread Rating: 5

  2.   Sponsored Links

  3.     
    #2
    Member
    Website's:
    tufos.net
    Try install any Cache Mod, this will reduces drastically requests to your database

  4.     
    #3
    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

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

  6.     
    #5
    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.

  7.     
    #6
    Respected Member
    Try this link: http://tracker.vbulletin.com/browse/VBIV-698

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

  8.     
    #7
    Moderator
    NewEraCracker's Avatar
    Is your host using MySQL 5.0 or 5.1?
    (Check in Cpanel)
    Trusted: Dom, l0calh0st, 0ccul7, robert420
    Find all threads started by NewEraCracker

  9.     
    #8
    @ 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.

  10.     
    #9
    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.

  11.     
    #10
    Member
    i suggest u to move to vps asap

Page 2 of 3 FirstFirst 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VPS Causing High Server Load
    By zinc in forum Hosting Discussion
    Replies: 18
    Last Post: 13th Oct 2012, 11:13 PM
  2. Server CPU load
    By tractor3231 in forum Server Management
    Replies: 6
    Last Post: 10th Jul 2011, 04:52 AM
  3. Database cause high server load
    By DoctorX in forum Server Management
    Replies: 28
    Last Post: 20th Jun 2011, 11:22 AM
  4. Server Load
    By Last Word in forum vBulletin
    Replies: 0
    Last Post: 3rd Apr 2010, 10:45 AM
  5. Any way of knowing whats causing load?
    By Neokenzo in forum Webmaster Discussion
    Replies: 0
    Last Post: 28th Sep 2009, 11:07 PM

Tags for this Thread

BE SOCIAL