This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

How to Enable General and Slow Query Logging or where it will locate in sentora
#1
How to Enable General and Slow Query Logging or where it will locate in sentora
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;
Reply
Thanks given by:
#2
RE: How to Enable General and Slow Query Logging or where it will locate in sentora
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
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Can anyone suggest best Sentora alternative servermaster 1 465 12-22-2023, 10:41 AM
Last Post: TGates
Sentora 2.0 Beta Ron-e 6 12 ,157 01-01-2022, 11:56 AM
Last Post: TGates
Can not access Sentora ThomasMoss 4 6 ,379 01-01-2022, 10:41 AM
Last Post: TGates

Forum Jump:


Users browsing this thread: 1 Guest(s)