We all love MySQL and want to make sure that our apps work seamlessly. However, there are hopes and there is reality. So in this article, we have decided to list the top 5 MySQL monitoring tools. #1: EverSQL EverSQL provides a different type of MySQL monitoring solution, mainly focused on tracking and automatically optimizing slow… Continue reading Top 5 MySQL Monitoring tools 2020
It’s all about focus and cost control, especially during corona crazy days. We liked Aaron Levie’s post which is true both for startups and for well-established companies: Startups: 1. Make sure your strategy is setup for the world we’ve entered 2. Focus; cut the side projects 3. Control costs 4. Communicate constantly and protect your… Continue reading 6 Quick Ways To Reduce Your AWS Spending During Corona Time
In this article, we'll focus on the easiest and best tips developers can implement for their day-to-day SQL performance tuning efforts. This article will focus on MySQL queries performance tuning, 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… Continue reading SQL Performance Tuning: 5 Best Tips for Developers
#1 - DBeaver Pros: Multi-Platform Databases Intuitive and very easy to use user interface. Free to download, licensed under GPL. You can Render ERDs to visual your database Easy Import/Export/Backup Mock Data Generator NoSQL and BigData database support (Enterprise Edition Only) Visual Query Builder (Enterprise Edition Only) Analytical charts (Enterprise Edition Only) Query History (Enterprise Edition Only) Cross-platform… Continue reading Top 7 MySQL GUI Tools in 2020
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
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
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
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
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