Tag: MySQL

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

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

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

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

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

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

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

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

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

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