Planet MySQL

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a MySQL HeatWave inbound re...

https://blogs.oracle.com/mysql/post/creating-a-mysql-heatwave-replication-channel-with-the-oci-cli

The adaptive hash index help to improve performance of the already-fast B-tree lookups

https://planetscale.com/blog/the-mysql-adaptive-hash-index

When talking about storage performance, we often hear three terms that are important in describing storage performance. They are bandwidth latency I/O operations per second (IOPS) When you talk t...

https://blog.koehntopp.info/2024/04/21/mysql-latency-and-iops.html

Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don...

https://www.percona.com/blog/did-mydumper-like-triggers/

This is the second article in our blog series about MySQL NDB Cluster replication, it describes the basic concept and functional parts of a single-channel replication which is used for replicatin...

https://blogs.oracle.com/mysql/post/mysql-ndb-cluster-replication-singlechannel-replication

A key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL ...

https://blog.devart.com/mysql-foreign-key.html

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a MySQL HeatWave configurat...

https://blogs.oracle.com/mysql/post/creating-a-mysql-heatwave-configuration-with-the-oci-cli

When COMMIT is the slowest query, it means your storage is slow. Let’s look at an example.

https://hackmysql.com/post/when-commit-is-the-slowest-query/

Episode #60 of MySQL Shorts in now available!

https://blogs.oracle.com/mysql/post/mysql-shorts-episode-60-is-released

We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on...

https://www.percona.com/blog/a-guide-to-better-understanding-mysql-charset-levels/

MySQL Meetups EMEA in April

https://blogs.oracle.com/mysql/post/emea-mysql-meetups-in-april-2024

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a read replica of a MySQL H...

https://blogs.oracle.com/mysql/post/creating-a-mysql-heatwave-read-replica-with-the-oci-cli

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a backup of a MySQl HeatWav...

https://blogs.oracle.com/mysql/post/backing-up-and-restoring-a-mysql-heatwave-instance-with-the-oci-cli

OSC Japan 2023 recap

https://blogs.oracle.com/mysql/post/mysql-at-osc-open-source-conference-japan-2023-recap

Learn how to visualize the memory usage of a MySQL connection

https://planetscale.com/blog/profiling-memory-usage-in-mysql

Yes, this is a catchy title, but it is true, and it got you reading this post :-).  Another title could have been “Please load this mysql-dump: what could go wrong ?”.  As you ...

https://jfg-mysql.blogspot.com/2024/04/17-years-of-insecure-mysql-client.html

It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The I...

https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve a list of MySQL HeatWave ...

https://blogs.oracle.com/mysql/post/listing-and-updating-mysql-heatwave-instances-with-the-oci-cli

Join us at MySQL and HeatWave Summit 2024, on May 1, 2024 in Redwood Shores, California. Free, unperson event, open to all. Learn about Generative AI and Machine Learning. Get One-on-One Help and...

https://blogs.oracle.com/mysql/post/top-5-reasons-to-attend-mysql-and-heatwave-summit-2024

We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vi...

https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve reference data and create...

https://blogs.oracle.com/mysql/post/creating-a-mysql-heatwave-instance-with-the-oci-cli

My name is Arvind Murty, and from May to July of 2023, I worked on Vitess via an internship with PlanetScale. I was first introduced to Vitess when I was in high school as a potential open-source...

https://vitess.io/blog/2024-04-08-vitess-fuzzing-summer-2023-internship/

HWJP meetup Apr 2024

https://blogs.oracle.com/mysql/post/japan-special-mysql-meetup-on-april-11

Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested many colleagues to reproduce a problem they had with MyS...

https://jfg-mysql.blogspot.com/2024/04/dbdeployer-tutorial-on-mac.html

Learn more about basic single-channel replication setup as well as the high-end active-active circular or merge replication setups. In this series we will describe how it works both on high level...

https://blogs.oracle.com/mysql/post/introduction-to-mysql-ndb-cluster-replication

This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  W...

https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/

This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional ...

https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/

This blog was originally published in January 2023 and was updated in April 2024.Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple My...

https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to update some propertied of a backup of a MySQL HeatWave instance.

https://blogs.oracle.com/mysql/post/using-the-oracle-cloud-typescript-sdk-part-6-updating-a-mysql-heatwave-backup

The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL HeatWave ...

https://blogs.oracle.com/mysql/post/database-management-now-monitors-mysql-heatwave-clusters-and-lakehouse

ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching...

https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/

I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development class with MySQL 8. It’s a great book overall but Chapter 12 lacks a complete exercise. Here’s all that the author...

https://blog.mclaughlinsoftware.com/2024/04/01/learning-sql-exercise/

MySQL HeatWave Faster Point-in-time Recovery

https://blogs.oracle.com/mysql/post/mysql-heatwave-faster-pointintime-recovery

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.

https://planetscale.com/blog/identifying-and-profiling-problematic-mysql-queries

Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsist...

https://www.percona.com/blog/how-missing-primary-keys-break-your-galera-cluster/

MySQL is a free, open-source, relational database management platform powered by Oracle Cloud. This tutorial will show you how to install MySQL 8 on Ubuntu 22.04 server.

https://www.howtoforge.com/how-to-install-and-use-mysql-8-on-ubuntu-22-04/

Today, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data-driven applications. In this article, we will demonstra...

https://blog.devart.com/ssh-connection-to-mysql-in-digitalocean-droplet.html

Codership is please to announce a new release of Galera Manager. This brings the installer to version 1.13.0 (you can check this by typing: ./gm-installer version which will report gm-installer v...

https://galeracluster.com/2024/03/galera-manager-march-2024-release-now-includes-ui-improvements-and-a-ssh-console-tab/

Episode #59 of MySQL Shorts in now available!

https://blogs.oracle.com/mysql/post/mysql-shorts-ep-58-import-csv

Duplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they ha...

https://blog.devart.com/delete-duplicate-rows-in-mysql.html