Tagged articles
Percona
44 articles · Page 1 of 1
MySQL 9.7 LTS brings enterprise-grade features like replication observability, hypergraph optimizer, PGO, and JSON Duality Views DML to the community edition, delivering up to 14% performance gains via PGO, but lacks vector similarity search functions for RAG workloads.
Hypergraph optimizerJSON Duality ViewsLTS
0 likes · 14 min read

The article examines recent rumors that Oracle has stopped developing MySQL, explains why GitHub commit activity can be misleading, and clarifies MySQL's actual private development workflow, showing that recent releases prove the database is still actively maintained.
Database DevelopmentGitHubPercona
0 likes · 5 min read

This guide explains how to restore lost MySQL data after accidental DELETE operations by using binary log replay, logical and physical backups, third‑party recovery utilities, and preventive measures such as proper binlog configuration, backup strategies, and permission controls.
MySQLPerconaSQL
0 likes · 21 min read

With MySQL 8.0 support ending on April 30, 2026, users must migrate within six months to avoid security risks, and can choose upgrading to the latest MySQL, switching to Percona Server, or moving to alternatives like MariaDB or PostgreSQL, each with its own pros and cons.
Database MigrationEOLMariaDB
0 likes · 7 min read

MySQL 8.0 will lose Oracle support on April 30, 2026, ending security patches, bug fixes, and official assistance, so organizations must choose between upgrading to a newer MySQL version, switching to Percona Server, or migrating to alternative databases like MariaDB or PostgreSQL.
DBaaSDatabase MigrationMariaDB
0 likes · 5 min read

This guide walks through the background, environment setup, installation steps, configuration parameters, and testing results for using the Percona audit logging plugin with MySQL 8.0, demonstrating compatibility, key settings, and how to filter logged events.
Audit PluginConfigurationDatabase Security
0 likes · 12 min read

Learn how to protect sensitive information in MySQL by installing the open‑source Percona data_masking plugin, verifying its status, and using built‑in and custom masking functions for IDs, phone numbers, emails, names, amounts, and addresses, with step‑by‑step SQL examples.
MySQLPerconaSQL
0 likes · 7 min read


ITPUBJul 24, 2024 · Databases
A fatal bug (ID #36808732) in MySQL 8.0.38, 8.4.1 and 9.0.0 causes the server to crash on restart when thousands of tables exist, prompting Percona to warn users not to upgrade until patched versions 8.0.39, 8.4.2 and 9.0.1 are released.
MySQLPerconaUpgrade
0 likes · 5 min read


21CTOJul 17, 2024 · Databases
The article examines Oracle's release of MySQL 9.0, highlighting developer disappointment, serious bugs warned by Percona, the company's shift toward the proprietary HeatWave analytics engine, and the broader implications for the open‑source MySQL community.
Database BugsHeatWaveMySQL
0 likes · 6 min read

Percona’s analysis of MySQL version adoption reveals a slow migration to 8.x, prompting extensive performance tests that compare default and tuned configurations of MySQL 5.7, 8.0.36, 8.4, Percona Server, and MariaDB using sysbench and TPC‑C benchmarks, with detailed results showing consistent performance regressions in newer releases.
MySQLPerconaTPC-C
0 likes · 11 min read

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.
DB-EnginesHeatWaveMySQL
0 likes · 7 min read

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.
PerconaToolsperformance
0 likes · 10 min read

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.
ANALYZE TABLEDatabase PerformanceMariaDB
0 likes · 8 min read


ITPUBJul 8, 2023 · Databases
This article explains why MySQL reports error 1040 "Too many connections", shows how Percona Server can reserve an admin port to keep DBA access, and details MySQL 8.0.14's built‑in admin connection feature with configuration steps, commands, and a performance experiment.
Admin ConnectionMySQLMySQL 8.0
0 likes · 7 min read

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.
Logical BackupMongoDBPBM
0 likes · 16 min read

This guide explains why regular MySQL health checks are crucial and introduces four open‑source performance tools—mysqltuner.pl, tuning-primer.sh, pt‑variable‑advisor, and pt‑query‑digest—detailing how to download, run, and interpret their reports to optimize configuration, detect bottlenecks, and improve security.
MySQLPerconaoptimization
0 likes · 9 min read

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.
ClusterHigh AvailabilityMySQL
0 likes · 8 min read

This guide explains the Percona XtraDB Cluster (PXC) architecture, its advantages and limitations, and provides step‑by‑step commands for removing MariaDB, opening firewall ports, disabling SELinux, downloading packages, configuring MySQL, bootstrapping the first node, adding additional nodes, and verifying the cluster status.
ClusterHigh AvailabilityMySQL
0 likes · 8 min read

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.
Connection HandlingMySQLPercona
0 likes · 27 min read

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.
PerconaToolsdiagnostics
0 likes · 8 min read

This guide walks through selecting a clustering strategy, installing Percona XtraDB Cluster (PXC) with Docker, configuring a five‑node cluster, adding HAProxy for load balancing, testing access, and handling node failures to achieve strong consistency and high availability for critical data.
ClusterDockerHAProxy
0 likes · 14 min read

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.
ClusterDockerHAProxy
0 likes · 13 min read

This guide introduces four powerful MySQL performance‑tuning utilities—MySQLTuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—detailing their installation, command‑line usage, and how to interpret the generated reports to optimize database configuration and query efficiency.
MySQLPerconaTools
0 likes · 9 min read

A developer encountered a duplicate‑key error caused by an unexpected primary‑key update that overflowed the signed INT limit, exposing a hidden MySQL auto‑increment bug that persisted across normal inserts until a later DDL operation triggered failures, a problem present in Percona 5.6/5.7 but fixed in MySQL 8.0.
MySQLPerconaPrimary Key
0 likes · 5 min read

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.
Foreign KeysMySQLPercona
0 likes · 3 min read

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.
Database SecurityMariaDBMcAfee
0 likes · 10 min read

This guide explains how to install Percona XtraBackup 2.4, perform hot full backups of MySQL 5.7 databases, compress and transfer them, and configure master‑slave replication using innobackupex and standard MySQL commands.
MySQLPerconaReplication
0 likes · 6 min read

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.
Database InternalsInnoDBPercona
0 likes · 16 min read

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.
MySQLPasswordlessPercona
0 likes · 8 min read

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.
Lock TimeMySQLPercona
0 likes · 19 min read

This article reviews MySQL replication concepts, compares asynchronous, semi‑synchronous, group, and Percona XtraDB Cluster solutions, explains row‑based versus statement‑based replication, and clears up common misconceptions about replication, clustering, backup, and load balancing.
Group ReplicationMySQLPercona
0 likes · 9 min read

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.
DBLEDTLEInnoDB
0 likes · 5 min read

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.
MutexMySQLPercona
0 likes · 10 min read


21CTOMar 22, 2019 · Databases
This article examines why modern businesses rely on databases, explains the concept and advantages of open‑source software, and provides a detailed comparison of three popular open‑source databases—PostgreSQL, MariaDB, and Percona—highlighting their strengths, weaknesses, and ideal use cases.
MariaDBPerconaPostgreSQL
0 likes · 8 min read

This guide walks through the background, installation, configuration, and usage of the open‑source Slowquery tool—integrating Percona pt‑query‑digest, Soar, and email alerts—to automate MySQL slow‑query monitoring and performance recommendations.
MySQLPHPPercona
0 likes · 9 min read

This guide explains why the community edition of MongoDB lacks native hot backup, how Percona MongoDB adds online backup support, the underlying backup and restore principles, and provides a step‑by‑step PHP script with environment setup, configuration, execution, and scheduling instructions.
HotBackupMongoDBPHP
0 likes · 7 min read

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.
ConcurrencyDatabase PerformanceMySQL
0 likes · 13 min read


21CTOJul 26, 2017 · Operations
This guide walks you through installing Ubuntu, Docker, and the Percona Monitoring and Management (PMM) server, configuring a PMM client, and connecting it to MySQL to enable real‑time performance metrics and slow‑query analysis.
Database PerformanceDockerMySQL
0 likes · 7 min read

This guide outlines nine practical MySQL recovery methods—including full backup with binlog, business‑logic rollback, flashback tools, innodb_force_recovery, tablespace discard/import, manual ibd editing, extundelete, and Percona's recovery utility—to help DBAs restore data after accidental deletions, corruption, or hardware failures.
InnoDBMySQLPercona
0 likes · 12 min read

This article details a performance comparison of MySQL 5.6.19 and Percona 5.6.25 with and without InnoDB deadlock detection, using sysbench to simulate flash‑sale stock‑decrement scenarios, and shows how turning off deadlock checks and enabling thread‑pool can boost throughput by over a hundred times.
MySQLPerconadeadlock detection
0 likes · 11 min read

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.
Database MigrationIndexingLarge Tables
0 likes · 8 min read
![[Interview Question] How to Add an Index to a Tens‑Millions‑Row Table Without Downtime](https://wsrv.nl/?url=http%3A%2F%2Fmmbiz.qpic.cn%2Fmmbiz%2FibBPzzwQ3qZVAejXYG4PIftxa0xFibIfgicTjNtoe0Hegy7Icr4hj7VPkiaOCAOU3v5wkpv6KSiaJFjsUf0U5kFrU3Q%2F0%3Fwx_fmt%3Djpeg)
This guide compares Percona Server, MariaDB, and MySQL, outlines practical MySQL performance tuning steps across hardware, storage, filesystem, and server parameters, and presents several high‑availability architectures such as master‑slave replication, MMM/MHA, Heartbeat/SAN, and Heartbeat/DRBD with real‑world deployment examples.
High AvailabilityMariaDBMySQL
0 likes · 9 min read

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.
DBA CareerMariaDBMySQL
0 likes · 10 min read

The article examines the impact of Oracle's acquisition of MySQL, introduces Percona XtraDB and Percona Server, outlines MariaDB's origins and compatibility, compares their storage engines, performance, and version histories, and provides resources for further comparison of these MySQL alternatives.
MariaDBMySQLPercona
0 likes · 7 min read
