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.
78 seconds to 2: the covering index that fixed our slowest page

Summer Bug Smash: Smash Stories 🐛🛹
nitish_anand profile

78 seconds to 2: the covering index that fixed our slowest page

#mysql #performance #rails #bugsmash
Comments
5 min read
Modern IT Helpdesk & Ticketing System Built with PHP Native & MySQL
janrosedev profile

Modern IT Helpdesk & Ticketing System Built with PHP Native & MySQL

#webdev #coding #php #mysql
Comments
1 min read
Build a Complete Padel Court Booking System & Admin Dashboard
janrosedev profile

Build a Complete Padel Court Booking System & Admin Dashboard

#mysql #php #webdev #database
Comments
1 min read
Music Studio Management & Booking Dashboard | PHP & MySQLi
janrosedev profile

Music Studio Management & Booking Dashboard | PHP & MySQLi

#backend #mysql #php #webdev
Comments
1 min read
Upgrading Magento 2.4.5 to 2.4.8: Defusing the Tech Debt Time Bomb Before AWS MySQL 8.0 EOL
vesviet profile

Upgrading Magento 2.4.5 to 2.4.8: Defusing the Tech Debt Time Bomb Before AWS MySQL 8.0 EOL

#magento #aws #mysql #architecture
1
Comments
8 min read
Beyond the Switchover: Using RDS Snapshots to Safely Test MySQL 8.4 Compatibility Before Your Blue/Green Cutover
sammy_cloud profile

Beyond the Switchover: Using RDS Snapshots to Safely Test MySQL 8.4 Compatibility Before Your Blue/Green Cutover

#aws #mysql #devops #sre
Comments
12 min read
How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model
sampseiol1 profile

How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model

#php #mysql #algorithms #softwareengineering
Comments
6 min read
Build a Maintainable Node.js CRUD API with Express and MySQL
blogs_world profile

Build a Maintainable Node.js CRUD API with Express and MySQL

#node #express #mysql #webdev
Comments
9 min read
WordPress Sitewide Outages: Which Misconfigurations Actually Cause Them, Ranked by Frequency and Recovery Time
john_182319291 profile
John

WordPress Sitewide Outages: Which Misconfigurations Actually Cause Them, Ranked by Frequency and Recovery Time

#wordpress #selfhosting #php #mysql
Comments
14 min read
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
mahmut_gndzalp_c736ac4b profile

The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem

#mysql #performance #database #webdev
5
Comments
6 min read
Understanding Two-Phase Commit (2PC) by Building One in Go
ankitmalikg profile

Understanding Two-Phase Commit (2PC) by Building One in Go

#go #mysql #postgres #distributedsystems
Comments
11 min read
One '%' Cost Us 53 Seconds: A Redis, MySQL Buffer Pool Story
yogendra_singh_9737a86e38 profile

One '%' Cost Us 53 Seconds: A Redis, MySQL Buffer Pool Story

#database #mysql #performance #redis
Comments
3 min read
SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算
caresodev profile
tine

SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算

#sql #database #mysql #tutorial
Comments
1 min read
Atomic Money: Making a PHP/MySQL Wallet Safe Under Concurrency
amc_animarcelinus_b4a718 profile

Atomic Money: Making a PHP/MySQL Wallet Safe Under Concurrency

#php #mysql #fintech #database
1
Comments
5 min read
I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress
muhammad_suleman_095 profile

I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress

#mysql #opensource #database
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.