WordPress.org

Forums

Better performance with multiple blogs: single mysql database or multiple mysql (4 posts)

  1. HowToBlog
    Member
    Posted 7 years ago #

    I have a dedicated server with many wordpress blogs. My host provides for unlimited mysql databases. As such, in the past I'd been creating a new mysql database for each WordPress blog.

    Now I'm wondering, completely from a performance perspective, whether it would be faster/wiser to use a single mysql database with different table prefixes or to continue using seperate mysql databases per wordpress install. Does having many mysql databases slow down the server at all?

    I've searched through the forums to try to find this answer, but there does not seem to be anything that addresses how multiple or single mysql databases affects speed of wp-admin and wordpress sites in general.

    Any help anyone can provide would be greatly appreciated!

    Thanks in advance!

    Emily from How to Blog

  2. Michael Torbert
    WordPress Virtuoso
    Posted 7 years ago #

    It shouldn't really make a difference either way, but for your purposes, just use a different database for each blog.

  3. HowToBlog
    Member
    Posted 7 years ago #

    thanks hallsofmontezuma for answering my question!

    i've got a log of wordpress blogs, and had been using a different database for each blog. lately my dedicated server has been sluggish and i've been advised to increase ram. wasn't sure if having so many mysql databases was affecting performance of my server and i hadn't really seen this topic addressed.

  4. Hmmm.. That's an interesting question, actually. I'm not familiar enough with MySQL's internals to answer it for certain, however I feel that you'd likely get better performance with using one database and multiple prefixes. This is what WP-MU uses (one database with multiple tables), and it gets quite good performance and scalability even with many thousands of blogs.

    If you're setting up lots of similar blogs, I'd seriously look into http://mu.wordpress.org instead of using multiple WP installations. Might save you lots of trouble.

Topic Closed

This topic has been closed to new replies.

About this Topic