1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with big database

Discussion in 'Black Hat SEO' started by Danios, Nov 5, 2009.

  1. Danios

    Danios Registered Member

    Joined:
    Oct 26, 2009
    Messages:
    59
    Likes Received:
    5
    Location:
    EU
    Home Page:
    Hey guys, I have created an autoblog and started to gain some traffic, the only problem is that the script is working so hard soon it will run out of mysql memory, my hosting limit is 32MB, the strange part is that most of the records are in wp_postmeta 86K , wp_terms 16k, wp_term_relationships 36k and wp_term_taxonomy 16k.

    Is there any way to reduce these number, I only have about 12 K post and I see a lot of agregators with hundreds of thousands.

    I think in the future I will go for relevancy instead of quantity.
     
  2. Danios

    Danios Registered Member

    Joined:
    Oct 26, 2009
    Messages:
    59
    Likes Received:
    5
    Location:
    EU
    Home Page:
    Nobody knows ?
     
  3. FarmTeam

    FarmTeam Junior Member

    Joined:
    Jun 27, 2009
    Messages:
    139
    Likes Received:
    79
    Is it php runing out of memory or mysql? I am going to assume you meant php.

    You can possibly override the default ini settings. If not you either need to adjust your queries or rewrite your script, if not switch hosts to a dedicated where you have full control over ini settings if your getting enough traffic to make it worth while
     
    • Thanks Thanks x 1
  4. Danios

    Danios Registered Member

    Joined:
    Oct 26, 2009
    Messages:
    59
    Likes Received:
    5
    Location:
    EU
    Home Page:
    ok, that helped.
     
  5. lolosland

    lolosland Newbie

    Joined:
    Feb 16, 2009
    Messages:
    17
    Likes Received:
    37
    or even better, im not sure about wp but i know about joomla, make all the sites static :)

    that will automatically stop any sql queries and php
     
    • Thanks Thanks x 1
  6. lolosland

    lolosland Newbie

    Joined:
    Feb 16, 2009
    Messages:
    17
    Likes Received:
    37
    oh and if you ask how, look for some kind of component or extras
     
    • Thanks Thanks x 1
  7. Danios

    Danios Registered Member

    Joined:
    Oct 26, 2009
    Messages:
    59
    Likes Received:
    5
    Location:
    EU
    Home Page:
    It's actually the php memory (different stuff) which is used mostly by autoblogged and as a result the xml sitemap plugin crashes. I can't edit the ini file so i think i'm going to use the plugins alternatively. If you have better ideas please post them.