by Sri Sakthivel | Jul 9, 2020 | Insight for DBAs, MySQL
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....
by Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
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...
by Vadim Tkachenko | Mar 31, 2020 | MySQL
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...
by Vadim Tkachenko | Mar 27, 2017 | MySQL
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...
by Dimitri Vanoverbeke | Dec 29, 2016 | MySQL
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...
by Jim Doherty | Jun 25, 2015 | MySQL
Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source...
by Arunjith Aravindan | Mar 9, 2015 | MySQL, Percona Software
MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master...
by Bill Karwin | Feb 11, 2014 | Insight for Developers, MySQL
Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features....
by Bill Karwin | Jun 3, 2013 | Insight for Developers, MySQL, Webinars
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Bill Karwin | Feb 18, 2013 | Insight for DBAs, MySQL, Percona Events, Percona Software
Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit. This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we...
