ullalla

Well-Known Member
Jan 20, 2006
192
0
166
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

Member
Jan 31, 2011
18
0
51
try using this mysql tuner to fix the issue MySQLTuner
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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?

Code:
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

Well-Known Member
Jan 20, 2006
192
0
166
i have already enabled it, my question is that can we check the logs date wise?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
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:

Code:
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.