Untitled attachment
https://assets.chaos.social/media_attachments/files/112/891/997/702/977/979/original/d174a0ee09c1a4fd.png
Then build a replication architecture and a plan for downtime-free upgrades, and a plan for smooth high availability primary pairs using shared disks (using DRBD with great success).
Get in some nice MSA arrays from HP, spread load over spindles.
Get more memory, keep working set in memory, get rid of disk reads.
Learn that MySQL has a global InnoDB Buffer Pool lock, engage with my MySQL colleagues and ask for a version of MySQL with per-page locks.
Great success, and with 5.0.36 it is GA.
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.