- Home
- Tag: MySQL
Posts tagged MySQL
Tag: MySQL
Make way for the High Performance Parallel Dump & Load Utilities + How to use them

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More
MySQL Monitoring and Reporting Using the MySQL Shell

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “show” and “watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground and background threads as well. Overview “show” and “watch” are the MySQL shell commands, which can be executed using the Javascript (JS), Python (Py), and SQL interfaces. Both commands are providing the same information, but the difference is you can refresh the results when using the command “watch”. The ... Read More
MySQL Query Profiling Using Performance Schema

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema. The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow. On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling. Enabling the MySQL Performance Schema ... Read More
How To Speed Up Re-sync of Dropped Percona XtraDB Cluster Node
Feed: Planet MySQL; Author: Percona Community; Wayne Leutwyler | February 24, 2021 | Posted In: Advanced Level, MySQL The ProblemHELP, HELP! My Percona XtraDB Cluster version: 5.7.31-31. Single Node is stuck in a joined state.I recently had the privilege to help a client with a fascinating issue.NODE-B dropped out of the 3 node PXC cluster. It looked to be DISK IO that caused NODE-B to fall far behind and eventually be removed from the cluster. A restart of NODE-B allowed itto rejoin the cluster. NODE-B looked to have been down for about 4 hours. Once NODE-B was back as part of the ... Read More
Point-In-Time Recovery in Kubernetes Operator for Percona XtraDB Cluster – Architecture Decisions

Feed: Planet MySQL; Author: MySQL Performance Blog; Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, and in this blog post we are going to look into the technical details and decisions we made to implement this feature. Architecture Decisions Store Binary Logs on Object Storage MySQL uses binary logs to perform point-in-time recovery ... Read More
Upgrading from MariaDB 10.5 to MariaDB 10.6
Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.6 is still under active development, so details on this page will change frequently. How to Upgrade Before you upgrade, it would be best to take a backup of your database. This is always a good idea to do before an upgrade. We would recommend Mariabackup. The suggested upgrade procedure is: Modify the repository configuration, so the system's package manager installs MariaDB 10.6. For example, On Debian, Ubuntu, and other similar Linux distributions, see Updating the MariaDB APT repository to a New Major Release for more information. On RHEL, CentOS, Fedora, ... Read More
Avinash Vallarapu: Role of Foreign Data Wrappers in Migrations to PostgreSQL

Feed: Planet PostgreSQL. Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases. While it is great that there are several features available with Postgres by default, it may be challenging if there are no solutions to help with migrations to postgres. Fortunately, there are several contributions through extensions and Open source ... Read More
MySQL Recovery
Feed: Planet MySQL; Author: Olivier Dasini; If you are dealing with data, and you most probably are if you are reading this, one of your biggest fears would be not to be able to retrieve them. In a world where data actually surround us, it is critical to be able to retrieve them fast and with the best consistency. Thus, it is always a good idea to have high availability settings in place to avoid loosing your data. However, most of the times, we may wish or we may need to save the database and our data, and be a ... Read More
Online DDL in Vitess

Feed: Planet MySQL; Author: Vitess; Vitess introduces a new way to run schema migrations: non-blocking, asynchronous, scheduled online DDL. With online DDL Vitess simplifies the schema migration process by taking ownership of the operational overhead, and providing the user a simple, familiar interface: the standard ALTER TABLE statement.Let’s first give some background and explain why schema migrations are such an issue in the databases world, and then dive into implementation detailsThe relational model and the operational overhead The relational model is one of the longest surviving models in the software world, introduced decades ago and widely used until today. SQL ... Read More
Andreas ‘ads’ Scherbaum: Takayuki Tsunakawa
Feed: Planet PostgreSQL. Date: 22.02.2021 Tags: postgresql japan contributor fujitsu video-game virtual-reality visually-impaired Category: Interviews Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I’m a Japanese man who was born and lives in Japan, near Tokyo. I am visually impaired by nature, and I have only enough eyesight to feel the ... Read More
Recent Comments