Programster's Blog

Tutorials focusing on Linux, programming, and open-source

Zabbix - Monitor MySQL / MariaDB Database

Learn how to configure Zabbix monitoring of your MySQL/MariaDB database running on a Debian 12 host.

MySQL / PostgreSQL Table Double Buffering

A walkthrough of how you may wish to gracefully handle the need to ingest a large amount of data into your database.

MySQL Text Type

MySQL 8 - Slow Connecting Problem

MySQL - Using Barcodes As Primary Key

A tutorial on seeing how much benefit switching a barcode primary key to a BIGINT from a varchar binary representation.

Ubuntu 18.04 - Set MySQL Root Password

Set your root password in Ubuntu 18.04 for MySQL.

MySQL - Optimize For Minimal Memory

Configure your MySQL server variables for minimal memory usage rather than performance.

MySQL - Benchmarking Varchar vs Text

Results of benchmark the difference between using the TEXT and using a large VARCHAR. The results surprised me a lot.

MySQL Performance When Using UUID For Primary Key

Benchmarking the performance of using various UUID types as the primary key on database tables instead of an auto-incrementing integer.

PHP - Using UUID Instead of Auto Increment or Sequence

Learn how to use UUIDs in MySQL for your table IDs, rather than using auto_increment.

CentOS - Install MariaDB 5.5

Install MariaDB 5.5 on CentOS 7

MySQLi Prepared Statements

A brief tutorial on using prepared statements and their pros/cons.

MySQL GIS Cheatsheet

A cheatsheet for using GIS with MySQL

Selecting Data From Split Tables

A couple of examples of using joins or nested queries to select and combine data from multiple tables.

MySQL - Unique Key Across Tables

Can MySQL ensure that if a value is in one table, it doesn't exist in the other?

MySQL - Foreign Keys on Foreign Keys

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?

Debian 9 - Install MySQL Server

This tutorial will show you how to install various versions of MySQL server on Debian 9.

Set MySQL Timezone

MySQL Enums

MySQL - History Tables

MySQL Decimal

MySQL - Foreign Keys

MySQL Integer Types

Solving MySQL InnoDB Corruption

CentOS - Install MySQL Server

Debian 8 - Install MySQL 5.7

What's New In MySQL 5.7

MySQL 5.7 New JSON Functionality

Ubuntu 14.04 - Install MySQL 5.7

MySQL - Replace Statements

MySQL - Prevent Defaulting to Allow Defaults

MySQL Query Cheatsheet

A cheatsheet for MySQL queries.

MySQL Temprorary Tables

MySQL Configuration Variables

MySQL Partitions

Basic MySQL Commands

MySQL administration cheatsheet.

MySQL Left Joins

A tutorial on MySQL Left Joins

MySQL Timestamps Automatically Update

Debian - Move MySQL Database To Another Disk

Debian 8 - Install MySQL 5.6