How to Enable General and Slow Query Logging or where it will locate in sentora

[akram93]

Dear Sentora Team,

Kindly help to locate file of mysql slow queries below are little information related to slow query logging

The MySQL Slow Queries log can help determine which queries or scripts are unoptimized.

the logs where the Query_time is over 2 seconds. Queries that take over 2 seconds to execute usually need to be re-factored.

These logs are generated to help troubleshoot database programming queries that are not optimized. Locate the query and database causing the problem, then optimize the query or queries by re-writing the query, creating an appropriate Database Index, repairing any damaged databases, etc.

Below is example format
# Tue Nov 17 07:00:27 2015
# Thread_id: 1266852  Schema:   Last_errno: 0  Killed: 0
# Query_time: 25.653005  Lock_time: 0.000165  Rows_sent: 10938  Rows_examined: 10938  Rows_affected: 0  Rows_read: 10938
# Bytes_sent: 2723896
SET timestamp=1447768827;

[Me.B]

This can't be done in sentora control panel bu you need to change it in my.ini usually located under /etc or /etc/mysql not sure for ubuntu.

M B