Introducing Metabase, a Simple and Powerful Analytics Tool

metabase

Recently I was looking for some simple way to analyze and create graphs from data stored in MySQL tables. I know Grafana can also plot graphs from MySQL tables, but somehow it felt like overkill and you are not using the traditional SQL syntax there. So I was searching for another solution, and it […]

Read more

Tips for MySQL 5.7 Database Tuning and Performance

MySQL 5.7 Database Tuning

While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical […]

Read more

#PerconaChat — 5 Essential Practices for Remote Working

perconachat

Percona recently hosted a #PerconaChat to discuss and share some of the things we find most essential to be successful while working remotely. Even before the viral outbreak, Percona was an almost 100% remote company, so it was great to be able to impart some of our learnings.
David Busby — Information Security Analyst, Percona, […]

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