0 views collected around this technical thread.
Oracle’s post‑acquisition strategy has left MySQL lagging behind modern developers, while PostgreSQL, praised for features like parallel queries and vector search, now dominates the open‑source database market, prompting calls for MySQL’s transfer to the Linux Foundation to avoid obsolescence.
This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, interprets their reports, and also contains promotional material for unrelated AI services.
Running ANALYZE TABLE on MySQL, Percona Server, or MariaDB can block queries in older versions, but from MySQL 8.0.24, Percona Server 5.6.38+, 5.7.20+, and MariaDB 10.5.4+, the operation is safe and no longer causes disruptive locks.
This article provides an in‑depth overview of Percona Backup for MongoDB (PBM), covering its architecture, installation steps, configuration, logical full backups, point‑in‑time incremental backups, restoration procedures, performance testing, selective backup options, known limitations, and useful command‑line examples.
This article explains the features, advantages, drawbacks, and step‑by‑step installation process of a MySQL high‑availability Percona XtraDB Cluster (PXC), covering configuration, firewall settings, SELinux disabling, node initialization, clustering parameters, and verification commands.
This article explains the background, principles, architecture, and detailed implementation of Percona's thread pool, and describes TXSQL's dynamic thread‑pool activation, load‑balancing strategies, disconnection optimizations, related configuration parameters, status variables, and a concise summary.
This article introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory bottlenecks, and slow‑query problems.
This guide explains how to set up a Percona XtraDB Cluster (PXC) using Docker containers, configure five-node replication with strong consistency, and implement HAProxy as a TCP load balancer to achieve high availability and balanced read/write traffic across the cluster.
This tutorial explains how to create a test database, define tables with foreign key constraints, populate them with appropriate random data using mysql_random_data_load, and work around a known bug that forces the foreign‑key sample size to 100 rows.
MySQL 8.x adds a lightweight backup lock, LOCK INSTANCE FOR BACKUP, which permits DML during online backups while restricting only file creation, account changes, and certain table operations, requiring BACKUP_ADMIN privilege and offering a less disruptive alternative to FTWRL, used by MySQL Enterprise Backup and Percona Xtrabackup.
This article surveys MySQL audit capabilities, explains the limitations of general and binary logs, introduces several open‑source audit plugins with installation and configuration details, and compares MariaDB, Percona, and McAfee audit plugins in terms of granularity, log format, and performance impact.
This article introduces Percona QAN, explains its three‑component architecture (QAN‑Agent, QAN‑API, QAN‑APP), describes the MySQL slow‑log format and key fields, and details the web UI metrics such as Load, Count, Latency, and additional diagnostic information for database performance analysis.
This article provides a comprehensive overview of InnoDB's buffer pool, detailing its role as a data cache, the underlying data structures such as instances, chunks, and blocks, the page lifecycle from allocation to flushing, and discusses limitations of the default page‑cleaner implementation along with Percona's enhancements.
This article explains how the auth_socket (MySQL) and unix_socket (MariaDB) plugins enable password‑less login by mapping operating‑system users to MySQL accounts, walks through installing and enabling the plugins on Debian, Ubuntu, MariaDB, and Percona Server, and demonstrates creating and using socket‑authenticated users.
This article analyzes the MySQL slow query log in Percona 5.7, explaining how timestamps, execution time, lock time, and various log fields are derived from the source code, and clarifies the meaning of each output component for accurate performance debugging.
This weekly digest highlights the August MySQL ranking surge, Percona XtraBackup 8.0.7 features, free Mycat diagnostic support, DBLE and DTLE weekly reports, and several in‑depth technical articles covering MySQL cloning, group replication, charset performance, ZooKeeper deployment, and InnoDB index construction.
This article analyses why a custom Prometheus exporter for Percona MySQL 5.7.23 caused new‑connection failures and query timeouts, reveals a mutex deadlock involving LOCK_global_system_variables, LOCK_log and LOCK_status, and shows that upgrading to MySQL 5.7.25‑28 resolves the issue.
This article explains how Percona Server 5.7 implements a thread‑pool model for MySQL, detailing the activation parameters, internal architecture, functional threads, timer mechanisms, and several performance optimizations such as priority scheduling and special handling for long‑running commands.
The discussion explores practical strategies for adding an index to a MySQL table containing tens of millions of rows without stopping service, covering intermediate tables, double‑write syncing, rename operations, traffic considerations, lock types, and tooling such as Percona.
This article summarizes a live Q&A where experts compare MySQL official, MariaDB, and Percona branches, discuss the pros and cons of each, and explore how MySQL DBAs can balance source‑code knowledge with operational expertise to advance their careers and influence architecture and business integration.