1. Home /
  2. MySQL

#MySQL

11 articles

MySQL Locks Explained: Preventing Deadlocks and Improving Performance
Database 2024-04-05

MySQL Locks Explained: Preventing Deadlocks and Improving Performance

Understand MySQL locking mechanisms—table locks, row locks, gap locks, and intent locks. Learn how deadlocks occur and how to prevent and diagnose them effectively.

#MySQL#Transaction#Lock
What is a Database Index? How It Works and When You Need It
Database 2024-04-01

What is a Database Index? How It Works and When You Need It

Understand how database indexes work internally—B-tree and hash structures—when to add or avoid indexes, and how to measure index effectiveness using EXPLAIN.

#DB#Index#MySQL
MySQL Transaction Isolation Levels: Preventing Dirty Reads, Phantom Reads, and More
Database 2023-06-08

MySQL Transaction Isolation Levels: Preventing Dirty Reads, Phantom Reads, and More

Learn MySQL's four transaction isolation levels, the anomalies each prevents (dirty read, non-repeatable read, phantom read), and how to choose the right level.

#Transaction#MySQL
Full-Text Search with MySQL
Database 2023-04-30

Full-Text Search with MySQL

Implement MySQL full-text search with FULLTEXT INDEX, ngram parsing, and MATCH...AGAINST query patterns.

#MySQL
Encountered 'Permission denied' Error When Starting MySQL Container on Ubuntu 20.04.2 LTS
Database 2021-09-12

Encountered 'Permission denied' Error When Starting MySQL Container on Ubuntu 20.04.2 LTS

Fix MySQL container permission denied errors on Ubuntu 20.04 by properly configuring docker-compose user UID/GID mappings.

#Ubuntu#MySQL#Tips
Cannot Start MySQL 8.0.17 Container on M1 Mac
Database 2021-09-05

Cannot Start MySQL 8.0.17 Container on M1 Mac

Fix the MySQL container startup failure on Apple M1 Mac (failed to create new OS thread errno=22). Use MySQL 8.0.26+ with --platform=linux/amd64 in the Dockerfile for ARM architecture support.

#Docker#Docker Compose#MySQL#M1#Tips
SQL for Generating Test Data in MySQL
Database 2019-07-16

SQL for Generating Test Data in MySQL

A note on generating test data using only MySQL.

#MySQL#SQL#Cross Join
Creating a mysqldump Tool with Go
Application 2019-02-04

Creating a mysqldump Tool with Go

Build a Go-based mysqldump tool for automated database backups from remote servers using SSH and TOML configuration files.

#Golang#MySQL#SSH#mysqldump
MySQL JOIN vs UNION: Differences, Use Cases, and Examples
Database 2018-07-18

MySQL JOIN vs UNION: Differences, Use Cases, and Examples

Learn the difference between MySQL JOIN and UNION with practical SQL examples. Covers INNER JOIN, LEFT JOIN, FULL OUTER JOIN, and how to combine result sets correctly.

#MySQL#join#union
No MySQL Driver After Installing PHP7
Infrastructure 2017-10-01

No MySQL Driver After Installing PHP7

Resolve PHP7 MySQL driver missing issues by installing php-mysqlnd package through REMI yum repository.

#CentOS#MySQL#PHP#PHP7#Sakura VPS#yum
MySQL 'MySQL Daemon failed to start' on Vagrant
Infrastructure 2017-10-01

MySQL 'MySQL Daemon failed to start' on Vagrant

Fix MySQL daemon startup failures in Vagrant by adjusting innodb_log_file_size and InnoDB configuration settings.

#MySQL#Vagrant#Tips