Category Archives: MySQL

Deleting old MySQL tables across blogs and databases in WPMu

OK, so this will probably be the final installment of my “pimp your WPMu databases” series Part one was moving from WPMuDEV’s Multi-DB package to SharDB; part two dealt with optimizing tables across a number of databases in MySQL, and the final installation will share some SQL code, once again thanks to Gowtham, […] Continue reading

Posted in , devwpmued, MySQL, UMW Blogs, wordpress multi-user, wpmu, wpmu development, wpmudev, wpmued | Leave a comment

Changing the Oil on a Multi-Database WPMu Install

And to build on my last post about Moving from Multi-DB to SharDB on WPMu, here is a rundown on some of the work done to further optimize the multiple-databases for our WPMu at UMW Blogs.
First off, we have a plugin install called WordPress MU Sitewide Tag Pages that basically republishes every public post […] Continue reading

Posted in , devwpmued, multiple databases, MySQL, oil change, UMW Blogs, wordpress multi-user, wpmu, wpmu development, wpmudev, wpmued | Leave a comment

WPMu Multi-DB Tutorial

Sooner or later we had to do it on UMW Blogs, and over a week ago we made the jump to a multi-database setup for our WordPress Multi-User environment. We have a subscription to the WPMu Dev Premium service, which gives us access to the Multi-DB script. This code enables you to break one database […] Continue reading

Posted in , database, mapped domains, multi-db, MySQL, phpmyadmin, sql, tutorial, UMW Blogs, upgrading, Wordpress, wordpress multi-user, wpmu, wpmu development, wpmued | 4 Comments