Learn how to configure Zabbix monitoring of your MySQL/MariaDB database running on a Debian 12 host.
A walkthrough of how you may wish to gracefully handle the need to ingest a large amount of data into your database.
A tutorial on seeing how much benefit switching a barcode primary key to a BIGINT from a varchar binary representation.
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.
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.