Jul 12, 2024 |
Insight for DBAs, MySQL, Percona Software
At Percona Managed Services, we manage Percona MySQL, Community MySQL, and MariaDB. Sometimes, we might need to enable audit logging and share the logs for client MySQL Community 8.0.x servers. There are several ways to enable audit logs. One is to use the MySQL Enterprise audit logging plugin (audit_log.so), but it only supports the MySQL […]
Mar 29, 2024 |
Insight for DBAs, MySQL
At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The automated restore process ran well until one day, we got the error below. 0. The error […]
Dec 12, 2023 |
Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make […]
Sep 15, 2023 |
Insight for DBAs, MariaDB, MySQL
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and position-based replication to GTID replication. In my lab, we have two test nodes; both servers will […]
Jun 15, 2023 |
Insight for DBAs, MySQL, Percona Software
Sometimes we might need to install/upgrade Percona Server for MySQL/MySQL 8 to a particular version in a test or production environment. The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is […]
Mar 13, 2023 |
Insight for DBAs, MySQL, Percona Software
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica. This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup. […]
Nov 14, 2022 |
Insight for DBAs, MySQL
At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning. We could get the LATEST DETECTED DEADLOCK from SHOW ENGINE INNODB STATUSG:
|
…. ------------------------ LATEST DETECTED DEADLOCK ------------------------ *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 163 page no 3 n bits 72 index GEN_CLUST_INDEX of table `deadlock_test`.`t` trx id 78507 lock_mode X waiting *** (2) TRANSACTION: TRANSACTION 78508, ACTIVE 155 sec starting index read mysql tables in use 1, locked 1 …. |
But how could we view all past deadlock information? We could enable innodb_print_all_deadlocks, and all deadlocks in InnoDB user transactions will be recorded […]