1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL database very high

Discussion in 'Web Hosting' started by matwan, Jan 26, 2014.

0
  1. #1
    hello,

    i have a question and need your help.

    i have built up an Amazon autoblog using wordpress.

    i checked my MySQL database usage for the autoblog,it is very high about 826MB.

    what cause this situation and how to reduce the usage of database?

    thank you.
     
    matwan, Jan 26, 2014 IP
  2. WSWD

    WSWD Well-Known Member

    Messages:
    1,420
    Likes Received:
    65
    Best Answers:
    1
    Trophy Points:
    175
    #2
    If there is a lot of data in there being autoblogged, you aren't going to be able to reduce that size. How many posts have been made?
     
    WSWD, Jan 26, 2014 IP
  3. matwan

    matwan Member

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    hello,

    there are thousands posts.i already disable and delete the plugins for autoblog but the MySQL database usage still high and no change.the hosting provider told me that i must resolved this issue unless my hosting account will be suspended.
     
    matwan, Jan 27, 2014 IP
  4. TIEro

    TIEro Active Member

    Messages:
    741
    Likes Received:
    177
    Best Answers:
    5
    Trophy Points:
    70
    #4
    Oh, how cool...

    Follow the link in my signature. I specifically wrote the (free) TIEtools plugin to manage this. It will expire old posts, expire the images (but keep the posts), handle your log files and spot (simple) duplicates. Runs automatically on wp-cron, so you just fire and forget. I use it on all my sites with news feeds or other automated stuff - works a treat (of course, since I wrote it for what I needed).

    I would also suggest installing the "Optimize database after deleting revisions" plugin by CAGE Web Design (also free, on WP.org). Run an optimisation every few days to keep things clean and tidy on the DB side.

    Oh, and set your trash days to 1 (http://codex.wordpress.org/Editing_wp-config.php#Empty_Trash), so the old posts get thrown out every couple of days.

    Hope it helps!! :)
     
    TIEro, Jan 27, 2014 IP
  5. matwan

    matwan Member

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #5
    i will try it.thanks,brother.
     
    matwan, Jan 27, 2014 IP
  6. TIEro

    TIEro Active Member

    Messages:
    741
    Likes Received:
    177
    Best Answers:
    5
    Trophy Points:
    70
    #6
    Please do let me know if it's useful. About 800 downloads (in the old and new versions) and it's only had one rating on WP, so I don't even know if site owners think it's worthwhile. Would appreciate any thoughts.
     
    TIEro, Jan 27, 2014 IP
  7. matwan

    matwan Member

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #7
    ok.thanks.
     
    matwan, Jan 27, 2014 IP
  8. q7m

    q7m Well-Known Member

    Messages:
    1,178
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    Digital Goods:
    1
    #8
    I would also recommend you to use a cache system (there should be such plugins for wordpress). This will heavily reduce the number of database calls (reducing the mysql server load) and it will also increase the page loading speed of your site.
     
    q7m, Jan 30, 2014 IP
  9. matwan

    matwan Member

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #9
    hello,

    i already use the plugin and it is very awesome.thanks.
     
    matwan, Jan 30, 2014 IP
  10. matwan

    matwan Member

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #10
    hello,

    your plugin is very good and my issue resolved.thanks.
     
    matwan, Jan 30, 2014 IP
  11. TIEro

    TIEro Active Member

    Messages:
    741
    Likes Received:
    177
    Best Answers:
    5
    Trophy Points:
    70
    #11
    Excellent news! :)
     
    TIEro, Jan 31, 2014 IP