Showing entries 1 to 10 of 22125
10 Older Entries »
Displaying posts with tag: MySQL (reset)
How to Check MySQL Version

MySQL is an extremely popular open-source RDMS, and it is widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary.

The post How to Check MySQL Version appeared first on Devart Blog.

How to Restore a MySQL Database with Command Line or Restore Tools

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.

The post How to Restore a MySQL Database with Command Line or Restore Tools appeared first on Devart Blog.

How to Enable, Configure, and Use MySQL Query Logging

In this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage.

The post How to Enable, Configure, and Use MySQL Query Logging appeared first on Devart Blog.

How Network Splits/Partitions Impact Group Replication in MySQL

In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for some insight. Topology: [crayon-670983c319441444846427/] Scenario 1: One of the GR nodes […]

Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1

There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.

The post Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 appeared first on Devart Blog.

Understanding MySQL Indexes: Types, Benefits, and Best Practices

When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL. Without an index, MySQL must perform a full table scan, […]

Troubleshooting MySQL: Encryption can’t find Master Key

If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…

The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable.

MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?

There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with some important news from Marco Tusa. In one of his blog posts, Marco strongly advised against upgrading […]

Introducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum Compatibility and Compliance

Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for MySQL. These builds have been rigorously tested and are available as rpm packages, ensuring seamless integration with your […]

All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented

The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties. Unlike sequential integer identifiers, which […]

Showing entries 1 to 10 of 22125
10 Older Entries »