DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

1
Comments
4 min read
MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

2
Comments
4 min read
20 Essential MySQL Optimization Tips for Better Database

20 Essential MySQL Optimization Tips for Better Database

Comments
5 min read
How to Create Indexes in MySQL: A Complete Guide

How to Create Indexes in MySQL: A Complete Guide

Comments
5 min read
MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

Comments
8 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Comments
4 min read
MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

Comments
2 min read
Setup Nginx and MySQL with Vagrant

Setup Nginx and MySQL with Vagrant

Comments
5 min read
OpenAI's testament to Postgresql reliability

OpenAI's testament to Postgresql reliability

Comments
7 min read
AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

Comments
3 min read
Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Comments
4 min read
Releem 2025 Recap: Building a Database Advisor for Developer Teams

Releem 2025 Recap: Building a Database Advisor for Developer Teams

5
Comments
2 min read
Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

Comments
7 min read
MariaDB doesn't depend on MySQL

MariaDB doesn't depend on MySQL

2
Comments
5 min read
MySQL backup best practices — 12 essential strategies for MySQL backup and recovery

MySQL backup best practices — 12 essential strategies for MySQL backup and recovery

Comments
11 min read
Ubuntu 24.04 Setup Script: Nginx/Apache, PHP-FPM, MySQL/MariaDB, Docker, UFW

Ubuntu 24.04 Setup Script: Nginx/Apache, PHP-FPM, MySQL/MariaDB, Docker, UFW

Comments
7 min read
How POSTGRES indexing is more efficient than MYSQL

How POSTGRES indexing is more efficient than MYSQL

1
Comments
2 min read
MySQL backup and restore — Complete guide to MySQL database backup strategies in 2026

MySQL backup and restore — Complete guide to MySQL database backup strategies in 2026

Comments 1
8 min read
🚀 AWS 131: Scalable Data - Provisioning Private RDS with Storage Autoscaling

🚀 AWS 131: Scalable Data - Provisioning Private RDS with Storage Autoscaling

Comments
3 min read
MySQL backup and restore — Complete guide to MySQL database backup strategies in 2026

MySQL backup and restore — Complete guide to MySQL database backup strategies in 2026

Comments
7 min read
Zero Cost, Infinite Possibility: Jumpstart Your AI Journey with Google Cloud’s Free Database Trials

Zero Cost, Infinite Possibility: Jumpstart Your AI Journey with Google Cloud’s Free Database Trials

Comments
3 min read
SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

Comments
5 min read
Node.js + Fastify + Sequelize + MySQL

Node.js + Fastify + Sequelize + MySQL

Comments
16 min read
🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

1
Comments
2 min read
Headless Raspberry Pi Homelab – Part 3: SSH & MariaDB (MySQL Compatible) Installation

Headless Raspberry Pi Homelab – Part 3: SSH & MariaDB (MySQL Compatible) Installation

Comments
2 min read
loading...