Monthly Archives: May 2007

Distributions, Monitoring

Using multiple logiles in one awstats config

With awstats you can create great statistics and graphs about the access of your website. If you want to use more than one logfile in a configuration file, you can use logresolvemerge.pl which is included in the awstats package.

i.e.:
LogFile="/path2/awstats/tools/logresolvemerge.pl /var/log/apache/access_log /var/log/apache/another_log |"

Test your configuration:
/path2/awstats.pl -config=sitename -update

Databases

Increase MySQL Performance

Keyword: MySQL Query Cache

If you want to increase the speed of your MySQL Database (answers), think about activating the Query Cache. That is available since Version 4. It’s really recommendable when you are working a lot with dynamic generated content, that does not change too often. Usually that is the fact for most webservers. In that case the Query Cache will give you back the answers for your sql queries without polling the database – as long as the tables do not change.

Insert in your config (/etc/my.cnf) i.e.:
query_cache_size = 8M

You can control the usage with a sql query:
SHOW STATUS LIKE 'Qcache%';

Thanks to Thomas Schefter for the hint.