Planet MySQL HA Blog

Bridging natural language processing with semi-structured data brings both opportunity and complexity.

MySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues.

By creating well-structured views that reveal JSON’s internal organization, you can transform unstructured data into a relational format the model understands — improving both query accuracy and overall usability.

This approach…

Learn More »

Discover how to tame big tables using LIMIT and OFFSET in MySQL! This post makes pagination easy for newcomers, using friendly library metaphors, step-by-step SQL examples, and practical tips to help you view your data one page at a time.

Learn More »

We are excited to announce the release of Natural Language to SQL (NL2SQL) capability for MySQL (with the AI option) and MySQL HeatWave cloud service. Natural language interface is essential for modern data platforms, allowing users to explore information more quickly.

Learn More »

Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required!

Learn More »

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance.

Learn More »

MySQL is still the workhorse behind modern applications. From SaaS platforms to e-commerce, it powers the transactional data that businesses rely on. As more organizations adopt Kubernetes for its promise of portability, automation, and infrastructure efficiency, it’s natural to want MySQL to live alongside the rest of the stack. Running databases as containers is appealing: one control plane, unified pipelines, and elastic scaling.

But while Kubernetes makes stateless services almost effortless, MySQL exposes the limits of that model. Persistence, replication, and…

Learn More »

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes.

Learn More »

In my first post on the MySQL 8.4 Audit Log Filter component, I covered how to install the component and configure a basic filter that captures all events. The Audit Log Filter framework offers a highly granular and configurable auditing mechanism, enabling administrators to log specific events based on criteria such as user, host, or event type. This selective approach enhances observability, supports compliance initiatives, and minimizes unnecessary logging overhead.

Learn More »

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence!

Learn More »

Having explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]

The post Let Your AI DBA Assistant Write Your MySQL Queries first appeared on dasini.net - Diary of a MySQL expert.

Learn More »