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.
MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See
mahmut_gndzalp_c736ac4b profile

MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See

#mysql #php #database #webdev
2
Comments
6 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
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
Installing WordPress on Ubuntu 24.04
sharmukh profile

Installing WordPress on Ubuntu 24.04

#wordpress #nginx #mysql #ubuntu
6
Comments
6 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
10 MySQL Performance Optimization Techniques Every PHP Developer Must Know
tapas_mahata profile

10 MySQL Performance Optimization Techniques Every PHP Developer Must Know

#php #mysql #webdev #sql
1
Comments
3 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
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
Track MySQL LTS Updates with Renovate
catatsuy profile

Track MySQL LTS Updates with Renovate

#renovate #mysql #docker #devops
Comments
4 min read
Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)
mucheru profile

Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)

#kubernetes #mysql #moco #devops
Comments
8 min read
A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands
dulannithilaliyanarachchi profile

A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands

#php #mysql #wordpress #powershell
1
Comments
4 min read
Fashion E-Commerce Store
ajith_5906ae8402d31b2d6d8 profile
Ajith

Fashion E-Commerce Store

#backend #fastapi #mysql #webdev
Comments 1
4 min read
MySQL Optimization Strategies for Large-Scale Applications
software_solutions_740799 profile

MySQL Optimization Strategies for Large-Scale Applications

#mysql #database #backend #webdev
Comments
4 min read
Magento 2 Database Table Partitioning & Archiving Strategies
magevanta profile

Magento 2 Database Table Partitioning & Archiving Strategies

#magento #mysql #database #performance
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.