EmergencyEMERGENCY? Get 24/7 Help Now!

What’s Next for SQL Databases?

 | March 27, 2017 |  Posted In: MySQL

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 […]

Read More

Query Language Type Overview

 | December 29, 2016 |  Posted In: MySQL, Solutions Engineering

Query Language Type

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 of […]

Read More

Oracle license revenue and the MySQL ecosystem

 | June 25, 2015 |  Posted In: 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 software responsible for the bulk of it. Things are especially […]

Read More

5 free handy tools for monitoring and managing MySQL replication

 | March 9, 2015 |  Posted In: MySQL, Percona Software, Percona Toolkit

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 instance to another slave instance and maintaining the redundant consistent data in a different […]

Read More

WITHer Recursive Queries?

 | February 11, 2014 |  Posted In: 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. SQLite, another popular open-source SQL database, just released version 3.8.3, including support […]

Read More

MySQL Query Patterns, Optimized – Webinar questions followup

 | June 3, 2013 |  Posted In: Insight for Developers, MySQL, Technical 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 answered as many as we had time for  during the session, but here […]

Read More

Analyzing Slow Query Table in MySQL 5.6

 | February 18, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Toolkit

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 saw the GA release of MySQL 5.6, and I wanted to check if any […]

Read More