Rick's Rules of Thumb for MySQL
Here are 170+ tips, tricks and suggestions for MySQL.
Rick's Rules of Thumb for MySQL launched on December 26, 2019 with 5 votes, #1,130 of 2,946 launches that month. The site was still online in September 2026, 6 years on.
What it does
Here are 170+ tips, tricks and suggestions for MySQL. They come from a decade of improving performance in MySQL in thousands of situations. For more guides, go to http://mysql.rjweb.org/
Here are 170+ tips, tricks, suggestions, etc. They come from a decade of improving performance in MySQL in thousands of situations. There are exceptions to the statements below, but they should help guide you into better understanding how to effectively use MySQL. Except where noted, the tips in this document apply to MySQL, MariaDB, and Percona. Big DELETEs - how to optimize -- and other chunking advice, plus a use for PARTITIONing Chunking lengthy DELETE/UPDATE/etc. ( Groupwise Max ): Efficiently find largest row(s) for each group Other Tips, Tuning, Debugging, Optimizations, etc... Character Set and Collation problem solver Trouble with UTF-8 If you want case folding, but accent…from mysql.rjweb.org
Does a similar job
all alternatives →
I wrote a free eBook about many lesser-known/secret database tricks2022 · sqlfordevs.com · ▲865Stop treating the database as dumb storage and use its extended features. There's a lot you can use.
MySQL for Developers2023 · planetscale.com · ▲152Learn MySQL with 64 videos for application developers
PlanetScale Boost2023 · planetscale.com · ▲93Up to 1,000× faster database queries with just a few clicks
More dev tools this month
the category →
Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.
Dev tools · 18h ago · github.com
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 29d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 27d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 24d ago · openbot.run
Talanoa▲346Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 22d ago · talanoa.email
Source: Product Hunt launch ↗
Launched alongside, December 2019
the whole month →
- AA
After years of solo development I'm presenting: Angeldust, an omni-compatible action RPG and building game! Website: http://angeldu.st My single server hosts 250+K active players in one giant, dynamic fantasy world. Angeldust's game server is pervasively multithreaded, implementing John Carmack's dream of processing an immutable world state each tick. Both world handling and network traffic routing uses any number of threads. For networking, a typical game session only uses ~3Kbps of bandwidth, enabling decent play even over 2G/EDGE networks. The client is programmed in C++…
Growth · 2019
- AS
Dev tools · 2019 · selfhostedsource.tech
A isometric city builder in JavaScript. Contribute to victorqribeiro/isocity development by creating an account on GitHub.
Dev tools · 2019 · github.com
Play and create AI-generated adventures with infinite possibilities.
AI · 2019 · aidungeon.io
