The Natural Evolution of Data Warehousing—Where We Are Today December 4, 2017 It’s a fact that technology is always evolving—rapidly. What’s new and hot today, may be old news...
Calculating business days in HiveQL December 30, 2015 One of the common tasks in data processing is to calculate the number of days between two given...
Debugging IN vs OR Performance in MySQL May 18, 2012 I was recently puzzled by the question: “Which query will be faster?” SELECT * FROM table WHERE pk...
Once again about innodb-concurrency-tickets December 13, 2011 I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging...
Audit a MySQL Instance with MySQLTuner October 9, 2008 Quite often we need to perform a so-called "MySQL instance audit". This common DBA procedure should...