I installed this module on http://openpackage.biz/ . As soon as I went to admin/logs/graphs the vm started swapping like crazy and my site was floored. I had to restart mysql and apache.

I'd love to see graphs of my site, but this module really needs to be less hungry.

Comments

batje’s picture

batje commented

The query that floored my server (with 160k pageviews) was

$stats = db_fetch_object(db_query('SELECT COUNT(DISTINCT(path)) AS count FROM {accesslog} WHERE timestamp > %d AND timestamp <= %d', $loop, $loop + 3600));

each of these loops takes 10 minutes.

In general a distinct on a Character column is not a real good idea. Maybe if the table would hold a column which holds a numeric Hash of the URL, and had an index, the query would be usable.

(btw, it *does* generate lovely graphs)