Forem

# 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.
Slow SQL? Diagnose & Fix Bottlenecks Fast!

Slow SQL? Diagnose & Fix Bottlenecks Fast!

Comments
6 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization
Cover image for Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

1
Comments
8 min read
How to Configure Docker Volumes for MySQL

How to Configure Docker Volumes for MySQL

3
Comments 1
1 min read
When Not to Use DB Indexes
Cover image for When Not to Use DB Indexes

When Not to Use DB Indexes

Comments
2 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference
Cover image for Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

5
Comments 1
4 min read
Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide
Cover image for Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

5
Comments
8 min read
New in Releem: Live MySQL Process List for Instantly Spotting Long Queries
Cover image for New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

5
Comments
2 min read
Beginner’s Guide to Designing a Relational Database Schema
Cover image for Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 min read
The Best Tools to Design Database Schemas Visually in 2025
Cover image for The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc

How to Speed Up Associations between Large Primary and Sub Tables with esProc

7
Comments 1
4 min read
MySQL vs MongoDB - Visual Design with Real Data Models
Cover image for MySQL vs MongoDB - Visual Design with Real Data Models

MySQL vs MongoDB - Visual Design with Real Data Models

11
Comments 2
5 min read
Master-Slave Replication and Read-Write Separation

Master-Slave Replication and Read-Write Separation

Comments 1
1 min read
How to get Bitcoin data and save it in MySQL using Spring Boot

How to get Bitcoin data and save it in MySQL using Spring Boot

Comments 1
4 min read
MySQL Performance Optimization
Cover image for MySQL Performance Optimization

MySQL Performance Optimization

1
Comments
10 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
Cover image for PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained
Cover image for MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL
Cover image for Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL

Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL

2
Comments
3 min read
Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)
Cover image for Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)

Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)

Comments
2 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually
Cover image for SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]
Cover image for Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

Comments
2 min read
Best ETL Tools for MySQL: A Guide to Free and Paid Solutions

Best ETL Tools for MySQL: A Guide to Free and Paid Solutions

Comments
3 min read
Do You Use SELECT * or Explicit Columns in Production Queries?

Do You Use SELECT * or Explicit Columns in Production Queries?

5
Comments 8
1 min read
Deploying Microsoft SQL Server on Railway

Deploying Microsoft SQL Server on Railway

Comments
1 min read
SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables
Cover image for SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables

SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables

1
Comments
4 min read
SQL Subqueries: Power Up Your Data Retrieval

SQL Subqueries: Power Up Your Data Retrieval

Comments
7 min read
loading...