To enable slow query log, it is have to add one line into my.cnf.
I have MySQL installation on a Centos server.
It is MySQL 5.0.22 i686.
Let’s go through the details of setting of it.
Open my.cnf which is located at /etc/
add following under mysqld section.
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
The key point is to manually create the mysql-slow.log file.
chmod mysql.mysql -R /var/log/mysql
Last step is to restart mysql server.
Continue reading “Slow queries log for MySQL”
Site Meter is the one of the Most important provider in free web analytics tools. You know, the Google Analytics redesigned their interface. I don’t want to repeat it because lots of bloggers are mentioning it in their blogs. So, Site Meter start to change its face and internal things.
Site Meter launched a new site to be a replacement. The interface is changed and some users are getting problems.
You may find the link to SiteMeter on the right panel of this blog. I use Site Meter for long time. It is a great tool.
During this changes, I can only see the summary. Some pages are very slow.
I think it need a couple of weeks to fix the bugs in the new system.
I use hMailServer as my Email server and Awstats as my log analyse tool.
hMailServer 4.3 – Build 248
Advanced Web Statistics (Awstats) 6.5 (build 1.857)
In hMailServer Administrator.
Settings > Logging, check the AWStats checkbox.
Continue reading “Awstats and hMailServer”