This article is focused on describing the latest performance benchmarking executed on the latest release of MySQL and Percona. 

In this set of tests I have used the machine described here.  

Assumptions

There are many ways to run tests, and we know that results may vary depending on how you play with many factors, like the environment or the MySQL server settings. However, if we compare several versions of the same product on the same platform, it is logical to assume that all the versions will have the same “chance” to behave well or badly unless we change the MySQL server settings. 

Because of this, I ran the tests changing only things in a consistent way, with the intent to give the same opportunity to each solution., with the clear assumption that if you release your product based …

In reply to John.

Hi again, looks like they’ve got a fix set for Router 8.4.5 (“Fixed as of the upcoming MySQL Router 8.4.5 and 9.3.0 releases“).

LikeLike

The Oracle HeatWave MySQL service offers users the flexibility to modify DB system shapes and configuration, enabling them to adapt to changing workloads and enhance performance. In this blog post we’ll share insights into the latest changes related to DB system shape and configuration changes, mostly focusing on the high availability and read replicas support. […]

Data copying and migration are essential database tasks that arise frequently. Many tools assist database professionals in performing these tasks, with dbForge Studio for MySQL standing out as the most reliable solution.

The post Methods to Copy Data Using dbForge for MySQL appeared first on Devart Blog.

Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However, the Blue/Green feature of RDS utilizes asynchronous replication, which allows us to update the table […]

In this blog post, we will explore how to use MySQL's spatial features to analyze the similarity of trajectories. We will focus on key metrics such as Frechet distance, which measures the similarity between two trajectories, and other geometric operations that help quantify how closely different paths align.

This functionality is available in MySQL Community and Enterprise Editions and HeatWave MySQL.

Spatial trajectory data is becoming increasingly important in various fields, including transportation, ecology, sports analytics, and even human mobility studies. The ability to compare and measure the similarity of these trajectories can help in applications like identifying common travel patterns, detecting anomalies in movement, or optimizing routes based on historical data. A regular spatial data cleansing […]

​ In this blog post, we will walk through how to transform timestamped GPS points into trajectories represented as LINESTRING geometries in MySQL. This process is essential for applications like route analysis, traffic prediction, and path similarity measures. Using MySQL’s powerful spatial support, we can efficiently manage, process, and visualize GPS data.  This functionality is available in […]

Transforming GPS coordinates into trajectories in MySQL involves organizing raw GPS points (as POINT geometries) into ordered paths and converting them into LINESTRING geometries. This process uses MySQL's spatial functions like ST_Collect to aggregate points and requires ensuring proper ordering (e.g., by timestamp or sequence) to construct accurate routes.

This blog post explores how to transform spatial data between different Spatial Reference Systems (SRS) in MySQL using the ST_Transform function. It covers the syntax and usage of ST_Transform, and its practical applications in mapping and spatial analysis by using demonstrative examples. Whether you're visualizing geographic data or integrating datasets from various sources, understanding SRS transformation is key to accurate spatial analysis.