Hi to all I'm running a Wordpress MS installation and I would like to move a couple of heavy "sub" blogs on a different DB, will it encrease my performances? Actually I'm on a dedicated server with quadcore 2.5 Ghz, 6GB ram and a few nice stuff like Lightspeed eaccelerator and so on. I'm a "self made webmaster" so I need an easy to follow guide that can teach me how to split safely my DB and improve my performance. Thank you very much for this! (just read: Split WP install between 2 databases? is this the only solution available or there is an easier one?)
WPMUdev has a Multi-DB plugin but you won't see any performance gains from splitting your database up unless you have a very high volume of sites with thousands of tables.
From the plugin instructions: