Throw Out The Manual
  • Home
  • Mastodon

mysql

A collection of 2 posts
mysql

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
Mar 22, 2019 — 2 min read
reclaim

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
Dec 19, 2015 — 3 min read
Throw Out The Manual © 2023
  • Sign up
Powered by Ghost