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…
All posts by bob
MySQL Health Check release
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…
Google Cloud SQL MySQL: how to convert JSON to slowlog
Nowadays data volumes are growing very quickly. Today Hundreds of gigabytes database is not even being considered as a huge one. Naturally cloud services like Amazon Relational Database Service (RDS) or Google Cloud SQL services can be successfully used for such cases. This is very handy, you don’t even need to spend your time tuning…
Bash: sort IP addresses
It’s very easy sorting IP-list. For example you have file ‘ip-list’. To sort IP’s redirect file contents to following sort command. Also collect only unique IP’s in yours list. cat ip-list | sort -n -t . -k 1,1 -k 2,2 -k 3,3 -k 4,4 | uniq >> sorted-ips Didn’t find the answer to your question?…
How to exclude directories while using rsync
Sometimes when you copy a lot of data with rsync you may to exclude some sub-directories. You can do this by using –exclude. For instance, you want to copy files from /mnt to /home/destination_dir/, and you want to exclude directory /mnt/dir1/dir2/. rsync -az –exclude=’dir1/dir2/’ /mnt/ /home/destination_dir/ A lot of users do mistake when specifing path.…
Supportex is IPv6 ready!
Our company has been successfully certified by IPv6. At the moment the number of IPv4 addresses diminishes. Next generation IPv6 is designated to replace IPv4 and obviate lot of the shortcomings. The main drawback of IPv4 is the lack IP’s addresses for all new users. Migration to IPv6 will solve the problem of addresses lack…