Adding a new database to an existing website

  • I was wondering if it is possible to add a new database to my existing WordPress-website, without losing the current logs and comments on my website.

    In the past few months there has been some problems and I had to switch to another hosting company. But the problem didn’t solve. My hosting company complained about heavy server load.

    They explained me that each time a comment is posted, WordPress creates a large temporary table, which is causing the problem. Especially with a large database (my database currently counts 3,422 posts and 75,966 comments).

    The problem is stil existing, but is kept under control, because I’ve installed WP Cache and my hosting company created a resource limit (10 MySQL-queries at a time).

    Is it possible to create a new database to solve the serverload-problem (because the temporary table wouldn’t be that large)? I want to keep the posted logs and comments, but I want the new posted logs and comments to be written to the new database.

    I hope someone can help me.

    I use WordPress 2.1.3 and the only plugins I’m using are WP Cache and the Get-Recent-Comments plugin.

    Thanks in advance.

Viewing 6 replies - 1 through 6 (of 6 total)

  • To do that you would have to rewrite the commenting function.

    What type of table are you using for the mysql? Has it been properly indexed?

    Thread Starter mcbo

    (@mcbo)

    Thanks for your help. I really appreciate. Sorry for my late response.

    I don’t know exactly what you mean with type. There is a table called ‘type’ (in PHPmyAdmin) and for all the WordPress-tables it shows ‘MyISAM’.

    I guess it’s properly indexed. Someone adviced me once to index the field ‘comment_date_gmt’ in wp_comments, and that is – as far as I know – the only change I’ve made in the database.

    Can you tell me how to check if it’s properly indexed?

    Thanks!

    Thread Starter mcbo

    (@mcbo)

    Does anyone know what the best way is to get help with this problem? Is there a website with WordPress-‘specialists’ or something. Thanks in advance.

    WPChina

    (@wordpresschina)

    MCBO: I saw your post for me on that other thread ?? In answer to that question… no, it was not answered.

    Hmmm… for your question here I don’t think it’s so easy to create another db to write to only some tables. I think you might want to get a new host, seriously. If you have that many comments, you obviously have a popular blog. You might want to get a dedicated server even, if you can spare the US$150 minimum for a low-grade server.

    Thread Starter mcbo

    (@mcbo)

    WordPressChina. Thanks for your reply!

    If you haven’t got an answer, how did you reduce the problem on your site? Or have you moved your site to a dedicated server to solve it?

    In fact my website is not that huge. It is visited about 15.000 times a day. I didn’t expect WordPress would create that much traffic: I can imagine there are lots of well-visited WordPress-blogs with a large database.

    Hmm. I keep searching. Wp-Cache helps a lot. The only thing is that commenting takes a while (about 8 seconds). And when a comment is posted (a change has been made), it takes some seconds to refresh the page. I hope the problem won’t get worser.

    WPChina

    (@wordpresschina)

    Right, my blog was not that big either. I moved to a dedicated server.

    Also look at your plugins. Some of them–and I’m no expert on this–apparently cause loads on the server because they are not written so well. Disable any that are absolutely not necessary. Also maybe disable Trackbacks. Also, maybe look at disabling comments on old posts? Maybe anything older than 2 months gets closed? I know this will affect your interactivity on your blog, but it is worth a try…

    I did implement wp-cache and with the new dedicated server I am doing very well. :@

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Adding a new database to an existing website’ is closed to new replies.