Better performance with multiple blogs: single mysql database or multiple mysql

  • 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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Michael Torbert

    (@hallsofmontezuma)

    WordPress Virtuoso

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

    Thread Starter HowToBlog

    (@howtoblog)

    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.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.remarpro.com Admin

    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 https://mu.www.remarpro.com instead of using multiple WP installations. Might save you lots of trouble.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Better performance with multiple blogs: single mysql database or multiple mysql’ is closed to new replies.