After query optimization I just needed to run query several times to check time and compare it with original query. Query code was placed into query.sql file.

TIMEFORMAT=%R && for i in {1..10}; do time mysql < query.sql > /dev/null; done

This is output:

 1.913
 1.152
 1.421
 1.460
 1.409
 1.421
 0.937
 1.255
 1.376
 1.220

cat-yellow

My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net