MySQL

MySQL & MariaDB Database Administration & Optimization

Welcome to the database administration and performance tuning hub on saotn.org. In modern web architectures, the database is often the ultimate bottleneck. Ensuring high availability, rapid query execution, and bulletproof data integrity requires a deep understanding of server-side configuration, storage engines, and indexing strategies.

This section delivers practical, hands-on guides for managing MySQL and MariaDB databases in production environments. Whether you are optimizing low-level configuration files (my.cnf), automating routine server backups, upgrading database schemas, or troubleshooting slow-query bottlenecks within content management systems like WordPress, these articles provide verified, real-world blueprints.

Core Database Management Focus Areas

To help you maintain a fast and reliable database layer, our technical MySQL documentation is grouped by operational focus:

  • Performance Tuning & Caching: Eliminate database latency. Learn how to analyze slow query logs, tune InnoDB buffer pools, optimize memory allocation, and configure thread caches to maximize transaction throughput.
  • Backup, Recovery & Replication: Secure your enterprise data against corruption or data loss. Master command-line backup techniques, implement automated cron-job dump scripts, and orchestrate safe database restoration procedures.
  • Database Maintenance & Upgrades: Keep your database engine secure and compliant. Navigate version migrations safely, optimize database tables to reclaim storage space, and manage user privileges via secure access control baselines.
  • Application Layer Integration: Bridge the gap between your web server and data store. Discover best practices for configuring secure socket connections, tuning persistent database connections, and managing relational integrity for high-traffic web applications.

Browse the chronological archive below for deep-dives into SQL syntax execution, database engine conversions, and expert-level server-side troubleshooting.

apt-cache search monit lists "monit – utility for monitoring and managing daemons or similar programs"

Codebase

Last updated:

MySQL Connector/ODBC C# test script

Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used

High Performance MySQL

GNU/Linux

Last updated:

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Are you running into MySQL load problems? InnoDB Buffer Pool optimization is an important step in tuning MySQL servers for heavy InnoDB workloads. Configuring innodb_buffer_pool_instances and increase read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. And by doing so, you run your database & server more efficiently and faster. Here is a little help for you.

Bash logo

GNU/Linux

Last updated:

Turn off swap

Learn how to turn off swap in Bash, because when a swap partition is enabled Linux starts swapping, which may degrade (MySQL) system performance

WordPress

Last updated:

Disable WordPress comments (how-to)

With thousands spam reactions, disabling (and removing) WordPress comments is often the only way to go. Here is how to disable WordPress comments in both the WordPress Dashboard interface and in your MySQL / MariaDB database.

Joomla ACL decision flowchart

Web applications

Last updated:

8 Tips to improve Joomla performance

Learn how to speed-up Joomla performance on Windows Server IIS using these 8 simple, but important, tips. Add caching, gzip compression, set your sessions & optimize MySQL database functions.

High Performance MySQL

GNU/Linux

Last updated:

Convert MySQL MyISAM tables to InnoDB

Converting MyISAM tables to InnoDB for more database performance, because: 1) MyISAM is old and no longer developed, and 2) InnoDB is much faster.

High Performance MySQL

WordPress

Last updated:

Wp_options table autoload micro-optimization

The autoload feature loads and caches all autoloaded options, if available, or all options. The default option is to autoload, and over time when the wp_options table grows, this degrades performance. Today I noticed a slow MySQL query coming from a WordPress database (WordPress wp_options table). This made me investigate and to optimize the WordPress wp_options table “autoload” feature.

High Performance MySQL

Useful

Last updated:

Check, repair and optimize MySQL tables with mysqlcheck

MySQL’s mysqlcheck is a command line table maintenance program: it checks, repairs, optimizes, or analyzes tables. Very handy for automated performance optimizations of MySQL databases and tables.

WordPress logo

WordPress

Last updated:

Clean-up spam comments and meta data

Delete WordPress spam comments and meta data in your database, easily with phpMyAdmin or mysql cli. Keep your WordPress database lean & mean!

blue elephant plush toy on black laptop computer -- Photo by Ben Griffiths

Codebase

Last updated:

Optimize all MySQL tables with MySQLi multi_query

PHP MySQLi extension supports multiple queries which are concatenated by a semicolon. We can use this to optimize all MySQL tables in one single multi_query statement.

WordPress

Last updated:

Block WordPress comment spammers manually

The less spammers hit your WordPress blog, the better your blog performs, is one of my opinions. A second is, the less unnecessary plugins you use on your WordPress blog, the better. So, a little while ago I decided to remove plugins like Stop Spammer Registration Plugin and do its work myself.

If you like this site or encourage its development, you can transfer a direct donation via Paypal or bank wire-transfer IBAN: NL31 ABNA 0432217258 (Jan Reilink). Thanks! :-)

© 2026 Sysadmins of the North

Privacy Policy Terms of Service