How to Save on AWS RDS MySQL Costs by Instance Right-sizing

December 5, 2019

Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application. In most cases, the incentive to right-size your database instances will be to lower the cloud infrastructure’s costs, ideally without compromising on performance. In this post we’ll guide you through how to analyze the instance’s… Continue reading How to Save on AWS RDS MySQL Costs by Instance Right-sizing

EverSQL and GitHub to launch a new partnership for students

November 4, 2019November 4, 2019

We are excited to announce that EverSQL and GitHub have launched a new partnership as a part of the GitHub Student Developer Pack, which offers valuable free software licenses to students. We believe that there's no substitute for hands-on experience. For most students, real-world tools can be cost-prohibitive. That's why partnered with GitHub: to give… Continue reading EverSQL and GitHub to launch a new partnership for students

Visualize and Optimize Slow SQL Queries on Google Cloud SQL

September 3, 2019

Analyze slow queries from Google Cloud SQL instances The new enhancement for our Chrome extension will allow Google Cloud SQL and EverSQL users to automatically visualize MySQL's slow query log entries directly on the log viewer of Google Stackdriver. No configuration is needed other than configuring your database to actually log slow queries. EverSQL's extension… Continue reading Visualize and Optimize Slow SQL Queries on Google Cloud SQL

Analyzing MySQL Slow Query Logs Online

August 1, 2019

From time to time, you might notice that your MySQL database suddenly under-performs. To quickly locate the root cause, one might start digging into MySQL slow query logs, trying to locate the query(ies) taking up the server's resources. Those slow log files contain lots of metrics for each query execution, which can be overwhelming, especially… Continue reading Analyzing MySQL Slow Query Logs Online

Re-evaluating MySQL 8 Query Transformations Capabilities

May 23, 2019

I recently stumbled upon a very interesting post by Lukas Eder, where he describes 10 query transformations which do not depend on the database’s cost model. He posted it a couple of years ago, though when I read it, I assumed some portions of it may still be relevant today. In the original post, several… Continue reading Re-evaluating MySQL 8 Query Transformations Capabilities

Optimize Slow Queries with RDS Performance Insights & EverSQL

March 13, 2019March 13, 2019

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 8.x Adoption Rate – Survey Results

January 8, 2019

An exciting feature-full new version of MySQL (v8.x) was released on April 2018. Along with those exciting features, there were many changes and enhancements done in MySQL's internal optimizer. Naturally, we at EverSQL keep an eye on major changes in MySQL's optimizer, to make sure we are familiar with them and co-exist with them. So… Continue reading MySQL 8.x Adoption Rate – Survey Results

MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data

October 1, 2018October 1, 2018

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

SQL Order of Operations – In Which Order MySQL Executes Queries?

September 21, 2018October 1, 2018

Knowing the bits and bytes of an SQL query's order of operations can be very valuable, as it can ease the process of writing new queries, while also being very beneficial when trying to optimize an SQL query. If you're looking for the short version, this is the logical order of operations, also known as… Continue reading SQL Order of Operations – In Which Order MySQL Executes Queries?

SQL Query Optimization: Top 5 Tips for Modern Query Optimization

September 11, 2018November 13, 20193 Comments

This is the first part of our SQL query optimization articles series. In this article, we'll focus on how to optimize MySQL queries, but the same concepts can be applied to many other relational databases. Now more than ever, software engineers need to have vast knowledge in SQL query optimization. The shift is happening in… Continue reading SQL Query Optimization: Top 5 Tips for Modern Query Optimization