EmergencyEMERGENCY? Get 24/7 Help Now!

OOM relation to vm.swappiness=0 in new kernel

 | April 28, 2014 |  Posted In: Insight for DBAs, MySQL

I have recently been involved in diagnosing the reasons behind OOM invocation that would kill the MySQL server process. Of course these servers were primarily running MySQL. As such the MySQL server process was the one with the largest amount of memory allocated. But the strange thing was that in all the cases, there was […]

Read More

On SSDs – Lifespans, Health Measurement and RAID

 | October 12, 2012 |  Posted In: MySQL

Solid State Drive (SSD) have made it big and have made their way not only in desktop computing but also in mission-critical servers. SSDs have proved to be a break-through in IO performance and leave HDD far far behind in terms of Random IO performance. Random IO is what most of the database administrators would […]

Read More

A case for MariaDB’s Hash Joins

 | May 31, 2012 |  Posted In: Benchmarks, Insight for DBAs, MySQL

MariaDB 5.3/5.5 has introduced a new join type “Hash Joins” which is an implementation of a Classic Block-based Hash Join Algorithm. In this post we will see what the Hash Join is, how it works and for what types of queries would it be the right choice. I will show the results of executing benchmarks […]

Read More

Benchmarking single-row insert performance on Amazon EC2

 | May 16, 2012 |  Posted In: Benchmarks, Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally built is long over, […]

Read More