Showing entries 11 to 20 of 43924
« 10 Newer Entries | 10 Older Entries »
Transforming GPS data into trajectories using MySQL

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.

Transformations between Spatial Reference Systems in MySQL

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.

Introducing the new CREATE_SPATIAL_REFERENCE_SYSTEM privilege in MySQL

MySQL 9.2.0 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, we’ll explain the use of this privilege and provide an example to demonstrate its application. The new privilege is available in MySQL Community and Enterprise Editions and HeatWave MySQL.

Introducing the Connection-Control Component in MySQL 9.2 : A Powerful Tool for Connection Management

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.

What’s the Cost of Counting MySQL Table Rows?

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 use a different index. If a secondary index is […]

MySQL January 2025 GA Releases Now Available

MySQL January 2025 GA Releases Now Available

How can I Disable MySQL Audit Log while Server is running?
Trace client applications connection made through MySQL Router to MySQL Enterprise Instance
2024 Recap: Key Innovations and Enhancements in HeatWave MySQL

2024 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.

How MySQL Enterprise Edition Can Help Your Organization Achieve DORA Compliance

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 Enterprise Edition can help organizations achieve DORA compliance byproviding a number of features that can help to identify, assess, and mitigate ICT risks.

Showing entries 11 to 20 of 43924
« 10 Newer Entries | 10 Older Entries »