by Mani Paluru | Dec 13, 2023 | Insight for DBAs, MySQL
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing... by Mani Paluru | Sep 26, 2023 | Insight for DBAs, MySQL
As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout our careers, most of us have encountered situations where the absence of a primary key has led to operational challenges. Primary keys play... by Mani Paluru | Apr 4, 2023 | Insight for DBAs, MySQL
In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. What is the user attribute? A user attribute is a JSON object made up of one or more key-value pairs, and it is set while creating the user with CREATE USER and by including... by Mani Paluru | Dec 8, 2022 | Insight for DBAs, MySQL
In this blog, I’m going to discuss how to easily skip the replication errors in GTID (Global Transaction Identifier)-based replication.In the MySQL world, if replication is broken we all use the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; to skip the replication... by Mani Paluru | Nov 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The...