Companies have more data in today's world, and queries that took a few seconds might take a few minutes. If you have a complex SQL query and looking for an automated tool that will help you, we tested the most popular tools and created this article for you. Here is a list of the top… Continue reading Top 5 SQL Optimization Tools in 2020
So you thought your database is in good shape, but suddenly your CPU usage spiked and reached 100% at 2AM. How would you go about tracking the root cause and fix it? 1. Locate the root cause If you are using CloudWatch or any infrastructure monitoring solution, you can start your investigation there. To understand… Continue reading How to Fix MySQL High CPU Usage?
In this post, we will quickly demonstrate how to enable Slow Query Log on Google Cloud SQL for MySQL. Open Cloud SQL Dashboard Click Edit on your Database Add 3 flags (a.k.a. configuration parameters) to your instance: log_output - file / table / none We recommend to choose file, which will help you to quickly visualize… Continue reading How to enable slow query log on Google Cloud SQL for MySQL
PostgreSQL allows logging slow queries to a file, with a configured query duration threshold. Parsing the slow log with tools such as EverSQL Query Optimizer will allow you to quickly locate the most common and slowest SQL queries in the database. You can optimize these queries automatically using EverSQL Query Optimizer. Enabling PostgreSQL Slow Query Log… Continue reading How to enable slow query log in PostgreSQL [2020]
Background Hibernate is an open-source project sponsored by RedHat. One of its commonly used components is the Hibernate Object-relational mapping (ORM) which helps developers access databases using an object-oriented approach. Hibernate is helping developers achieve consistency and persistence in their application, using the data language and objects the developers are already familiar with. Hibernate ORM… Continue reading Hibernate ORM 5 – Pros, Cons, and how to fix performance problems [July 2020 review]
We heard this from many of our customers, so we have decided to write a quick cheat sheet about query performance in WordPress v5.4.1 and the WP_Query function. If you have a lot of data or a complex application, WordPress may run some of queries quite slowly. After we analyzed several customers' use cases, we… Continue reading How to fix WordPress performance issues in 5 minutes
What can you learn about 2020 database trends from StackOverflow's latest survey? The survey results from StackOverflow's developers survey are already here, and we can now declare the most popular databases for 2020. Without further ado, let's look into the results: So what can we learn from these results? The most popular database is MySQL,… Continue reading Most popular databases in 2020 and new trends
We are excited to announce that EverSQL is now an official New Relic partner. We believe that software engineers around the globe are artists, and they aspire to create perfect software. That's why partnered with New Relic: to give developers AI insights about their database performance and to help them optimize their slowest SQL Queries.… Continue reading EverSQL is now an official New Relic partner
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
Why Debug MySQL? Building MySQL from its source code sounds like something you won't normally do, though it can be useful for several scenarios: When you want to contribute to MySQL with a new feature or a bug fix. When you want to explore how MySQL or the underline engines behave, beyond what's documented. When… Continue reading Why We’re Debugging MySQL Server and How?