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, 04. December 2023

Newsletter Repost – OpenLampTech issue #107 (from Digital Owl's Prose)

pMySQL binlog | Laravel exception handling | WordPress plugin context | MySQL GUIs. OpenLampTech is a media and content source for MySQL, PHP, and the LAMP stack. Thanks for reading OpenLampTech. If you are not yet subscribed, please consider grabbing a free subscription today./p pThe post Newsletter Repost – OpenLampTech issue #107 appeared first on Digital Owl's Prose./p [...]

Sunday, 03. December 2023

Applying Database Migrations in MySQL HeatWave With GitHub Actions (from The Oracle MySQL Blog)

GitHub Actions allows DevOps to handle automated deployments. IN this post we talk about how you can use GitHub Actions in conjunction with Knex.js to apply database changes as part of the CI/CD pipeline. [...]

Saturday, 02. December 2023

Enhancing MySQL 8 on Modern Hardware: A Guide to Tuning InnoDB I/O Threads for Optimal Performance (from MinervaDB Blog)

pIn this comprehensive guide, we delve into the advanced tuning of `innodb_read_io_threads` and `innodb_write_io_threads` in MySQL 8, specifically tailored for modern hardware infrastructures. We cover essential strategies for incrementally adjusting these settings to harness the full capabilities of SSDs and multi-core processors, ensuring a balanced and efficient use of resources. The guide also [...]

Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1 (from The Oracle MySQL Blog)

How to easily migrate from MariaDB to MySQL HearWave using the new MySQL Shell capabilities of the copy utility. [...]

Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1 (from lefred's blog)

I won’t cover reasons why you should migrate from MariaDB to MySQL, I already covered the topic in previous blogs and webinars: In this post, I will cover a new easier way to migrate using the latest MySQL Shell 8.2.1 and the copyInstance() utility. Previously, if you wanted to migrate to MySQL HeatWave (the name […] [...]

Friday, 01. December 2023

Solutions for building modern applications with Amazon ElastiCache and Amazon MemoryDB for Redis (from AWS Database Blog)

In-memory databases are ideal for applications that require microsecond response times and high throughput, such as caching, gaming, session stores, geo-spatial services, queuing, real-time data analytics and feature stores for machine learning (ML). In this In-Memory Database Bluebook, we provide you with a list of Amazon ElastiCache and Amazon MemoryDB for Redis code samples and […] [...]

What is HTAP? (from PlanetScale Blog)

Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP. [...]

MySQL Shorts - Top 5 Countdown - #5 (from The Oracle MySQL Blog)

MySQL Shorts is a short-format video series dedicated to all things MySQL. This post is one in a series where we will count down the top 5 MySQL Shorts videos based on views. [...]

Thursday, 30. November 2023

How to get MySQL Primary Keys in one minute (from Kedar MySQL Blog)

pThis blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…/p The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable. [...]

The Importance of Anti-Affinity in Kubernetes (from Percona Community Blog)

Last week, I embarked on the task of deploying our Percona Operator for MongoDB in Kubernetes. After completing the deployment process, I noticed that the status of the Custom Resource Definition for Percona Server for MongoDB was still displaying as ‘initializing’ and two of our Pods remained in a Pending state. edithpuclla@Ediths-MBP % kubectl get perconaservermongodbs.psmdb.percona.c [...]

Wednesday, 29. November 2023

Manage an Azure Database for MySQL flexible server database with phpMyAdmin (from Azure for MySQL Blog)

pphpMyAdmin is a web-based tool that is commonly used for tasks such as setting up and configuring databases, performing routine maintenance, managing user accounts, and running SQL queries. The tool provides an intuitive way for users to manage their MySQL databases without having to leverage the command line or more complex database administration tools./p p /p pIn this blog post, I’ll show [...]

OpenLampTech Newsletter Repost – Developer Interview With Phil Kurth (from Digital Owl's Prose)

pFreelance web developer Phil Kurth shares a fantastic developer interview with the OpenLampTech newsletter readers. Phil Kurth works with a wide range of clients and builds WordPress plugin extensions for the ever-popular Advanced Custom Fields plugin. Phil has a lot of knowledge, insight, and experience in the web development industry so I’m very excited he […]/p pThe post OpenLampTec [...]

Significant performance regression since MySQL 8.0.30 (up to 8.2.0 so far) (from Szymon Skorupinski Blog)

Before migrating from MySQL 5.7 to 8.0 I had created automated benchmarking framework which proved to give us repeatable results. It is based on sysbench and we perform set of runs with different threads from 16 to 256 with the step of 16, using OLTP Read Write workload and Percona’s TPCC-like one. I may write … Continue reading "Significant performance regression since MySQL 8.0.30 (up [...]

Tuesday, 28. November 2023

Deliver applications with machine learning-powered recommendations (from The Oracle MySQL Blog)

Recommender systems are one of the most sought-after applications of machine learning as they’ve proven to drive significant revenue. MySQL HeatWave allows you to easily integrate a recommendation system into your applications. As a matter of fact, you can test it out by building the MovieHub application we’ve developed to showcase the HeatWave AutoML recommender system. You won’t even have to code [...]

The Infamous ORDER BY LIMIT Query Optimizer Bug (from Hack MySQL)

pWhich is faster: codeLIMIT 1/code or codeLIMIT 20/code? Presumably, fetching less rows is faster than fetching more rows. But for 16 years (since 2007) the MySQL query optimizer has had a “bug”† that not only makes codeLIMIT 1/code slower than codeLIMIT 20/code but can also make the former a table scan, which tends to cause problems. This happened last week where I work, and although M [...]

Introducing Insights Anomalies (from PlanetScale Blog)

This new update to PlanetScale Insights introduces smart query monitoring to detect slower than expected queries in your database. [...]

MySQL at DOAG 2023 – recap (from lefred's blog)

Last week, from November 21 to 24, the DOAG Conference took place in Nuremberg, Germany. The MySQL Team was present at the Oracle booth. I attended the conference Thursday and Friday. There were 20 sessions tagged “MySQL” and one full day workshop dedicated to students. I delivered the first part of the workshop dedicated to […] [...]

MySQL at DOAG 2023 - recap (from The Oracle MySQL Blog)

Recap of DOAG 2023 [...]

Effortlessly Transform CSV into a REST API with TiDB Cloud Data Services  (from TiDB and TiKV Blog)

pEfficient backend management is a cornerstone of successful application development. Navigating this realm poses significant challenges, especially when aligning with emerging backend trends. This often leads to time-consuming and repetitive architectural processes. To solve this challenge, we introduce TiDB Serverless and TiDB Cloud Data Service (TCDS) —remarkable product offerings of TiDB Cloud. [...]

Monday, 27. November 2023

Using DBeaver to connect to Azure Database for MySQL - Flexible Server (from Azure for MySQL Blog)

pIf you’re running an instance of Azure Database for MySQL - Flexible Server, you know how important it is to have a convenient way to connect to and work with the database. That’s where the DBeaver's Ultimate and Team Edition come in. /p p /p pYou can choose from either of the solutions to manage your MySQL databases in Azure:  /p ul liDBeaver Ultimate: Multifunctional dat [...]

Explaining changes in MySQL performance via hardware perf counters: part 4 (from Small Datum)

pThis is part 4 of my series on using HW counters from Linux perf to explain why MySQL gets slower from 5.6 to 8.0. Refer to part 1 for an overview./ppWhat happened in MySQL 5.7 and 8.0 to put so much more stress on the memory system?/pptl;dr/pp/pulliIt looks like someone sprinkled magic go slower dust across most of the MySQL code because the slowdown from MySQL 5.6 to 8.0 is n [...]

Explaining changes in MySQL performance via hardware perf counters: part 3 (from Small Datum)

pThis is part 3 of my series on using HW counters from Linux perf to explain why MySQL gets slower from 5.6 to 8.0. Refer to part 1 for an overview.brbrWhat happened in MySQL 5.7 and 8.0 to put so much more stress on the memory system?/pptl;dr/pp/pulliIt looks like someone sprinkled magic go slower dust across most of the MySQL code because the slowdown from MySQL 5.6 to 8.0 is [...]

Explaining changes in MySQL performance via hardware perf counters: part 2 (from Small Datum)

pThis is part 2 of my series on using HW counters from Linux perf to explain why MySQL gets slower from 5.6 to 8.0. Refer to part 1 for an overview.br/ppWhat happened in MySQL 5.7 and 8.0 to put so much more stress on the memory system?/pptl;dr/pp/pp/pp/pp/pulliIt looks like someone sprinkled magic go slower dust across most of the MySQL code because the slowdown from MySQL 5.6 to 8.0 is not i [...]

Explaining changes in MySQL performance via hardware perf counters: part 1 (from Small Datum)

pI spend much time documenting how MySQL performance has changed over the years. After my latest round of benchmarks I looked at flamegraphs from MySQL/InnoDB during the insert benchmark. Unfortunately, I didn't see anything obvious when comparing flamegraphs for MySQL 5.6, 5.7 and 8.0. Mostly, the flamegraphs looked the same -- the percentage of time in various call stacks was similar, and the cal [...]

Newsletter Repost – OpenLampTech issue #106 (from Digital Owl's Prose)

pMySQL Invisible Columns | Lightweight Linux distros | 10 PHP libraries for 2023 | New WooCommerce install default blocks. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack. Thank you for reading OpenLampTech. If you are not yet subscribed, be sure and grab a free subscription today./p pThe post Newsletter Repost – OpenLampTech issue #106 appeared fi [...]

Webinar: Launch in 15 minutes, in Amazon and on-premises, manage and monitor Percona XtraDB Clusters with the NEW Galera Manager (from Galera Blog)

As with every Galera Manager release, we consider a huge amount of features, and we always improve the UI and functionality based on your feature requests, to ensure that as a user, you’re happier, but more importantly, more efficient in production. ​ One of the biggest feature requests was to have Percona XtraDB Cluster (PXC) […] [...]

Sunday, 26. November 2023

Performance Improvements in MySQL 8.0.35 (from The Oracle MySQL Blog)

This blog post highlights the significant performance improvement made in the latest 8.0 version of MySQL Enterprise Edition [...]

Advanced Troubleshooting of MySQL Query Latency and Index Usage with eBPF: Scripts and Methodologies (from MinervaDB Blog)

pUsing eBPF (extended Berkeley Packet Filter) for troubleshooting MySQL query latency and index usage is a sophisticated technique that leverages Linux's advanced tracing capabilities. eBPF allows you to trace system and application-level metrics without significant performance overhead [...]/p pThe post Advanced Troubleshooting of MySQL Query Latency and Index Usage with eBPF: Scripts and Methodol [...]

Saturday, 25. November 2023

InnoDB Deadlock on SELECT? Not possible! Or Is It? (from Shinguz's Blog)

Introduction pTwo points in advance:/p ol liA deadlock is a state in which two different transactions are no longer able to continue working because each transaction holds a lock that the other transaction would need. Because both transactions are now waiting for the other transaction to release their locks, neither transaction will release their respective locks. And that would last forever. T [...]

Friday, 24. November 2023

EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL (from The Oracle MySQL Blog)

In MySQL 8.1 and 8.2 we introduced EXPLAIN INTO and EXPLAIN FOR SCHEMA respectively, two extensions to the EXPLAIN query that can help doing most of your query optimization in the server, rather than a client program. These two features lay the groundwork for automatically running multiple EXPLAINs over multiple schemas without having to manually USE each schema or reenter the EXPLAIN output. [...]

Where can you find MySQL during December - February 2024 (from The Oracle MySQL Blog)

MySQL in Dec-Feb24 [...]

Looking for MySQL 5.7 or 8.0 guinea pigs (from MariaDB Foundation Blog)

pDear users of MySQL 5.7 (or 8.0)!br Are you interested in getting help migrating to MariaDB 10.6 or 10.11, the latest long-term support releases? Are you coming to Brussels for FOSDEM in February? … /p pContinue reading \"Looking for MySQL 5.7 or 8.0 guinea pigs\"/p pThe post Looking for MySQL 5.7 or 8.0 guinea pigs appeared first on MariaDB.org./p [...]

Thursday, 23. November 2023

Optimizing Pagination Queries in MariaDB: Best Practices, Efficient Techniques, and Performance Tips (from MinervaDB Blog)

pPagination in MariaDB, like in other databases, requires careful consideration of performance and consistency. Basic pagination with LIMIT and OFFSET is straightforward but might not be the best approach for large datasets due to performance issues. [...]/p pThe post Optimizing Pagination Queries in MariaDB: Best Practices, Efficient Techniques, and Performance Tips appeared first on The WebScale [...]

MySQL Workshop at HKCE and PyCon HK2023 - recap. (from The Oracle MySQL Blog)

PyCon & HKCE 2023 [...]

Wednesday, 22. November 2023

Galera Manager November 2023 Release now includes deployment and monitoring for Percona XtraDB Cluster (PXC) 8.0 (from Galera Blog)

Codership is pleased to announce a new release of Galera Manager. This brings the installer to version 1.11.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.11.0 (linux/amd64)) and the actual Galera Manager GUI to 1.8.0. Users will notice many usability improvements, and multiple fixes for issues filed at the […] [...]

Thoughts on the October 2023 MySQL Releases (from J-F Gagné's MySQL Blog)

A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44.  I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed.  I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes.  The subject of my disappointment is Oracle not [...]

Node.js MySQL Insert Record (from Code For Geek)

We already have a tutorial on how to connect to the MySQL database using Node.js. Well, you can read it if you want to know, but it only allows you to interact with the database, what if you want to insert some new records directly from Node.js? You can also easily do this by executing […] [...]

Newsletter Repost: Developer Interview With Marian Pop – OpenLampTech (from Digital Owl's Prose)

pPHP developer and Laravel content creator Marian Pop shares a fantastic developer interview with the OpenLampTech newsletter readers. Welcome to this OpenLampTech text-based developer interview. PHP developer Marian Pop is very active in the Laravel community. Marian writes a daily blog, and a newsletter, and has a podcast – all covering Laravel. Subscribe to OpenLampTech to read [ [...]

How TiDB Dedicated Achieves Zero Downtime During Kubernetes Node Upgrades (from TiDB and TiKV Blog)

pA key aspect of Database as a Service (DBaaS) solutions is ensuring zero downtime, especially during system upgrades. Zero downtime is paramount as it guarantees uninterrupted service, a critical requirement for mission-critical applications running on the database.  TiDB Dedicated is PingCAP’s fully-managed cloud Database-as-a-Service (DBaaS) platform on AWS and GCP. This DBaaS uses ma [...]

Tuesday, 21. November 2023

MariaDB 11.3.1, 11.2.2 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.3.1, the first Release Candidate in the MariaDB 11.3 series, and MariaDB 11.2.2, the first stable release in the MariaDB 11.2 series. … /p pContinue reading \"MariaDB 11.3.1, 11.2.2 now available\"/p pThe post MariaDB 11.3.1, 11.2.2 now available appeared first on MariaDB.org./p [...]

Learn about the newest features available in MariaDB Community Server 11.2 (GA) and 11.3 (RC). (from MariaDB Corporation Blog)

We are pleased to announce the general availability (GA) of MariaDB Community Server 11.2 and the first release candidate (RC) … Continued [...]

Webhook security: a hands-on guide (from PlanetScale Blog)

Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more. [...]

Optimizing Complex SQL Joins in MySQL: The Impact of Multicolumn Indexes on Execution Plans (from MinervaDB Blog)

pMulticolumn indexes, also known as composite indexes in MySQL, can significantly impact the execution plans of complex SQL JOIN operations. These indexes are defined on two or more columns of a table and can be highly effective in optimizing queries that involve conditions on those columns. [...]/p pThe post Optimizing Complex SQL Joins in MySQL: The Impact of Multicolumn Indexes on Execution Plan [...]

Monday, 20. November 2023

A winning strategy for migrating from Azure Database for MySQL - Single Server to Flexible Server (from Azure for MySQL Blog)

pAzure Database for MySQL - Single Server is on the retirement path, scheduled for retirement by September 16, 2024. As a result, we strongly recommend that you migrate your single servers to Azure Database for MySQL – Flexible Server at your earliest opportunity. This will help ensure that you have ample time to run through the migration lifecycle, leverage the benefits that come with Flexible Ser [...]

Secure GxP compliance by automating the Amazon RDS security audit log export process (from AWS Database Blog)

Database audit logs are records of activities and events that occur within a database system. These logs capture details about user interactions, system changes, and data modifications, providing a comprehensive trail of actions performed on the database. By maintaining a meticulous record of these activities, organizations gain valuable insights into who accessed the database, what […] [...]

Three surprising benefits of sharding a MySQL database (from PlanetScale Blog)

There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database. [...]

3 principles of Sovereign DBaaS and how ClusterControl supports them (from Severalnines Blog)

pIn today’s era, where decision making has to be rapid and data-driven, the data that your business aggregates is increasingly critical. And as more and more regulation is passed, data sovereignty is now a significant area to address. The concept of data sovereignty is important to incorporate into any organization’s data architecture design. Concerns over […]/p pThe post 3 principles of Sove [...]

Newsletter Repost – OpenLampTech issue #105 (from Digital Owl's Prose)

pSQL Upserts | WordPress nonces | WordPress CLI | Microservices with PHP | Laravel vs Symfony. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack. Thanks for your interest in the OpenLampTech newsletter. Be sure you’re subscribed so you don’t miss any of the great content./p pThe post Newsletter Repost – OpenLampTech issue #105 appear [...]

MySQL: Latest AWS RDS Snapshot Upgrade (from Mydbops Blog)

Author: Kabilesh PR MySQL users, buckle up! A groundbreaking feature is now at your fingertips: the AWS RDS Snapshot Upgrade. That's right – your snapshots can now undergo upgrades. This game-changin [...]

Day 02: The Kubernetes Application Lifecycle (from Percona Community Blog)

If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through from initial planning, building, deployment, monitoring, and maintenance in different environments where our application can be executed. On the other hand, the Kubernetes Application Lifecycle refers exclusively to appl [...]

Sunday, 19. November 2023

Optimizer-related fixes in current batch of stable releases (from Sergei Petrunia's blog)

(EDIT: added also MDEV-32203) MariaDB released has made a batch of releases in the stable series. I wanted to list notable query optimizer improvements there, together with some comments. MDEV-29693: ANALYZE TABLE still flushes table definition cache when engine-independent statistics is used If one has a long running query and at the same time runs…More [...]

Friday, 17. November 2023

Introducing Group Replication plugin for active/active replication on Amazon RDS for MySQL (from AWS Database Blog)

Amazon Relational Database Service (Amazon RDS) for MySQL now supports the Group Replication plugin for active/active replication. You can use the plugin to set up active/active replication between your RDS for MySQL database instances to provide continuous availability for your applications. Writing to two or more database instances in an active/active cluster can help maximize […] [...]

Attending Percona University in Athens 2023 (from MariaDB Foundation Blog)

pIt’s been a while since we posted about community organised events. I’m happy to have the chance to talk about my experience attending Percona University in Athens. … /p pContinue reading \"Attending Percona University in Athens 2023\"/p pThe post Attending Percona University in Athens 2023 appeared first on MariaDB.org./p [...]

Thursday, 16. November 2023

Checking RocksDB 8.x for performance regressions on a large server, part 2 (from Small Datum)

pThis post has results for performance regressions in all versions of 8.x using a large server. In a previous post I shared results for RocksDB 7.x and 8.x on the same hardware. Here I have results for new versions of RocksDB 8.7 and 8.8./pptl;dr/pp/pulliThings mostly look good/liliThere are a few known problems/liliThere are a few possible regressions that will take more time to figure out/li/ulp/ [...]

Achieve one second or less of downtime with ProxySQL when upgrading Amazon RDS Multi-AZ deployments with two readable standbys (from AWS Database Blog)

In this post, we explore how to use ProxySQL to achieve a downtime of typically 1 second or less when performing a minor version upgrade on Amazon RDS for MySQL Multi-AZ deployments with two readable standbys (Amazon RDS Multi-AZ DB cluster). ProxySQL is an open source proxy for MySQL. Currently, minor version upgrades or system […] [...]

Achieve one second or less downtime with the Advanced JDBC Wrapper Driver when upgrading Amazon RDS Multi-AZ DB Clusters (from AWS Database Blog)

When upgrading minor versions of RDS Multi-AZ clusters the connections are switched from the current writer to a newly upgraded reader. Clients have the option to connect to either the cluster writer endpoint or the cluster reader endpoint. Normally, they would connect to the writer endpoint. This endpoint is directed to the current writer instance. […] [...]

Azure Database for MySQL - Flexible Server accelerated logs (Preview) (from Azure for MySQL Blog)

pWe're excited to announce public preview of the accelerated logs feature for Azure Database for MySQL – Flexible Server! This functionality, available with the Business Critical service tier, significantly enhances the performance of MySQL flexible servers, offering a dynamic solution that is designed for high throughput needs that also reduces latency and optimizes cost efficiency. This [...]

Checking RocksDB 4.x thru 8.x for performance regressions on a small server: IO-bound with buffered IO (from Small Datum)

pThis post has for performance regressions in most versions of RocksDB 4.x and all versions of 5.x, 6.x, 7.x and 8.x using a small server. The workload is IO-bound and RocksDB uses buffered IO. In a previous post I shared results for RocksDB 7.x and 8.x on a larger server. A post for a cached workload is here and for IO-bound with O_DIRECT is here./ppThe workload here is IO-bound and has [...]

Checking RocksDB 4.x thru 8.x for performance regressions on a small server: IO-bound with O_DIRECT (from Small Datum)

pThis post has results for performance regressions in all versions of 6.x, 7.x and 8.x using a small server. The workload is IO-bound and RocksDB uses O_DIRECT. Unlike the previous two posts I skip RocksDB 4.x and 5.x here because I am not sure they had good support for O_DIRECT.  In a previous post I shared results for RocksDB 7.x and 8.x on a larger server. A post for a cached [...]

Checking RocksDB 4.x thru 8.x for performance regressions on a small server: cached workload (from Small Datum)

pThis post has results for performance regressions in most versions of RocksDB 4.x and all versions of 5.x, 6.x, 7.x and 8.x using a small server and a cached workload. Posts for IO-bound workloads are here and here. In a previous post I shared results for RocksDB 7.x and 8.x on a larger server./ppThe workload here is mostly cached and has low concurrency so the performance is mostly a function of [...]

Wednesday, 15. November 2023

Announcing the Azure Database for MySQL Contributor initiative! (from Azure for MySQL Blog)

pToday, we’re announcing the kick-off of an exciting new effort, the Azure Database for MySQL Contributor initiative!brbr/p pThis initiative recognizes members of the Azure Database for MySQL community who actively work to raise awareness of the service by sharing relevant content, announcements, and product news via various social media channels. Depending on their level of interest, these communi [...]

Microsoft Azure innovation powers leading price-performance for MySQL database in the cloud (from Azure for MySQL Blog)

pAs part of our commitment to ensuring that Microsoft Azure is the best place to run MySQL workloads, Microsoft is excited to announce that Azure Database for MySQL - Flexible Server just achieved a new, faster performance benchmark./p p /p pWith the public preview of accelerated logs in the Azure Database for MySQL Business Critical service tier, you’ll see improved perfor [...]

What is the difference between UPSERT and insert in MySQL? (from TechBeamers MySQL)

pIn MySQL, while working with tables, it is important to understand the difference between UPSERT and INSERT statements. The INSERT statement simply adds entirely new records to a table, whereas UPSERT combines the functionalities of both INSERT and UPDATE. UPSERT is employed when you want to insert new records into a table but also need [...]/p pThe post What is the difference between UPSERT and i [...]

MySQL Telemetry Tracing with OCI APM (from The Oracle MySQL Blog)

This blog tells how to use the OCI APM (Application Performance Monitor) for MySQL [...]

MySQL replication: Best practices and considerations (from PlanetScale Blog)

Learn the best practices for configuring MySQL replication, and how to ensure your data is always available. [...]

Developer Interview With Przemysław Hernik – OpenLampTech Repost (from Digital Owl's Prose)

pLong-time WordPress and Vue.js software engineer Przemysław Hernik shares a fantastic developer interview with the OpenLampTech readers. Be sure you’re subscribed to the OpenLampTech newsletter so you don’t miss out on any of the fantastic content published each week./p pThe post Developer Interview With Przemysław Hernik – OpenLampTech Repost appeared first on Digital Owl's [...]

MySQL 8.2 Read/Write Splitting: a what cost ? (from lefred's blog)

We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector/Python. I love this new feature, but I was wondering if it was really worth it. Will the application benefit from offloading reads to another node, and won’t using the MySQL Router and parsing the […] [...]

What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication (from Devart MySQL Tool Blog)

pNavigating the security landscape of cloud services can be complex, but AWS IAM provides a robust framework for secure access management. In this article, we'll explore what AWS Identity and Access Management (IAM) is and how it enhances security./p pThe post What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication appeared first on Devart Blog./p [...]

MySQL Belgian Days 2024 (from The Oracle MySQL Blog)

Register for the MySQL Belgian Days 2024, 2 days of exclusive MySQL content from engineers, customers and community. [...]

Troubleshooting MySQL Query Performance with Strace: A Practical Guide (from MinervaDB Blog)

pAfter following the steps outlined in this guide, you should be able to diagnose and optimize the performance of a specific MySQL query using strace. By tracing the MySQL thread and analyzing the system calls captured in the mysql_strace.log file, you can identify potential bottlenecks and take appropriate optimization steps. [...]/p pThe post Troubleshooting MySQL Query Performance with Strace: A [...]

Perf regressions in MySQL from 5.6.21 to 8.0.34 using the Insert Benchmark and a medium server, part 1 (from Small Datum)

pThis post has results from the Insert Benchmark for some MySQL 5.6 releases, all 5.7 releases and all 8.0 releases using a medium server and a cached workload. Previous posts have results from a small server for cached and IO-bound workloads. A 5-part series for the medium server and MySQL is here./ppshort and less truthy tl;dr/pp/pulliThere were big improvements from MySQL 5.6 to 5.7/li [...]

Tuesday, 14. November 2023

MySQL Belgian Days 2024 (from lefred's blog)

After 12 consecutive years of MySQL presence at FOSDEM, the MySQL Devroom has been rejected of the 2024 edition. The MySQL & Friends Devroom has been always very popular, almost full for each sessions and maybe the room with the most received submissions. This is also the reason why since 2017, MySQL was proposing a […] [...]

Effective Annotating of Strace Output for MySQL Performance Troubleshooting (from MinervaDB Blog)

p“Annotating strace output is like adding signposts to the path of performance optimization, leading you to the heart of MySQL’s efficiency.” – MinervaDB What is Linux Process Snapper? Linux Process Snapper, commonly known as strace, is [...]/p pThe post Effective Annotating of Strace Output for MySQL Performance Troubleshooting appeared first on The WebScale Database I [...]

Debugging perf changes in RocksDB 8.6 on a small server (from Small Datum)

pThis post has benchmark results for RocksDB 8.5 through 8.8 using a small server. I previously wrote about results for this benchmark on a large server. /ppRocksDB 8.6 changes how prefetching is implemented for storage reads done by compaction. It now uses the readahead system call on Linux (see here and here) and the amount to prefetch is determined by the compaction_readahead_size option. T [...]

MariaDB 11.1.3, 11.0.4, 10.11.6, 10.10.7, 10.6.16, 10.5.23, 10.4.32 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.6, MariaDB 10.6.16, MariaDB 10.5.23 and MariaDB 10.4.32, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.1.3, MariaDB 11.0.4 and MariaDB 10.10.7, the latest stable releases in their respective short-term series (mai [...]

MariaDB Community Server Q4 2023 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.1.3, 11.0.4, 10.11.6, 10.10.7, 10.6.16, 10.5.23, and 10.4.32 … Continued [...]

How to Import/Export MySQL Data to SQL Azure: Using ODBC Driver for Data Migration (from Devart MySQL Tool Blog)

pIn this article, we'll briefly review some advantages of SQL Azure, a Microsoft cloud-based SQL database service, and explore how to export and import data between Azure SQL and MySQL server using a universal ODBC driver for SQL Azure and a powerful MySQL tool - dbForge Studio for MySQL./p pThe post How to Import/Export MySQL Data to SQL Azure: Using ODBC Driver for Data Migration appeared first o [...]

Decoding Serverless Databases: How They Transform Application Development (from TiDB and TiKV Blog)

pServerless computing and serverless databases. Both terms have achieved buzzword status in recent years. What do they mean, exactly? In the simplest terms, serverless computing refers to a model where developers can build and run applications without thinking about the underlying infrastructure. There is no need to worry about determining the number and sizes of […]/p pThe post Decoding Serv [...]

A guide to HTML email with Ruby on Rails and Tailwind CSS (from PlanetScale Blog)

Learn how to build HTML emails using Rails and Tailwind CSS. We also cover how to overcome some common obstacles such as Gmail message clipping, large file size, Apple autolinking, and more. [...]

Optimizing MySQL InnoDB I/O: Effective Strategies for Tuning innodb_io_capacity and innodb_io_capacity_max (from MinervaDB Blog)

pOptimizing innodb_io_capacity and innodb_io_capacity_max is a crucial step in maximizing the I/O capabilities of your MySQL instance's underlying storage hardware. By fine-tuning these parameters, you can align InnoDB's I/O operations with your hardware's performance characteristics, resulting in improved overall database efficiency. [...]/p pThe post Optimizing MySQL InnoDB I/O: Effective Strate [...]

Monday, 13. November 2023

Unlocking MySQL’s Performance Potential: Navigating the Impact of Queue Waits and Optimizing for Peak Efficiency (from MinervaDB Blog)

pQueue waits in MySQL occur when processes or threads wait in a queue before execution. This typically happens when system resources are overutilized, and the server cannot immediately process incoming requests. Queue waits can significantly impact MySQL performance, especially in high-concurrency environments. [...]/p pThe post Unlocking MySQL’s Performance Potential: Navigating the Impact o [...]

Database Upgrades: DIY or Choose a Database Upgrade Consulting Service? (from Percona Database Blog)

♦To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End of Life (EOL)  – it’s crucial to upgrade your database systems from time to time. When it comes to undertaking this considerable (and potentially time-consuming) project, you generally have one of two options: DIY upgrades […] [...]

Innovation Release of Percona XtraBackup, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023 (from Percona Database Blog)

♦Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups sh [...]

Troubleshooting signal waits happening to MySQL (from MinervaDB Blog)

pTroubleshooting signal waits in MySQL can be a challenging task for database administrators. This insightful article delves into the complexities of signal waits, offering valuable guidance on identifying and resolving these issues. [...]/p pThe post Troubleshooting signal waits happening to MySQL appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, Mari [...]

Newsletter Repost – OpenLampTech issue #104 (from Digital Owl's Prose)

p52 + 52 = 104. A letter from Josh. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack. Maybe you have guessed already. Or used your incredible math skills and surmised that OpenLampTech issue #104 is a historic event for me and this newsletter. Be sure and grab your free subscription to […]/p pThe post Newsletter Repost – OpenLampTech issue #104 appeared firs [...]

Why Documentation is Important (from TiDB and TiKV Blog)

pDocumentation (or “docs”) is such a key part of any open-source software project. If you have good docs, users will find it easy to get started. They’ll also be able to find answers on their own for the majority of questions as they use the software.  Even before I start evaluating technical products or organizations, […]/p pThe post Why Documentation is Important appeared first on Ping [...]

Sunday, 12. November 2023

Creating and Implementing Custom Sequences in MySQL 8 (from MinervaDB Blog)

pIn MySQL, a table-based sequence is used to generate a sequence of numbers, typically for auto-incrementing primary keys. However, unlike some other databases, MySQL does not have a built-in SEQUENCE object. Instead, you can simulate a sequence [...]/p pThe post Creating and Implementing Custom Sequences in MySQL 8 appeared first on The WebScale Database Infrastructure Operations Experts in Postgr [...]

Friday, 10. November 2023

Azure Database for MySQL - October 2023 updates and latest feature roadmap (from Azure for MySQL Blog)

pWe're pleased to share with you a summary of the Azure Database for MySQL - Flexible Server feature updates and announcements from last month, as well as the latest roadmap of upcoming features!/p p /p November 2023 Live webinar p /p pThese feature updates are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second W [...]

How to use MySQL 8.2 read/write splitting with Connector/Python (from The Oracle MySQL Blog)

In this article you will see how to use MySQL 8.2 transparent read/write splitting using MySQL Connector/Python and a MySQL InnoDB Cluster [...]

Optimize cost and boost performance of RDS for MySQL using Amazon ElastiCache for Redis (from AWS Database Blog)

Customers often face the challenge of optimizing the cost of their database environments, while having to improve their application performance and response times, as both their data volumes and user base grow. Internet-scale applications that have large volumes of data and high volumes of throughput need underlying data architectures that can support microsecond latencies. Improving […] [...]

Data On Kubernetes (from Percona Community Blog)

If you’ve attended one of the Kubecon talks or related events, you’ve likely encountered the phrase Data on Kubernetes. To understand what this means, let’s explore some fundamental concepts related to Kubernetes, workload, stateless, and stateful applications. Kubernetes, workload, stateless and stateful applications Kubernetes is a container orchestration tool that has already b [...]

Thursday, 09. November 2023

Architect and migrate business-critical applications to Amazon RDS for Oracle (from AWS Database Blog)

Amazon Relational Database Service (Amazon RDS) for Oracle is a fully managed commercial database that makes it straightforward to set up, operate, and scale Oracle deployments in the cloud. In this post, we share the story of a database migration for a business-critical application from a vital database instance running inside Oracle SuperCluster to Amazon […] [...]

How to use MySQL 8.2 read/write splitting with Connector/Python (from lefred's blog)

As you know, one of the most eagerly waited features was released with MySQL 8.2: the transparent read/write splitting. In this post, we’ll look at how to use it with MySQL-Connector/Python. Architecture To play with our Python program, we will use an InnoDB Cluster. This is an overview of the cluster in MySQL Shell: MySQL […] [...]

Managing MySQL Connection Overhead: Understanding the CJ Abandoned Connection Cleanup Thread (from MinervaDB Blog)

pIn the context of MySQL and its Connector/J (the JDBC driver for MySQL), the “CJ Abandoned Connection Cleanup” thread is a background thread responsible for cleaning up abandoned JDBC connections. The application does not properly [...]/p pThe post Managing MySQL Connection Overhead: Understanding the CJ Abandoned Connection Cleanup Thread appeared first on The WebScale Database Infras [...]

Understanding What Kubernetes Is Used For: The Key to Cloud-Native Efficiency (from Percona Database Blog)

♦If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. You may already be using it daily and find it makes running applications in the cloud much more manageable. But for those who are not so familiar, in this post, we will discuss how Kubernetes has emerged […] [...]

Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 5 (from Small Datum)

pThis is part 5 of my results from sysbench vs MySQL on a medium server - see part 1, part 2, part 3 and part 4. This post documents how performance changes from MySQL 8.0.27 to 8.0.32./ppQPS decreased by ~10% for many of the sysbench tests from MySQL 8.0.27 to 8.0.31. The problem is new CPU overheads from code changes that I am still documenting. While perf regressions ove [...]

Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 4 (from Small Datum)

pThis is part 4 of my results from sysbench vs MySQL on a medium server - see part 1, part 2 and part 3. This post has results for all MySQL 8.0 releases./ppThere are significant drops in QPS from 8.0.27 to 8.0.28 and then again from 8.0.28 to 8.0.30. Some of this is thanks to changes in the InnoDB record layer. Hopefully this gets fixed, if not use MyRocks. Percona has&nbs [...]

PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management (from Percona Database Blog)

♦In this blog post, we will discuss how to extend Percona Monitoring and Management (PMM) to get PostgreSQL metrics on checkpointing activity, internal buffers, and WAL usage. With this data, we’ll be able to better understand and tune our Postgres servers.We’ll assume there are working PostgreSQL and PMM environments set up already. You can search […] [...]

Optimizing MySQL Throughput: Fine-Tuning InnoDB Thread Concurrency (from MinervaDB Blog)

pConfiguring innodb_thread_concurrency allows you to control the number of threads that can enter InnoDB concurrently. Setting this value correctly can greatly improve the performance of your MySQL server, especially during times of high concurrency. Here is how [...]/p pThe post Optimizing MySQL Throughput: Fine-Tuning InnoDB Thread Concurrency appeared first on The WebScale Database Inf [...]

Monitoring Azure Database for MySQL - Flexible Server using Grafana (from Azure for MySQL Blog)

pMonitoring Azure Database for MySQL - Flexible Server in a PaaS environment can be a challenging task. As a fully managed database service, MySQL - Flexible Server provides many benefits, including automatic backups, patching, and scaling. However, it also limits access to the underlying infrastructure, which can make it difficult to monitor the database's performance and health status. This lack [...]