All posts in mysql

It is simple but confusing nonetheless. Official documentation does not help much, as both definitions looks almost the same. But there is a difference, which is important if your code handles time zones. With TIMESTAMP MySQL converts the value to UTC timezone to store it in database. Consequently, to SELECT the data MySQL runs a…

We are pleased to announce our MySQL Health Check service. It’s free and takes about a minute to complete, you just need to submit MySQL server counters. How it works? You submit your MySQL server counters from SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES and get the report. We analyze a lot of DB metrics…