Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Monday, 30. January 2023

OpenLampTech issue #63 – Substack Repost (from Digital Owl's Prose)

pWith so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading OpenLampTech! In OpenLampTech issue #63, we are looking at great content […]/p pThe post OpenLampTech issue #63 – Substack [...]

Using Oracle APEX with MySQL Heatwave Service for Data Visualisation and Reporting (from MySQL Solutions - On Premises & Cloud)

p /pUsing ORACLE APEX to Build and Visualize and Analyse MySQL Databasep Main objective of this blog is to connect MDS with APEX tool and visualize and get insights of MySQL data with low code solution called Oracle APEX. /ppBelow is the glimpse of topic to be covered in this blog /pp1. What is all about Oracle Apex /pp2. What are benefit of using Oracle Apex /pp3. Ins [...]

Sunday, 29. January 2023

Your Galera Cluster Production Questions, Answered (from Galera Blog)

One of the unpublished benefits of our training courses is that we hold an office hours session, usually one to two weeks after the training is complete, so that you can ask questions and receive answers. As always, we receive interesting questions, and this time we’ve decided to publish a selection of answers. You can […] [...]

Friday, 27. January 2023

Announcing MySQL Shell 8.0.32 (from The Oracle MySQL Blog)

Announcing MySQL Shell 8.0.32 [...]

Common MySQL errors and how to fix them (from PlanetScale Blog)

An overview of some common MySQL error codes you may run into, what they mean, and how to solve them.pRead the full story/p [...]

Thursday, 26. January 2023

Why You Need To Keep Track of Bugs - Percona Database Performance Blog (from Percona Database Blog)

♦A recent bug that appeared in MySQL 8.0.32 is a prime example of how a minor bug could have a significant impact on your life and company. [...]

MySQL 8.0.32: thank you for the contributions (from The Oracle MySQL Blog)

We released MySQL 8.0.32 and we would like to thanks all those contributing to MySQL: thank you ! [...]

MySQL 8.0.32: thank you for the contributions (from lefred's blog)

The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, Luke Weber, Vilnis Termanis, Naoki Someya, Maxim Masiu [...]

Announcing MySQL Operator for Kubernetes 8.0.32-2.0.8 (from The Oracle MySQL Blog)

Announcing MySQL Operator for Kubernetes 8.0.32-2.0.8 [...]

Wednesday, 25. January 2023

Sysbench 1.1.0 for Oracle Linux 9 (from lefred's blog)

Recently Jack asked me for a Sysbench package for OL9. In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system. Sysbench’s binary is linked with libmysqlclient.so.21 and libssl.so.3. Here are the two files, one for x86_64 and one for aarch64 (ARM): Enjoy MySQL and happy benchmark ! [...]

New Galera Manager installation videos for on premises and Amazon EC2 (from Galera Blog)

We have produced two new step-by-step videos for installing Galera Clusters either on premise and at Amazon EC2 environments. The videos can be replayed from links below. A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager A step-by-step video on how to install Galera Cluster in an […] [...]

Tungsten Cluster: How Does Failover Work? Part 1 of 3 (from Continuent Blog)

Did you ever wonder just what the Tungsten Manager is thinking when it does an automatic failover or a manual switch in a cluster? What factors are taken into account by the Manager when it picks a replica to fail over to? This blog post will detail the steps the Manager takes to perform a switch or failover. We will cover both the process and some possible reasons why that process might not comple [...]

Identify Active Databases and Users in MySQL - Percona Database Performance Blog (from Percona Database Blog)

♦Easy and quick ways to identify active databases and users in MySQL. [...]

5 Websites To Learn More SQL – Substack Repost (from Digital Owl's Prose)

pSQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too… Read the article: 5 Websites To Learn More SQL Support the OpenLampTech publication with your free subscription. Thank you!/p pThe post 5 Websites To Learn More SQL – Substack Repost appeared first on Digital Owl's Prose [...]

New MySQL HeatWave capabilities released in 8.0.32 (from The Oracle MySQL Blog)

New MySQL HeatWave capabilities released in 8.0.32 [...]

Tuesday, 24. January 2023

Announcing MySQL Server 8.0.32 (from The Oracle MySQL Blog)

Announcing MySQL Server 8.0.32 [...]

MariaDB Java Connector 3.1.2 and 2.7.8 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.1.2 and 2.7.8 GA releases. Download Now These … Continued [...]

Planet for the MySQL Community Graduating from Beta (from J-F Gagné's MySQL Blog)

In May 2020, I published a Planet for the MySQL Community Pluto Beta.  I was satisfied with the result and was considering it done, but I did not invest the time to promote it to release (a non-beta site was running for a few months without being advertised).  I finally came to it, and today I am happy to deprecate the beta and announce the release of Planet for the MySQL Community.  In this post [...]

Binding your application to the database in the Kubernetes cluster (from Percona Community Blog)

♦dbaas-operator is Yet Another DBaaS Kubernetes Operator (need to suggest yadbko as a name) that tries to simplify and unify Database Cluster deployments by building a higher abstraction layer on top of Percona Kubernetes Operators. So it becomes much easier to deploy the DB cluster with dbaas-operator and PMM DBaaS on top of it. But another part of the picture is applications and their workloads t [...]

Monday, 23. January 2023

The insert benchmark on ARM and x86 cloud servers (from Small Datum)

pI used the insert benchmark to compare ARM and x86 servers on AWS. For ARM I used c7g and for x86 I used c6i. The goal was to compare ARM vs x86 on similar hardware (OS, vcpu, RAM and EBS setups were the same). /ppWhile I am not trying to start a benchmarketing battle for c7g vs c6i or Postgres vs MySQL, I suppose that might happen. My goal in doing comparisons like this is to find things tha [...]

Now Available: Tungsten Dashboard v1.0.12 Release (from Continuent Blog)

We are pleased to announce that Tungsten Dashboard v1.0.12 is now available. Tungsten Dashboard is a web-based UI for monitoring and managing Tungsten Clustering deployments of MySQL databases, freely included for Tungsten Clustering customers. We provide Tungsten Dashboard in addition to our command-line user interfaces for easy visual monitoring and management of Tungsten Clusters. Users are able [...]

Working of MySQL Replication Filters When Using Statement-based and Row-based Replication - Percona Database Performance Blog (from Percona Database Blog)

♦Explaining how the MySQL replication filter may increase the complexity of your DBA operations, with examples. [...]

[BUG] Stopping Purge/Resuming Purge in Error Logs After Upgrade to MySQL 5.7.40 - Percona Database Performance Blog (from Percona Database Blog)

♦Some clients report that whenever they trigger a truncate on any table in MySQL 5.7.40, the function is stopping the purge and then resuming it once it has found it stopped. [...]

Substring in MySQL – Syntax and Examples (from Devart MySQL Tool Blog)

pIn this article, we are going to talk about the MySQL SUBSTRING() function with its variations. Here, you will find a detailed guide with the basic syntax and examples of how to use this function. Moreover, we will demonstrate the benefits of MySQL coding in a handy IDE – dbForge Studio for MySQL that will […]/p pThe post Substring in MySQL – Syntax and Examples appeared first on [...]

Friday, 20. January 2023

What should be monitored on a busy Database/MysQL server? (from Geeks Worldwide)

On a busy MySQL server, some key metrics that should be actively monitored include: - Geeks Worldwide [...]

preFOSDEM MySQL Days 2023 – the Agenda (from The Oracle MySQL Blog)

Just before FOSDEM, the MySQL Team is organizing a 2 days conferences for and with the MySQL Community. Here is the agenda. [...]

Help! I Am Out of Disk Space! - Percona Database Performance Blog (from Percona Database Blog)

♦Leveraging the flexibility of Percona Operator for MySQL to fix an out-of-disk-space issue. [...]

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale? (from Continuent Blog)

pPart of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. Tungsten Connector has three main modes, and depending on the type of operations you are performing (such as if you need read-write splitting), we help you choose which mode is best. Hence the question, "How can I tell which Tungsten Connector mode I am using: Bridge, Proxy [...]

Where you can find MySQL in January-May 2023 (from The Oracle MySQL Blog)

List of conferences with MySQL during January-May 2023 [...]

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more (from Vettabase)

In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I’m a bit late because it was released last November, and versions 10.11 and 11.0 have been announced since then… All that is correct, but 10.10 is the latest stable version. My usual friendly reminder: […] [...]

Introducing Chat2Query: An Innovative AI-Powered SQL Generator for Faster Insights (from TiDB and TiKV Blog)

pWe are excited to introduce Chat2Query, a revolutionary natural language query generator powered by OpenAI's GPT3, the technology behind ChatGPT, and TiDB, the distributed SQL database. /p pThe post Introducing Chat2Query: An Innovative AI-Powered SQL Generator for Faster Insights appeared first on PingCAP./p [...]

Thursday, 19. January 2023

Recently a Continuent Customer Asked: Part 3 (from Continuent Blog)

In this blog, part 3 of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the question: "Why does the tprovision command fail with error “Can’t connect to local MySQL server through socket” when using the xtrabackup method?Tags: MySQLMariaDBxtrabackuptprovision [...]

Help! I am out of disk space! (from TusaCentral - MySQL Blogs)

pHow we could  fix a nasty out of space issue leveraging the flexibility of Percona MySQL operator (PMO)  ♦/p pWhen planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate for Data on disk./p pThis is even more cumbersome when working on bare metal. Given it is definitely more difficult to add space when using this ki [...]

A Quick Peek at MySQL 8.0.32 - Percona Database Performance Blog (from Percona Database Blog)

♦Recently, Oracle released MySQL 8.0.32 and there are some things of note. Dave Stokes takes a look. [...]

Why MySQL Could Be Slow With Large Tables - Percona Database Performance Blog (from Percona Database Blog)

♦Reviewing key topics to consider for managing large tables more efficiently in MySQL. [...]

FromDual Ops Center 1.2.0 for MariaDB, MySQL and compatible databases has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 1.2.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases./p pThe FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes DBA and Admins [...]

On Writing to the MySQL Error Log (from Laurynas Biveinis' blog)

pIf you develop a 3rd party MySQL plugin, it might take a while for you to figure out how to make your plugin write to the server error log in an official supported way. Let's take a look. /p pFirst things first: you don't want to patch the core server and ideally you'd develop and distribute the plugin only. I don't think there exists a single plugin that pulls this off today, but that's the ideal [...]

Wednesday, 18. January 2023

Compiling MySQL 5.6 & 5.7 on Ubuntu 22.04 (from Small Datum)

One of my hobbies is testing open source DBMS for CPU regressions and for that I want to compare perf between old and new versions of the DBMS. Depending on the DBMS it can be a challenge to build the old DBMS with the current (modern) compiler toolchain. brUsing open source frequently means compiling from source and compiling from source eventually means debugging a failed build. Alas, the pr [...]

Releasing ProxySQL v2.4.7! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.7 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL [...]/p pThe post Releasing ProxySQL v2.4.7! appeared first on ProxySQL./p [...]

RDS/Aurora IAM DB access with MySQL Shell (from Jay Janssen's MySQL and Infrastructure)

pAs probably with anyone experimenting with Innodb Cluster and MySQL 8, I’ve spent a good deal of time with MySQL Shell. I think for some old-timers MySQL Shell can initially come across as odd or difficult to understand. Partially, I think it is because Shell offers a deluge of new features from:/p ul limanaging local sandbox mysql instances/li li3 different shell languages (SQL, Javascript [...]

Announcing TiDB 6.5 LTS Release – Major Leap into 2023 with a Mature Enterprise Database (from TiDB and TiKV Blog)

pWe are proud to announce the TiDB 6.5 Long-Term Support (LTS) release with a host of new features, enhancements, and fixes in kernel capabilities, ease of use, and developer experience. /p pThe post Announcing TiDB 6.5 LTS Release – Major Leap into 2023 with a Mature Enterprise Database appeared first on PingCAP./p [...]

What is the N+1 query problem and how to solve it? (from PlanetScale Blog)

Learn what the N+1 queries problem is by working through an example N+1 query, updating it to a JOIN statement, and going over how to identify them in the future.pRead the full story/p [...]

Tuesday, 17. January 2023

clang, gcc & compiler flags vs the insert benchmark & ARM (from Small Datum)

pI have a large set of results from the Insert Benchmark run on AWS servers that use ARM CPUs (c7g). But before sharing them I wanted to make sure my builds (Postgres and MySQL compiled from source) weren't ruined by using the wrong compiler flags. And by wrong I mean that by default you get a build optimized for an older version of the ARM architecture. The flags that I tried optimize it for somet [...]

Using Oracle Cloud Infrastructure GoldenGate with MySQL Databases (from The Oracle MySQL Blog)

OCI GoldenGate is a fully managed service providing a real-time data mesh platform, which uses replication to keep data highly available and enable real-time analysis. OCI GoldenGate supports several sources and targets, including MySQL and OCI MySQL HeatWave Database Service. In this article, we will find out how the MySQL deployment and connection types make it easier than ever to integrate with [...]

How MariaDB Xpand Accelerates SaaSification (from MariaDB Corporation Blog)

SaaSification is not only a tech thing. Entire industries are moving to more specialized services provided as applications and APIs. … Continued [...]

preFOSDEM MySQL Days 2023 – the Agenda (from lefred's blog)

As you know, before FOSDEM, the MySQL Community Team organizes a 2 days conference in Brussels. During these preFOSDEM MySQL Days, attendees will have the opportunity to learn more about MySQL from Oracle’s MySQL teams and selected professionals from the MySQL community. Here is the agenda: Thursday 2nd February Registration starts at 09:00 AM. Start End Title Speaker Company 09:30 AM 10:00 AM Welc [...]

Global WordPress High Availability Using Tungsten Clustering, Part 1 (from Continuent Blog)

Running highly-available WordPress is especially challenging, because WordPress is not by nature Active/Active-aware, and will refuse to run in an environment where database writes are active-active. In this blog post Part 1, we will explore the design considerations for making WordPress highly-available at the database layer. We also cover some other WordPress HA architecture needs, like the need [...]

Fast query performance with MySQL Hypergraph Optimizer for HeatWave (from The Oracle MySQL Blog)

Fast query performance with MySQL Hypergraph Optimizer for HeatWave [...]

Percona Monitoring and Management 2.34 preview release (from Percona Community Blog)

♦Percona Monitoring and Management 2.34 preview release Hello folks! Percona Monitoring and Management (PMM) 2.34 is now available as a preview release. We encourage you to try this PMM preview release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming week. You can find [...]

Monday, 16. January 2023

Gcov in MariaDB (from MariaDB Foundation Blog)

pGcov is a coverage testing tool, used to create better programs. It can show which parts of the codebase are untested. Gcov is located in the same package as gcc. … /p pContinue reading \"Gcov in MariaDB\"/p pThe post Gcov in MariaDB appeared first on MariaDB.org./p [...]

OpenLampTech issue #61 – Substack Repost (from Digital Owl's Prose)

pOpenLampTech is your media source for original and curated MySQL, PHP, and LAMP stack-related content. This week’s newsletter has many many great reads. Thank you for reading and making the publication a success. Please share with others! This week in OpenLampTech issue #61, we have articles covering: Want to support OpenLampTech? Great! Your free subscription […]/p pThe post OpenLampT [...]

MySQL HeatWave Report – December 2022 update (from MySQL expert Diary)

p- Read Replicas with Load Balancerbr - Replication Filtersbr - Replication Sources Without GTIDsbr - MySQL HeatWave for AWS/p pThis presentation is just a summary of new features in MySQL HeatWave./p pFor a more thorough and exhaustive view please read the following: /p p - docs.oracle.com/en-us/iaas/releasenotes/services/mysql-database//p p - dev.mysql.com/doc/relnotes/heatwave/en//p The post [...]

Setting Up PMM For Monitoring Your Databases on Windows (from Percona Community Blog)

♦Before deploying Percona Monitoring and Management (PMM) in production, you might want to test it or set up a development instance locally. Since many developers and DBAs have Windows desktops, I wanted to demonstrate how to set up PMM on Windows for an easy test environment. In this post, I’ll walk you through setting up PMM with Docker and WSL. If you’re a Linux user, check the blog post I wrote [...]

Friday, 13. January 2023

pt-online-schema-change resulted in missing MySQL triggers ? (from Mydbops Blog)

♦Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the –preserve-triggers option … [...]

Tungsten Cluster: Command Line Superpowers Using cctrl (from Continuent Blog)

The purpose of the cctrl command is to provide easy access to the Tungsten Manager layer, which in turn controls the entire cluster. In this post we will explore the cctrl> service command and the power it provides to the admin.Tags: MySQLMariaDBcctrlCLI superpowers [...]

Updating SQL_MODE (from MacLochlainns Weblog)

This is an update for MySQL 8 Stored PSM to add the ONLY_FULL_GROUP_BY mode to the global SQL_MODE variable when it’s not set during a session. Here’s the code: /* Drop procedure conditionally on whether it exists already. */ DROP PROCEDURE IF EXISTS set_full_group_by; /* Reset delimter to allow semicolons to terminate statements. */ DELIMITER […] [...]

GROUP BY Quirk (from MacLochlainns Weblog)

It’s always interesting to see how others teach SQL courses. It can be revealing as to whether they understand SQL or only understand a dialect of SQL. In this case, one of my old students was taking a graduate course in SQL and the teacher was using MySQL. The teacher made an issue of using […] [...]

Thursday, 12. January 2023

Releasing ProxySQL v2.4.6! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.6 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL [...]/p pThe post Releasing ProxySQL v2.4.6! appeared first on ProxySQL./p [...]

MySQL HeatWave Database Service inbound replication channel troubleshooting guide (from The Oracle MySQL Blog)

Follow this guide to troubleshoot Inboud Replication Channel to OCI MySQL HeatWave Database Service if replication is not running [...]

MariaDB Non-Code Contributions by Intel (from MariaDB Foundation Blog)

pI’ve mentioned in past blog posts that not every contribution is a code contribution. There are many possible contributions that are valuable, including testing, bug reports, helping the community, etc. … /p pContinue reading \"MariaDB Non-Code Contributions by Intel\"/p pThe post MariaDB Non-Code Contributions by Intel appeared first on MariaDB.org./p [...]

Functional Indexes in MySQL (from The Oracle MySQL Blog)

First introduced to MySQL in version 8.013, functional indexes give us the ability to create indexes based on expressions rather than the values of data in a database column. In this post we discuss how to create functional indexes as well as some limitations and implications with their use. [...]

Wednesday, 11. January 2023

MariaDB Java Connector 3.1.1 and 3.0.10 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.1.1 and 3.0.10 GA releases. Download Now These … Continued [...]

Insert benchmark on an 8-core AMD server (from Small Datum)

pI ran the insert benchmark on a Beelink SER 4700u that has 8 AMD cores, 16G RAM and NVMe SSD. I ran the test using 1, 2, 3 and 4 clients (threads) for MySQL (MyRocks, InnoDB) and Postgres. /pptl;dr/pp/pulliMySQL has CPU regressions from 5.6 to 8.0 that hurt performance/liliPostgres does not suffer from such CPU regressions/liliPostgres wasn't able to sustain the target insert rate (4000/s) fo [...]

Support’s notes from the field (from PlanetScale Blog)

A quick glimpse on Support at PlanetScale and the issues we see the most often.pRead the full story/p [...]

Tuesday, 10. January 2023

MySQL Connection Control (from The Oracle MySQL Blog)

What is MySQL Connection Control and how to use it. [...]

The flagship feature in the new LTS version RonDB 22.10.0 (from Mikael Ronstrom)

p In RonDB 22.10.0 we added a new major feature to RonDB. This feature means that variable sized disk columns in RonDB are stored in variable sized rows instead of using fixed size rows./ppThe history of disk data in RonDB starts already in 2004 when the NDB team at Ericsson had been acquired by MySQL AB. NDB Cluster was originally designed as an in-memory DBMS. The reason for this was based o [...]

Solving N+1’s with Rails `exists?` queries (from PlanetScale Blog)

Learn how to solve your Rails applications N+1’s caused by `exists?` queries.pRead the full story/p [...]

Summary of RonDB 21.04.9 changes (from Mikael Ronstrom)

p RonDB 21.04 main use case is being the base of the data management platform in Hopsworks. As such every now and then some new requirements on RonDB emerges. But obviously the most important feature of development of RonDB 21.04 is on stability./ppHopsworks provides a free Serverless use case to try out the Hopsworks platform. Check it out on app.hopsworks.ai. Each user gets their own databas [...]

Recently a Continuent Customer Asked: Part 2 (from Continuent Blog)

In this post we discussed the tprovision command and why it is always best to use a Replica node, not the Primary node, as the source for provisioning another Replica node.Tags: MySQLMariaDBtprovisionbackuprestore [...]

Elevate Your Percona Live Experience by Climbing MT. Elbert - Percona Database Performance Blog (from Percona Database Blog)

♦Join Peter Zaitsev right after Percona Live 2023 to climb Mt Elbert, the highest mountain in Colorado! [...]

Indexing JSON Data in MySQL (from The Oracle MySQL Blog)

Developers have been storing JSON data in MySQL databases since before the JSON data type existed. With the introduction of functional indexes, developers can now create indexes based on values in data stored in a column with the JSON data type. [...]

2022, a Year of Success and Accomplishment for PingCAP (from TiDB and TiKV Blog)

pTogether, our team accomplished a lot in 2022. We made many product innovations, offered better user and developer experiences, received recognition from various stakeholders, grew our user base significantly, and expanded our global presence with a growing team around the world. /p pThe post 2022, a Year of Success and Accomplishment for PingCAP appeared first on PingCAP./p [...]

Monday, 09. January 2023

RonDB News (from Mikael Ronstrom)

p The RonDB team has been busy in development in 2022. Now is the time to start releasing things. There are 5 things that we are planning to release in Q1 2023./ppRonDB 21.04.9: A new version of RonDB with a few new features required by the Hopsworks 3.1 release and a number of bug fixes. This is released today and will be described in a separate blog./ppRonDB 22.10.0: This is a new Long-Term [...]

Find and remove unused & duplicate indexes in MySQL (from Pythian Blog - MySQL Track)

Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the INSERTs, UPDATEs, and DELETEs operations become. Indexes in MySQL—or for that matter, any database—are never static. Each time you modify... [...]

COUNT(*) vs COUNT(col) in MySQL - Percona Database Performance Blog (from Percona Database Blog)

♦There is a substantial difference in performance and even query results when using COUNT(*) or COUNT(col) in MySQL. Let's take a look. [...]

Updated Percona Distribution for MySQL, Percona XtraDB Cluster: Release Roundup January 9, 2023 - Percona Database Performance Blog (from Percona Database Blog)

♦Percona software releases and updates December 27 - January 9, 2023. [...]

OpenLampTech issue #60 – Substack Repost (from Digital Owl's Prose)

pThank you so much for reading OpenLampTech and making it the success it is today. Wow! 600 developers reading each week! I am humbled to say the very least. In OpenLampTech issue #60, we are looking at some fantastic articles covering: Want to help OpenLampTech be a success and continue to grow? Your free subscription […]/p pThe post OpenLampTech issue #60 – Substack Repost appeared fi [...]

How to import data from Microsoft SQL Server to MySQL HeatWave Database Service (from The Oracle MySQL Blog)

If you have data stored in a Microsoft SQL Server database and you want to import it into MySQL HeatWave Database Service in OCI, you can use the procedure described in this article. [...]

How to speed up a Mysql replica? (from Geeks Worldwide)

There are several ways you can try to speed up a MySQL replica. Here are some ideas: - Geeks Worldwide [...]

The server requested authentication method unknown to the client [phpmyadmin] (from Geeks Worldwide)

It looks like you are trying to connect to a MySQL server using phpMyAdmin and you are encountering an error message saying that the server requested an authentication method unknown to the client. - Geeks Worldwide [...]

Friday, 06. January 2023

MySQL InnoDB Redo Log Archiving (from The Oracle MySQL Blog)

What is MySQL InnoDB Redo Log Archiving ? How does it work ? Discover this important MySQL InnoDB feature reading this blog post. [...]

Thursday, 05. January 2023

Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on OCI (from The Oracle MySQL Blog)

Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on Oracle Cloud (OCI) [...]

Using MySQL Shell to generate table’s create statement from CSV file (from The Oracle MySQL Blog)

MySQL Shell is a command-line interface for interacting with MySQL servers. It allows you to run SQL queries and perform various tasks related to MySQL databases. In this post we will see how we can use MySQL Shell and a plugin to generate table's create statement from a CSV file containing records. [...]

Quick Data Archival in MySQL Using Partitions - Percona Database Performance Blog (from Percona Database Blog)

♦A solution to remove space and rows from tables in a few seconds regardless of the size of a table, without causing any additional load on the MySQL database using table partitions. [...]

Tale of a MySQL 8 Upgrade and Implications on Backup - Percona Database Performance Blog (from Percona Database Blog)

♦Explaining issues in detail and recommending a way to take backups from a replication environment when upgrading from MySQL 5.7.26 to 8.0.27. [...]

Import data from Amazon Aurora PostgreSQL to MySQL HeatWave Database Service in OCI (from The Oracle MySQL Blog)

In this blog post, we will cover how to migrate data from an Amazon Aurora PostgreSQL database to a MySQL HeatWave database in Oracle Cloud Infrastructure (OCI). We will cover the necessary steps to export the data through S3 and import it using MySQL Shell. [...]

Wednesday, 04. January 2023

How to import data from Amazon Redshift to MySQL HeatWave Database Service (from The Oracle MySQL Blog)

Importing CSV files into a MySQL HeatWave Database Service instance is very easy and efficient thanks to MySQL Shell. It can be used to import data from RedShift as we describe in this post. [...]

RocksDB microbenchmarks: crc32c, xxh3 and lz4 uncompress (from Small Datum)

pThe RocksDB benchmark took, db_bench, includes several microbenchmarks to test the performance for hash and checksum functions, compression and decompression. The microbenchmarks measure the latency for these operations per block and the typical block size for me is 4kb or 8kb. A script that I use to run these is here.brbrThe goal for this work is to determine whether there are compiler and other [...]

Faster MySQL with HTTP/3 (from PlanetScale Blog)

In this article, we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.pRead the full story/p [...]

Deep Dive into MySQL's Performance Schema - Percona Database Performance Blog (from Percona Database Blog)

♦Performance schemas are a great help while troubleshooting the behavior of your MySQL server, so it is important to understand how we can make effective use of it. [...]

How to import data from PostgreSQL to MySQL HeatWave Database Service (from The Oracle MySQL Blog)

Whether you are looking to migrate your data from one database management system to another or simply want to transfer data from a PostgreSQL database to MySQL HeatWave on OCI for easier analysis, this tutorial will walk you through the necessary steps. [...]

2023 New Year’s Promise — Climate Positive Continuent (from Continuent Blog)

For 2023 and the future, Continuent has decided to focus more and more on important Climate related issues, naturally to the extent a software company can. To demonstrate this commitment, for the Holiday Season 2022 we have decided to donate 14 Mangrove trees for all Tungsten customer contacts as well as the internal Continuent team members, plus some friends and family members. Continuent has part [...]

Automating Percona's XtraBackup (from Percona Community Blog)

♦Percona’s XtraBackup is a beautiful tool that allows for the backup and restoration of MySQL databases. From the documentation: The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL®. Percona [...]

Tuesday, 03. January 2023

Successful RDS to OCI MySQL HeatWave Migration with Replication Channel Filters (from The Oracle MySQL Blog)

How to use MySQL HeatWave Inbound replication channel filters. [...]

Table Doesn't Exist: MySQL lower_case_table_names Problems - Percona Database Performance Blog (from Percona Database Blog)

♦Showcasing an issue we faced in Managed Services when dropping a MySQL table, and how it was resolved. [...]

COMMIT Latency: Aurora vs. RDS MySQL 8.0 (from Hack MySQL)

pLet’s examine codeCOMMIT/code latency on Aurora v2 (MySQL 5.7) vs. Aurora v3 (MySQL 8.0) vs. RDS MySQL 8.0 2-AZ vs. RDS MySQL 8.0 3-AZ “cluster”./p [...]

MySQL: Ways to run mysqldump (from Die wunderbare Welt von Isotopp)

pThis text exists mainly so that I paste the URL into the code#mysql/code channel in Libera IRC./p pThe codemysqldump/code tools allows you to convert a MySQL database server or individual schemas back to SQL. You are left with a script that is supposed to be loadable into a target server and gives you back the full database, including all objects in it./p pYou can read that SQL as a script into an [...]

Monday, 02. January 2023

Variance in RocksDB benchmarks on cloud HW (from Small Datum)

pI ran experiments with performance regression tests on AWS servers to measure throughput variance across multiple runs of the benchmarks. I search for a setup with less QPS variance to reduce false positives during performance regression tests. /ppThe goals were to determine:/pp/pulliWhich instances have less variance/liliWhether there is less variance with hyperthreading enabled or disabled/ [...]

OpenLampTech issue #59 – Substack Repost (from Digital Owl's Prose)

pOne thing you can absolutely count on is this: OpenLampTech is publishing the best original and curated content available for PHP, MySQL, and LAMP stack developers. Thank you for taking the time to read the OpenLampTech newsletter! Your support helps us tremendously. OpenLampTech has top-level sponsorship opportunities in the weekly newsletter for your brand, product, or […]/p pThe post [...]

Friday, 30. December 2022

MySQL ORDER BY Clause: Syntax and 13 Examples (from Devart MySQL Tool Blog)

pIn MySQL, the ORDER BY clause is used to sort the records fetched by the SELECT statement, in ascending or descending order. And while the usage of this command is simple in basic cases, there are more complex scenarios requiring much more attention. This article will explore the essence, the syntax, and the usage scenarios […]/p pThe post MySQL ORDER BY Clause: Syntax and 13 Examples appear [...]