Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL… Continue reading MariaDB vs MySQL – Comparing MySQL 8.0 with MariaDB 10.3
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 to this problem! In this article, we will briefly cover a few ways you can use… Continue reading 5 Easy Ways To Improve Your Database Performance
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 features, which can change their day-to-day life and save them significant amount of… Continue reading What’s the best way to learn to write better and faster SQL queries?
The survey results from StackOverflow's developers survey are already here, and we can now declare the most popular databases for 2018. Without further ado, let's look into the results: So what can we learn from these results? The most popular database is MySQL, and not by far comes SQL Server. This wasn't very surprising, as… Continue reading Most popular databases in 2018 according to StackOverflow survey
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. This tutorial won't detail all the internals of the algorithm, but rather try to lay down the basic and important aspects of indexing, in simple terms. Also, and most importantly, we'll… Continue reading Choosing the best indexes for MySQL query optimization
Migrating a MySQL database usually requires only few simple steps, but can take quite some time, depending on the amount of data you would like to migrate. The following steps will guide through how to export the MySQL database from the old server, secure it, copy it to the new server, import it successfully and… Continue reading How to Transfer a MySQL Database Between Two Servers?
What is a median value? The median of an array of numbers is the value of the middle item in the array, assuming the array is sorted. If the array has an even number of items, the median represents the average of the two middle values in the array. This value is very popular one… Continue reading How to calculate median value in MySQL using a simple SQL query
This post is based on a true story from one of our team members. Here at EverSQL, we have high appreciation for the MySQL database. Said that, every product has its pros and cons and even some bugs here and there. So let's dive into how we used some "bad practices" to overcome a potential… Continue reading MySQL is not using my index – Join with a range condition
Queries with LIMITs and OFFSETs are common in application that require pagination and in some cases might work well for a while. In many cases though, they become slow and painful once the OFFSET has a high value. Why OFFSET is so slow? Well, in most cases, low offset queries are not slow. The problem… Continue reading Faster Pagination in Mysql – Why Order By With Limit and Offset is Slow?
The Story of UTF8 VS UTF8MB4 I once got a call from the support team, saying that one of our customers reported that the application fails to save data in one of our business-critical features. The customer is seeing a general error from the application. About 30 of his 500 users are experiencing this issue… Continue reading MySQL utf8 vs utf8mb4 – What’s the difference between utf8 and utf8mb4?