A tutorial on seeing how much benefit switching a barcode primary key to a BIGINT from a varchar binary representation.
Set your root password in Ubuntu 18.04 for MySQL.
Configure your MySQL server variables for minimal memory usage rather than performance.
Results of benchmark the difference between using the TEXT and using a large VARCHAR. The results surprised me a lot.
Benchmarking the performance of using various UUID types as the primary key on database tables instead of an auto-incrementing integer.
Learn how to use UUIDs in MySQL for your table IDs, rather than using auto_increment.
Install MariaDB 5.5 on CentOS 7
A brief tutorial on using prepared statements and their pros/cons.
A cheatsheet for using GIS with MySQL
A couple of examples of using joins or nested queries to select and combine data from multiple tables.
Can MySQL ensure that if a value is in one table, it doesn't exist in the other?
Can you create a foreign key that references a column in another table that itself is a foreign key that references a column in another table?
This tutorial will show you how to install various versions of MySQL server on Debian 9.
A cheatsheet for MySQL queries.
MySQL administration cheatsheet.
A tutorial on MySQL Left Joins