At some points, many of our customers need to handle insertions of large data sets and run into slow insert statements. This article will try to give some guidance on how to speed up slow INSERT SQL queries. The following recommendations may help optimize your data loading operations: Remove existing indexes - Inserting data to… Continue reading How to optimize slow INSERT queries in MySQL

#1 - SnowSQL CLI client SnowSQL is the command-line client to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of snowflake tables. Pros: SnowSQL can be run as an interactive shell or in batch mode through stdin or using the -f option. Supports Windows, Mac and Linux You can… Continue reading Top 9 Snowflake Productivity Tools in 2021

Google Cloud launched an advanced database performance tool (Cloud SQL Insights), allowing you to closely monitor the database performance and identify potential performance issues. Many Google Cloud SQL users have waited for it for a long time, as both AWS and Azure already offer similar products for a while. AWS RDS Performance Insights is available… Continue reading Better Database Performance with Google Cloud SQL Insights

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 [2021]

Companies have more data in today's world, and queries that took a few seconds might take a few minutes or even hours. 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… Continue reading Top 5 SQL Optimization Tools in 2021

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

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 [2021 review]

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