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
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
This post's contentJOIN EliminationUnneeded Self JOINPredicate PushdownWrapping up 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… Continue reading Re-evaluating MySQL 8 Query Transformations Capabilities
This post's contentMonitoring and Optimizing Slow SQL QueriesOptimization InternalsWrapping up 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… Continue reading Optimize Slow Queries with RDS Performance Insights & EverSQL
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
This post's contentThe query and database structureExplaining the original EXPLAINOptimizing a slow query using MySQL's EXPLAINThe optimized query's EXPLAIN outputConclusions 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… Continue reading MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data
This post's contentFROM and JOINsWHERE clauseGROUP BY clauseHAVING clauseWindow functionsSELECT clauseDISTINCT keywordUNION keywordORDER BY clauseLIMIT and OFFSET 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.… Continue reading SQL Order of Operations – In Which Order MySQL Executes Queries?
This post's contentIntroductionWho is using MySQL and MariaDB?Comparing features - MySQL vs MariaDBPerformance & BenchmarkingReplicationIncompatibilities between MySQL and MariaDBStorage enginesDeployed on Linux distributions by defaultAvailability on cloud platformsLicensingRelease-rate and updatesTechnical SupportOngoing DevelopmentSQL Query OptimizationConclusions Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database… Continue reading MariaDB vs MySQL – Key Differences – Comparing MySQL 8.0 with MariaDB 10.5
This post's contentOptimize QueriesCreate optimal indexesGet a stronger CPUAllocate more memoryData defragmentationDisk Types Database version Summary In many cases, developers, DBAs and data analysts struggle with bad application performance and are feeling quite frustrated when their SQL queries are extremely slow, which can cause the entire database to perform poorly. Luckily, there is a solution… Continue reading Top 5 Ways To Improve Your Database Performance
This post's contentBasic SQL trainingSQL Advanced trainingPerformance oriented trainingHighly Recommended Performance Related Books Imagine how spider-man's life would look like if he had never find out that he can shoot webs from his wrist... Not a good starting point, isn't it? Sometimes one can learn to write SQL queries but miss critical functionalities and important… Continue reading Top 7 ways to learn to write better and faster SQL queries?