Tag - SQL

binlog2sql: Binlog to Raw SQL Conversion and Point In Time Recovery

binlog2sql

In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode the MySQL binary logs and extract the raw SQL, which also helps to generate the ROLLBACK statements for point in time recovery (PITR) using the “flashback” feature. This feature is also implemented in MariaDB’s […]

Read more

SQL Query Formatting Tools Used At Percona

SQL Query Formatting Tools

Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug.
Online query formatting services provide one set of solutions. Examples are Code Beautify, FreeFormatter, and sqlformat.org. However, many […]

Read more

Becoming Familiar With the Little Known SQL Keyword LATERAL

SQL Keyword Lateral

Working on a weekend project,  I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14,  so I wanted to share how it can be used.
Some references on this topic:
Lateral Derived Tables
LATERAL Derived Tables in MySQL 8.0
The keyword “LATERAL” comes into play […]

Read more

What’s Next for SQL Databases?

SQL Databases

In this blog, I’ll go over my thoughts on what we can expect in the world of SQL databases.
After reading Baron’s prediction on databases, here:
https://www.xaprb.com/blog/defining-moments-in-database-history/
I want to provide my own view on what’s coming up next for SQL databases. I think we live in interesting times, when we can see the beginning of the next-generation […]

Read more

Query Language Type Overview

super_read_only system variable

This blog provides a query language type overview.
The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and abbreviations because it’s efficient. It’s no different in the database world. Much […]

Read more