Script completely owning my mysql server

[ShishCoBob]

I'm currently using PHP Super Counter from:
http://www.abspoel.com/roel-karin/download.php

My biggest problem is that each time this script runs (aka has a count)
it makes a query to an extreme big table (created by it) and sucks up a
lot of processing power.

Well today my mySQL server has been stuttering because of high traffic.

Every so often I'm getting:

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Then everything goes back to normal for a short while. And a little
later it'll so it again.

That seem to have stopped for the time being.

Basically is this just a crappy counting script? Or is it fairly good
(it's a little overkill for what I need, I just want to know how many
pageviews a day, month, and year, maybe hour if possible and maybe what
pages but that's it). Is it worth keeping this script or is there a
better one?

[David Robley]

In article <OKHLa.27469$ZE.1749@lakeread05>, reversemaximum-
ca**@webmaster.com says...

I'm currently using PHP Super Counter from:
http://www.abspoel.com/roel-karin/download.php

My biggest problem is that each time this script runs (aka has a count)
it makes a query to an extreme big table (created by it) and sucks up a
lot of processing power.

Well today my mySQL server has been stuttering because of high traffic.

Every so often I'm getting:

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Then everything goes back to normal for a short while. And a little
later it'll so it again.

That seem to have stopped for the time being.

Basically is this just a crappy counting script? Or is it fairly good
(it's a little overkill for what I need, I just want to know how many
pageviews a day, month, and year, maybe hour if possible and maybe what
pages but that's it). Is it worth keeping this script or is there a
better one?

Sounds like you just want fairly simple server stats? Try webalizer.

--
Quod subigo farinam

$email =~ s/oz$/au/o;