MySQL is acting out? I’m sure I can help you with that. Here’s what kind of problems I’ve been solving for the last 12 years:
- Every 20-25 hours, all MySQL queries seem to be stuck for 1-2 minutes. We need to fix that.
- MySQL is consuming too much CPU. And disk. How can we reduce the workload?
- Replication slaves can’t keep up anymore. Help us solve it.
- This query shouldn’t be taking this long. It’s 10 times faster in dev.
- Things were running fine for three months and suddenly performance slowed down, we’re not sure what to do.
And hundreds of other interesting challenges, each special in their own way. (Of course, some issues I am seeing over and over again).
Who Am I
Hi, my name is Aurimas Mikalauskas (, , ). I always loved making things work faster, but it was not until 2004 that I faced real MySQL performance challenges – this was when I got an opportunity to work on scaling four largest and fastest growing websites in Lithuania at that time – autoplius.lt, pazintys.lt, klase.lt, supermama.lt.
There weren’t many resources on MySQL performance available those days, so I’ve spent hours and hours in forums, on IRC, interrogating developers I had access to, and digging MySQL source code to understand some things nobody knew the answer to.
In December 2006, I have joined Percona (now largest independent MySQL consulting company) as their first full time performance consultant. I’ve spent 9 years there working as a senior consultant, principal consultant and finally as an architect, until I decided it’s time to take a break and start a career as a freelance MySQL consultant.
While at Percona, I have worked with over a hundred of different companies, big and small, and here’s just a few names I can mention:
- Boardreader – I have worked on the search engine, which stores over 5TB of text data searchable in real time
- BBC – I’ve been involved in scaling their central user authentication system
- EngineYard – for few years I’ve been regularly optimizing databases for their fastest growing customers
- Big Fish Games – lots of different performance optimization work
- Groupon – dealing with their MySQL scalability challenges
Of course that’s just a glimpse of customers I was lucky to have an opportunity to work with over those 9 years at Percona.
And here’s a few unsolicited compliments I have received from the customers over the years (yes, I store all of them in a special folder in my email account, called “my mission”):
For EstanteVirtual CEO André Garcia, the personal relationship with Percona, and Aurimas in particular, is a delight. “I have a dedicated consultant who not only understands my setup, but he understands my business. I have to translate some Portuguese words for him once in a while, but that is part of the fun! Because he knows both where I want to get and what I care for, he knows exactly what I need before I ask! It’s fantastic.”
from Percona white paper “Estante Virtual Leverages Percona for State-of-the-Art Solutions”
Aurimas has been a pleasure to work with.
Justin Bonanno, Consultant at The Bonanno Group Digital Marketing
Aurimas, it was a pleasure to work with an expert and get a better understanding of where we are with our database. I appreciated how thoroughly you were able to analyze our system in such a short time.
Seth Stone, Senior Developer at Pine Cove
Aurimas, <..> also, I wanted to take a moment here to let you know how thrilled I have been with your work over the past year. You have done a really great job understanding my needs and quickly finding solutions to my problems. I have the highest level of confidence in the quality of your work and its a great relief for me to have someone as talented and knowledgeable as you helping me out when issues arrive with my server.
Jeff Cole, founder at jeffcole.org
Just finished a few weeks project with this talented guy. We are so happy with the results of the project. Aurimas perfectly handled every mysql issue we had with patience and kindness. Was worth any penny! Hope to work with him again in the future with a much bigger challenges! For us he is 5 stars, 100% professional.Guy Saar, CTO at FXP.co.il
How does it work
So you’re probably wondering now, if you decide to hire me – how does it work? Well, normally the work is done remotely, most of the time – over ssh, as that’s the most efficient way to do it.
First we get on a call to discuss your situation and how long it may take to have it solved, then I start working on your server(s). If you have a specific performance problem you want solved, that’s my first priority and I will work on that, check pointing with you regularly.
If you want a more proactive look at the database or a general optimization to reduce resource usage, then I will review your MySQL server OS configuration, MySQL config, status counters, schema and queries. And of course I will suggest how you can improve that.
Additionally, I will look for any intermittent performance problems that you may not even be aware of as they happen too infrequently and only last for a few seconds.
Remote – not for you?
If you prefer, the work can also be done onsite. I am based in Vilnius, Lithuania, hence 3-4 hour distance from most Europe countries, but I can travel to US, Canada and many other countries on a short notice (availability permitting).
Alternatively, we can use screen sharing tools and video conferencing, if that works better for you.
So, if you have an interesting performance challenge that you think I could help you with, let me know: