(Vlad Mihalcea) In this article, we are going to see how we can limit the SQL query result set to the Top-N rows only.

(Marco Tusa) To set correct system variable values is the essential step to get the correct server behavior against the workload.

(Meenakshi Agarwal) This tutorial explains how you can grant privileges on a database in MySQL. It will introduce you all the steps beginning from connecting to MySQL and then accessing the MySQL commands to set the desired level of privileges.

(Frederic Descamps) When somebody wants to migrate from a single MySQL instance to a full HA solution using MySQL InnoDB Cluster, the best solution to reduce the downtime is to use asynchronous replication and switch database only once at a certain point in time when everything is ready.

(Meenakshi Agarwal) This tutorial explains how to use the MySQL FROM_UNIXTIME() function with the help of examples.

(Krzysztof Ksiazek) Migrations between different environments are uncommon in database world. Migrations from one provider to another one. Moving from one datacenter to another.

(Gurnish Anand) Late one evening, I was staring at one of our large MySQL installations and noticed the database was hovering around 7-10 run queue length (48 cores, ~500 gigs memory, fusionIO cards).

(Federico Razzoli) In MySQL and MariaDB, all tables should have a primary key – especially InnoDB tables. I mentioned this in several articles, see Primary Key in InnoDB: how they work and best practices.

(Meenakshi Agarwal) This tutorial explains about MySQL UPSERT command with the help of simple examples. An upsert is a smart operation which turns into INSERT or UPDATE whichever is applicable.

(Robert Agar) In the complicated world of database management, a lot of data needs to be assimilated by those responsible for keeping the systems healthy and operational.