mysql - Throw Out The Manual

mysql

A collection of 2 posts

Clearing out table rows across databases in WordPress Multisite

I've been doing some optimizing of databases on a very large (32k site) WordPress Multisite that currently is split using MultiDB into 256 databases. The size of the databases seemed abnormally large and upon closer inspection I found a lot of rows in the options table for each site that

Managing Databases with cPanel

cPanel includes several tools for managing databases in your account. The MySQL Database Wizard is a quick way to create databases, database users, and associate the two. The MySQL Databases area will show you all the databases and users you've created an help you manage the creation and deletion of