Kalidasan·Sep 3MySQL in a Weekend: Performance, JSON, Backups, and Running It for Real (Part 3)The closing course in the series — making slow queries fast, storing data that doesn’t fit neat columns, not losing everything to a bad…
Kalidasan·Sep 3MySQL in a Weekend: Transactions, Subqueries, and Real-World Access Control (Part 2)Picking up where Part 1 left off — the same bookshop database, now handling multi-step changes, harder questions, and more than one user.
Kalidasan·Sep 2MySQL in a Weekend: Databases, Tables, and Queries (Part 1)A hands-on path from “what’s a database” to writing joins and aggregates with confidence — no prior SQL experience needed. This is the…
Pavel Polikov·Aug 30Monitoring CPU and RAM pressure caused by queries on the MySQL/MariaDB server.Script goal: “Monitoring CPU and RAM pressure caused by queries on the MySQL/MariaDB server”
Nikita Nikumbh·Aug 20Upgrading Amazon RDS MySQL 8.0 to 8.4 Using a Snapshot-Based ApproachUpgrading a production database is always something that needs to be approached carefully. Unlike a normal application deployment, a…
Chimin·Aug 730 Practical MySQL Key NotesWhen I first learned MySQL, I studied connections, character sets, pages, indexes, transactions, and locks as separate topics. When I…
Pruthwirajk·Jul 28MySQL 8.0.46 Installation Guide for Students: A Complete Beginner’s Tutorial (Windows)📖 Estimated Reading Time (ERT): 8–10 Minutes
Nikhil G Goswami·Jul 21MySQL Table & Index Optimization: A Real-World Deep DiveDatabase Engineering MySQL 8.4 ~2.5 TiB production instance
InThe Table — Databases and SQLbyDbVisualizer·Jul 20MySQL 8.0 End of Life: What Changes After April 2026?MySQL 8.0 reaches its end-of-life milestone in April 2026. After that point, organizations still running the database version will no…
Bibrkacity·May 26Use a MySQL event to create a scheduleYou can run some actions in MySQL on a schedule. The main advantage compared to the capabilities of the framework is that you will not be…
