Browsing Category
MySQL
65 posts
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the acronym for Structured Query Language.
How to Perform Data Transformation in MySQL Database
Somewhere along the way, I stopped thinking of SQL as just a way to fetch data and started…
How to Use MySQL Database with WebSocket
The first time I built a “real-time” feature backed by MySQL, I made the classic beginner mistake: I…
How to Create and Manage MySQL Partitions
If you’ve ever watched a query crawl through a 200-million-row table when it only needed 50,000 rows, you…
How to Set up MySQL Database Cluster
The first time I had to explain to a client why their single MySQL server going down took…
How to Use MySQL Database with Docker
I resisted Docker for database work longer than I should have. My reasoning was that databases are stateful,…
How to Perform Geospatial Queries in MySQL Database
I got into geospatial queries the practical way — a client needed a “find stores near me” feature,…
How to Migrate Data to MySQL from Other Databases
Every migration I’ve ever done has taught me the same lesson: the actual data transfer is rarely the…
How to Monitor and Optimize InnoDB in MySQL Database
There was a period where I treated InnoDB like a black box — data went in, queries came…
How to Create and Manage MySQL Functions
I used to push almost all of my logic into application code, treating the database as a dumb…
How to Use the LIMIT Clause in MySQL Database
The LIMIT clause is one of the first things anyone learns in MySQL, and also one of the…