Currently Viewing Posts Tagged analyse

Slow queries log for MySQL

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
log-queries-not-using-indexes

The key point is to manually create the mysql-slow.log file.

cd /var/log
mkdir mysql
touch mysql-slow.log
chmod mysql.mysql -R /var/log/mysql

Last step is to restart mysql server.

Continue reading “Slow queries log for MySQL”

Site Meter changes face

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.
sitemeter-yinfor

I think it need a couple of weeks to fix the bugs in the new system.

  • Archives