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
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. Percona Monitoring and Management (PMM) a free and open-source platform for managing and monitoring MySQL and… Continue reading Top 5 MySQL Monitoring Tools – 2020 Update
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
Tip of the day - Use EverSQL to automatically find redundant indexes and save cost, save storage and improve performance. #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… Continue reading Top 7 MySQL GUI Tools in 2020
Many of our users, developers and database administrators, keep asking our team about EverSQL's indexing recommendations algorithm. So, we decided to write about it. The first option is to use EverSQL to automatically find indexes that are best for your database. The second option is to read our detailed tutorial below and learn more about indexing best practices.… Continue reading Choosing the best indexes for MySQL query optimization
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
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
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