Programster's Blog

Tutorials focusing on Linux, programming, and open-source

MySQL

Basic MySQL Administration

MySQL administration cheatsheet.

MySQL ZFS

ZFS + HTML Demonstration Video

A video demonstrating the use of ZFS to snapshot and restore a MySQL database in seconds and why this is useful.

MySQL monitoring MariaDB Zabbix

Zabbix - Monitor MySQL / MariaDB Database

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

MySQL PostgreSQL

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

MySQL Text Type

MySQL

MySQL 8 - Slow Connecting Problem

MySQL

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.

MySQL

Ubuntu 18.04 - Set MySQL Root Password

Set your root password in Ubuntu 18.04 for MySQL.

MySQL

MySQL - Optimize For Minimal Memory

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

MySQL benchmarking

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 UUID

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.

MySQL PostgreSQL UUID PHP

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.

MySQL MariaDB CentOS-7

CentOS - Install MariaDB 5.5

Install MariaDB 5.5 on CentOS 7

MySQL PHP

MySQLi Prepared Statements

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

MySQL GIS

MySQL GIS Cheatsheet

A cheatsheet for using GIS with MySQL

MySQL table-joins

Selecting Data From Split Tables

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

MySQL

MySQL - Unique Key Across Tables

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

MySQL

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?

MySQL Debian stretch

Debian 9 - Install MySQL Server

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

MySQL

Set MySQL Timezone

MySQL enum

MySQL Enums

MySQL

MySQL - History Tables

MySQL

MySQL Decimal

MySQL foreign-keys

MySQL - Foreign Keys

MySQL

MySQL Integer Types

MySQL

Solving MySQL InnoDB Corruption

MySQL MariaDB CentOS-7

CentOS - Install MySQL Server

MySQL

Debian 8 - Install MySQL 5.7

MySQL

What's New In MySQL 5.7

MySQL JSON

MySQL 5.7 New JSON Functionality

MySQL

Ubuntu 14.04 - Install MySQL 5.7

MySQL

MySQL - Replace Statements

MySQL

MySQL - Prevent Defaulting to Allow Defaults

MySQL

MySQL Query Cheatsheet

A cheatsheet for MySQL queries.

MySQL

MySQL Temprorary Tables

MySQL MariaDB

MySQL Configuration Variables

MySQL

MySQL Partitions

MySQL

Basic MySQL Administration

MySQL administration cheatsheet.

MySQL table-joins sql left-join

MySQL Left Joins

A tutorial on MySQL Left Joins

MySQL timestamp

MySQL Timestamps Automatically Update

Debian MySQL

Debian - Move MySQL Database To Another Disk

Debian MySQL mysql-5.6

Debian 8 - Install MySQL 5.6

Programster's Blog Ⓒ 2024