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
A Straightforward Guide for MVCC in MySQL
eyochen profile
Eyo

A Straightforward Guide for MVCC in MySQL

#mysql #database #backend #learning
7
Comments 2
8 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
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
Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out
gabbrowick profile

Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out

#laravel #mysql #ai #database
Comments
4 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
2
Comments
3 min read
WHMCS has no retention story for its log tables, and it will full-scan them
vainamoinen profile

WHMCS has no retention story for its log tables, and it will full-scan them

#whmcs #mysql #performance #sysadmin
Comments
7 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
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 2
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.