How can i get a log to check the performance of my application in my sql.
First of all I’d suggest to enable slow queries log:
long_query_time = 1log_queries_no_using_indexeslog_slow_queries = /var/log/mysql/mysql-slow.log
And then put your application under some load (I mean jut work with it). When you’ll get some noticeable amount of queries in the mysql-slow.log, just use mysqlsla on it and you’ll see where you need to look to optimize your aplication.