How to Enable General and Slow Query Logging or where it will locate in sentora
11-18-2015, 01:16 AM
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;
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;
