I'm using MariaDB 10.1. How to get actual query time for all of executed query? It seems that
SHOW PROFILES; was deprecated. Is there a better solution for database tuning?
Edit: It's deprecated only in MySQL 5.6.7.
long_query_time=0 and turn on the slowlog to a
my.cnf, and restart). Then the slowlog will contain a variety of info about every command executed, including the query time.
You might also want to run
pt-query-digest to summarize the slow log. This will include min/max/avg/etc for each 'different' query.