This is not a resource list post. It is actually a question for you: where do you go, when you’re looking for MySQL help?
How to create mysql login-path
This is just a note to myself. I don’t do this often enough to remember the command, but whenever I’m searching for this, it takes half a minute to find …
Inspecting MySQL micro-stalls with pt-stalk
Very often MySQL is much less stable than we realize. In this video I explain how to detect and dianose these MySQL stalls that last for 5-10 seconds or more.
Advanced MySQL Slow Query Logging Part 3: fine-tuning the logging process
When your car doesn’t start, you don’t just blindly change the battery, starter, fuel pump, spark plugs or all of the above. Instead, you go to your mechanic and ask …
11 new features coming in MySQL 8.0 that will make your eyebrows raise
MySQL has just released MySQL 8.0 DR (and yes, DR stands for Don’t Run-it-in-production-yet) so let’s jump right in and take a look at the hottest new features coming in …
Advanced MySQL Slow Query Logging Part 2: pt-query-digest report
Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization. In …
Advanced MySQL Slow Query Logging
Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization. In …
How To Speed Up MySQL Restart (hint: just like before, but this time for real)
Restating MySQL can be really annoying. You just want to disable the goddamn query cache and it takes forever (read 5-10 minutes) to shutdown, not to mention the warm-up time. …
MySQL 5.7 default configuration: what’s new? (and what’s not)
Inspired by Peter Zaitsev’s post for MySQL 5.6, I decided to do a comparison between default configuration of MySQL 5.6 and 5.7. And I gotta tell you, some of the …
MySQL Performance Troubleshooting Crash Course. A Story Of One Sneaky MySQL Performance Bug
What better way to learn the basics of MySQL Performance Troubleshooting, than by observing a MySQL expert troubleshoot a nasty MySQL 5.7 performance bug, that a team of DBAs were …
- Page 1 of 2
- 1
- 2