Returning random rows in a random order from a relational database is a very hard problem. In this article we will see an antipattern, we will discuss why this problem is so hard, and we’ll examine some imperfect solutions.
One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return …
There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems.
How to find useless indexes and get rid of them to improve your database performance.
When creating indexes, some common mistakes should be avoided.
How primary key are implemented in InnoDB, and how to build fast primary keys.
MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.
Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.
Do you want to improve your application’s and database server’s performance? Remove useless queries. Yes, you probably have them.
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.