Speedemy Navigation
  • Home
  • About
  • Contact
  • MySQL
    • MySQL Scalability Consulting
    • MySQL Performance Consulting
    • 17 Key MySQL Settings
  • Search
  • Home
  • About
  • Contact
  • MySQL
    • MySQL Scalability Consulting
    • MySQL Performance Consulting
    • 17 Key MySQL Settings
  • Search

Category Archive

View Post

Best places to look for MySQL help

In MySQL by Aurimas MikalauskasApril 29, 2017Leave a Comment

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

In MySQL by Aurimas MikalauskasApril 20, 2017Leave a Comment

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 …

View Post

Inspecting MySQL micro-stalls with pt-stalk

In MySQL by Aurimas MikalauskasNovember 16, 2016Leave a Comment

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.

View Post

Advanced MySQL Slow Query Logging Part 3: fine-tuning the logging process

In MySQL by Aurimas MikalauskasOctober 20, 2016Leave a Comment

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 …

View Post

11 new features coming in MySQL 8.0 that will make your eyebrows raise

In MySQL by Aurimas MikalauskasSeptember 12, 2016Leave a Comment

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 …

View Post

Advanced MySQL Slow Query Logging Part 2: pt-query-digest report

In MySQL by Aurimas MikalauskasJune 13, 20161 Comment

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 …

View Post

Advanced MySQL Slow Query Logging

In MySQL by Aurimas MikalauskasJune 7, 20163 Comments

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 …

View Post

How To Speed Up MySQL Restart (hint: just like before, but this time for real)

In MySQL by Aurimas MikalauskasFebruary 3, 20162 Comments

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. …

View Post

MySQL 5.7 default configuration: what’s new? (and what’s not)

In MySQL by Aurimas MikalauskasJanuary 20, 2016Leave a Comment

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 …

View Post

MySQL Performance Troubleshooting Crash Course. A Story Of One Sneaky MySQL Performance Bug

In MySQL by Aurimas MikalauskasJanuary 5, 2016Leave a Comment

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
  • →

Free Resources

MySQL Configuration Tuning Handbook

Recent Posts

  • Best places to look for MySQL help
  • How to create mysql login-path
  • Inspecting MySQL micro-stalls with pt-stalk
  • Advanced MySQL Slow Query Logging Part 3: fine-tuning the logging process
  • 11 new features coming in MySQL 8.0 that will make your eyebrows raise

Categories

  • Apache
  • Architecture
  • Elasticsearch
  • Full Text Search
  • MySQL
  • Web Servers
  • Home
  • About
  • Contact
  • MySQL