Mysql-slow-queries

[ullalla]

I am having 1 question on mysql-slow-queries.

If we enable mysql-slow queries on server then is it possible to check the slow queries date wise at /var/log/mysql-slow-queries?


A quick assistance is appreciated.

 

[coderiser]

try using this mysql tuner to fix the issue MySQLTuner

 

[cPanelTristan]

Hello ullalla,

What MySQL version are you using? Can you please indicate which one it is and I can advise how to enable the slow query log in /etc/my.cnf for that MySQL version?

mysql_config --version

Once it has been enabled, you can then view the logs at the location they will create, although I would suggest getting a script like mysqlsla at http://hackmysql.com/mysqlsla to analyze the logs for you.

Thanks.

 

[ullalla]

i have already enabled it, my question is that can we check the logs date wise?

 

[Alexd790]

I have face this type of problem, I used MySQL updated version to solve this problem.

 

[cPanelTristan]

i have already enabled it, my question is that can we check the logs date wise?

Is there a section for each log entry indicating something like:

SET timestamp=1255345490;

If so, then these are epoch dates and you'll be able to use a converter like Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft to grab the date you want converted to regular times, then check through the logs for those dates. Since you haven't provided any entries from your log, I cannot state what you have in the log that might be indicating the dates and times.