Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious.
Read morePractical advice for MySQL/MariaDB live migrations
Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production.
Read moreUnderstanding tables usage with User Statistics (Percona Server, MariaDB)
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.
Read moreMySQL/MariaDB: Using views to grant or deny row-level privileges
Relational DBMSs allow to grant users permissions on certain tables or columns. Here we’ll discuss how to restrict access to a certain set of rows.
Read moreThe dangers of replication filters in MySQL
MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you’ll find out the risks, and how to mitigate them.
Read moreForeign Key bugs in MySQL and MariaDB
Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.
Read moreCase sensitivity in MySQL and MariaDB queries
Maybe you’re wondering why in MySQL/MariaDB ‘string’ seems to be the same as ‘STRING’. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case …
Read moreREAD ONLY transactions in MySQL
MySQL transactions can be read only. Here’s how to use them, and why they are useful.
Read moreWhy MySQL tables need a primary key
In MySQL and MariaDB, all tables should have a primary key – especially InnoDB tables – this is almost common wisdom. But why? Let’s discuss the reasons.
Read moreMySQL/MariaDB: use SQL properly to run less queries
Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.
Read more