3 key data analytics announcements from Google NEXT 2019
Google NEXT 2019 was a momentous event for the Pythian team. We celebrated winning the Google Cloud...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Danil Zburivsky
The Natural Evolution of Data Warehousing—Where We Are Today
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
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
I was recently puzzled by the question: “Which query will be faster?” SELECT * FROM table WHERE pk...
Once again about innodb-concurrency-tickets
I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging...
Audit a MySQL Instance with MySQLTuner
Quite often we need to perform a so-called "MySQL instance audit". This common DBA procedure should...
