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? Read More
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 it in MySQL manual, so hopefully this gets indexed better (in my memory as well as in Google). Read More
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. Read 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 him to check what is wrong (or you check it yourself if you are the mechanic) and then fix whatever is broken. Read More
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 this new release: Read More
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 part 2 here, we will go over the pt-query-digest report, that we have prepared in part 1.
Here’s links to the other two parts:
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 this short series I will show you how to do Slow Query Logging the right way. Read More
Convert Sphinx query log into MySQL slow query log
Why would you wanna do that, you ask? Well, because then you can parse it with tools like pt-query-digest
and get a nice look at the queries hitting Sphinx sorted by resource consumption. Read More
5 incredibly valuable tips for building microservices based systems from Google’s director of software engineer
I was doing a Velocity Conference flashback the other day and this talk about managing complexity in distributed systems by Astrid Atkinson (from Google) caught my attention. I’m not very much of a “5 great tips” guy, but the points she was making were so spot on, she left me no choice.
Read More
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. Yes, with MySQL 5.7 you can do many changes online, so you won’t necessarily be restarting that often, but you still need to do upgrades, occasionally increase redo log size and, admit it, enable skip-grant-tables. Here’s how you can make this process way less painful. Read More
- Page 1 of 2
- 1
- 2