EmergencyEMERGENCY? Get 24/7 Help Now!

Django with time zone support and MySQL

 | January 7, 2015 |  Posted In: Insight for Developers, MySQL

This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes. Shortly, more about the problem. After reading the official documentation about the time zones, it makes clear that in order to reflect python datetime in […]

Read More

Using YUM to install specific MySQL/Percona Server versions

 | January 5, 2015 |  Posted In: Insight for DBAs, MariaDB, MySQL, Percona Server for MySQL

Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be several reasons for that, where I think the most common is when a new version should spend some time in testing or a staging environment before getting to production. In theory each new version is […]

Read More

The MySQL Query Cache: How it works, plus workload impacts (good and bad)

 | January 2, 2015 |  Posted In: MySQL, Percona Server for MySQL

The MySQL query cache is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how the MySQL query cache works, as it has the potential to cause significant performance improvements – or a slowdown – of your workload. The MySQL query cache is a global one shared among the […]

Read More