Optimize Slow Queries with RDS Performance Insights & EverSQL

In today's tech companies, engineers are expected to know and care more about the database and the performance of their application. To effectively face these challenging requirements, DBA, engineering and DevOps teams need the right tools to monitor, diagnose and resolve performance issues. In this post, I'll demonstrate how one can track down slow SQL… Continue reading Optimize Slow Queries with RDS Performance Insights & EverSQL

MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data

I personally believe that the best way to deliver a complicated message to an audience, is by using a simple example. So in this post, I chose to demonstrate how to obtain insights from MySQL's EXPLAIN output, by using a simple SQL query which fetches data from StackOverflow's publicly available dataset. The EXPLAIN command provides… Continue reading MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data

MariaDB vs MySQL – Key Differences – Comparing MySQL 8.0 with MariaDB 10.5

Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL… Continue reading MariaDB vs MySQL – Key Differences – Comparing MySQL 8.0 with MariaDB 10.5

Most popular databases in 2018 according to StackOverflow survey

The survey results from StackOverflow's developers survey are already here, and we can now declare the most popular databases for 2018. Without further ado, let's look into the results: So what can we learn from these results? The most popular database is MySQL, and not by far comes SQL Server. This wasn't very surprising, as… Continue reading Most popular databases in 2018 according to StackOverflow survey