Alena Subotina    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...

MySQL Performance 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...

Oracle MySQL Group    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...

Oracle MySQL Group    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 ...

Oracle MySQL Group    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...

Oracle MySQL Group    MySQL . . has introduced a new dynamic privilege: CREATE SPATIAL REFERENCE SYSTEM. This privilege enables users to create, replace, and drop custom spatial reference systems SRS , allowing for greater spatial data customization across MySQL environments without needing SUPER access. In this post...

Oracle MySQL Group    The MySQL Connection Control Component allows database administrators to enforce limits on client connections based on frequency and behavior. It is especially useful in preventing denial of service DoS attacks, mitigating resource exhaustion, and regulating access during high load scenarios.

MySQL Performance Blog    What index will be used when you count all rows in a table Well, the MySQL documentation provides a straightforward answer to this, quoting: InnoDB processes SELECT COUNT statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to...

Oracle MySQL Group    MySQL January GA Releases Now Available

Chandan Kumar   

Chandan Kumar   

Oracle MySQL Group    was a productive year for HeatWave MySQL product line with many important enhancements in several areas. We achieved critical milestones in areas of availability, disaster recovery, performance, system management, operations and productivity. Let’s take a look some of the key features.

Oracle MySQL Group    The financial services industry is facing a new regulation: the Digital Operational Resilience Act DORA . One of the key requirements of DORA is that financial institutions must have a robust riskmanagement framework in place. This framework must identify, assess, and mitigate ICT risks. MySQL...

Oracle MySQL Group    This blog shows how HeatWave MySQL delivers substantially more value than the MySQL cloud services offered by AWS, Google Cloud, and Azure. Furthermore, not only can you power your OLTP applications using HeatWave MySQL but you also get built in lakehouse scale analytics, generative AI, and machine...

Oracle MySQL Group    The JetBrains Developer Ecosystem Report reaffirms what millions of developers already know MySQL is the database. According to the report, MySQL continues to be the most widely used database, favored by developers across various domains for its reliability and ease of use.

Oracle MySQL Group    Advent Calendar Recap

Oracle MySQL Group    PCI DSS . Compliance and MySQL

Frederic Descamps    The preFOSDEM MySQL Belgian Days will occur at the usual place ICAB Incubator, Belgium, Bruxelles on Thursday, January th, and Friday, January st, just before FOSDEM. Again this year, we will have the chance to have incredible sessions from our Community and the opportunity to meet...

Oracle MySQL Group    This is the agenda of the preFOSDEM MySQL Belgian Days , an Oracle MySQL technical event managed by the MySQL Community Team for customers, partners amp; community users.

MySQL Performance Blog    This article will be helpful if you use the Percona Monitoring and Management PMM instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when receiving the alert notification email...

MySQL Performance Blog    Here is part two of my MySQL with Diagrams series Here’s part one MySQL with Diagrams Part One: Replication Architecture . We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you...

Dave Stokes    Did you ever need to determine the performance of a query over time One of the problems with database query optimizations is that the underlying data is always churning. Add in an increase in the number of users, expanding server demand use, and other items that impact your query. What was...

MySQL Performance Blog    At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL . .x and .y versions caught our attention, as highlighted in Marco Tusa’s insightful blog post, Sakila, Where...

Daniel Nichter    Used to be that replication lag was as simple as Seconds Behind Master renamed to Seconds Behind Source . But with multi threaded replication MTR this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables.