Fri, 16 Feb 2024 23:10:50 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/exploring-mysql-8-priority-based-error-log-filtering/ https://www.percona.com/blog/exploring-mysql-8-priority-based-error-log-filtering/#respond Wed, 13 Dec 2023 15:02:12 +0000 https://www.percona.com/blog/?p=92400 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 administrators to focus on the most critical issues. By assigning priorities to different error types, administrators […]]]> https://www.percona.com/blog/exploring-mysql-8-priority-based-error-log-filtering/feed/ 0 92400 https://www.percona.com/blog/explore-the-new-feature-of-mysql-to-restrict-users-from-creating-a-table-without-a-primary-key/ https://www.percona.com/blog/explore-the-new-feature-of-mysql-to-restrict-users-from-creating-a-table-without-a-primary-key/#respond Tue, 26 Sep 2023 12:04:46 +0000 https://www.percona.com/blog/?p=90951 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 an indispensable role in sound database design by uniquely identifying individual rows […]]]> https://www.percona.com/blog/explore-the-new-feature-of-mysql-to-restrict-users-from-creating-a-table-without-a-primary-key/feed/ 0 90951 https://www.percona.com/blog/creating-and-using-mysql-8-user-attributes/ https://www.percona.com/blog/creating-and-using-mysql-8-user-attributes/#respond Tue, 04 Apr 2023 12:19:17 +0000 https://www.percona.com/blog/?p=86685 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 ATTRIBUTE ‘json_object’. json_object must be a […]]]> https://www.percona.com/blog/creating-and-using-mysql-8-user-attributes/feed/ 0 86685 https://www.percona.com/blog/how-to-skip-replication-errors-in-gtid-based-replication/ https://www.percona.com/blog/how-to-skip-replication-errors-in-gtid-based-replication/#comments Thu, 08 Dec 2022 15:14:24 +0000 https://www.percona.com/blog/?p=84083 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 error. It always works if it’s a traditional binlogs events-based replication and is helpful to quickly […]]]> https://www.percona.com/blog/how-to-skip-replication-errors-in-gtid-based-replication/feed/ 3 84083 https://www.percona.com/blog/various-backup-compression-methods-using-mysqlpump/ https://www.percona.com/blog/various-backup-compression-methods-using-mysqlpump/#comments Fri, 06 Nov 2020 14:49:20 +0000 https://www.percona.com/blog/?p=72542 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 mysqlpump Utility), and in this blog, I am going to explore the […]]]> https://www.percona.com/blog/various-backup-compression-methods-using-mysqlpump/feed/ 2 72542