Welcome to Geeklog Monday, October 19 2020 @ 07:42 pm EDT

Geeklog Forums

GUS plugin needs volunteers!


Status: offline

asmaloney

Forum User
Full Member
Registered: 08/02/04
Posts: 214
Hello all. I have a 'new' statistcs plugin which needs testers.

Here's my description from the readme:

The Geeklog Usage Stats [GUS] plugin is based on the venerable stats plugin v1.3 by Tom Willett and John Hughes. Some of this documentation is based on their work as well. I decided it needed some cleanup and updating to work with the latest version of geeklog, and Tom mentioned he wasn't going to continue supporting it. I thought this was going to be a quick week's work. Wrong! As I got into it, I found I wanted to fix this and that, optimise this a bit... oh and tweak that... Eventually I decided to do a major overhaul. It's a month later and the GUS plugin is the result.

I chose to keep the interface more or less the same for now. The major difference between the two plugins is what's under the hood. I made the following changes to the database:

* moved user agents to their own table
* use the SQL date and time formats
* removed redundant fields

I also changed the name of the plugin from 'stats' to 'gus', eliminated the 'name the plugin whatever you want' functionality, put all the documentation in this readme, added the ability to import stats from the stats plugin, and changed the installation/upgrade mechanism. I probably did some other things too...

The changes to the database will improve performance and require less space. I don't have any real statistics on this, but it reduced a 10M database to less than 5M and it is noticeably faster when accessing stats.
...

So, I'm looking for some victims to try it out. Ideally I would like at least a couple of people with huge DBs under the stats plugin. I use PHP 5.x, though it should work under 4.x so I would need some testers using that. I also use MySQL 4.1.10, so anyone with 4.0.x would be useful. I don't believe it will work under MySQL 3.x.

If anyone want to test drive it and give me feedback, please email me - I'm looking for four or five people. Please tell me what your setup is: which OS, which versions of MySQL and PHP you are using, and roughly how big your current stats DB is.

Thanks!

- Andy
 Quote

Status: offline

Robin

Forum User
Full Member
Registered: 15/02/02
Posts: 725
Quote by asmaloney: Hello all. I have a 'new' statistcs plugin which needs testers.

Hello Smile count me in however I have no idea as to the technical spec of the server I'm running Geeklog on.
Geeklog Polish Support Team
 Quote

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Hooray Its a deal - shaking hands I will test it for you, however, I am leaving on business this weekend and will not have a chance to do it till the end of next week. Glad you finally worked through it -- there was lots of room for improvement.

TomW
 Quote

Status: offline

xardoz

Forum User
Regular Poster
Registered: 24/02/04
Posts: 98
I'm game - I can't tell you the OS, except its probably a Linux distro.
php - 4.3.10
mysql - 4.0.24

I don't know what you'd consider a big DB, but I've been up for a year, and for March alone I had 2737 anonymous visitors, although most of those were hits from Google image search.
 Quote

dbsmall

Anonymous
1) Thank you
2) Sometime in the next week or so, I'll upgrade my GL (http://www.small.to) to the latest version.
3) Site's been up for a while, but I only have about 6 months of stats DB.
4) Thank you
5) March is our best month to date...~1300 visitors/day
6) Yup, it's slow for me...so performance improvements sound nice.
7) Thank you

gus@small.to will get to me...
 Quote

Status: offline

asmaloney

Forum User
Full Member
Registered: 08/02/04
Posts: 214

Can someone help me I still need a few people...

C'mon, there must be people out there that enjoy being test subjects!

email me!

- Andy
 Quote

Status: offline

Centauri

Forum User
Newbie
Registered: 14/01/05
Posts: 6
Location:The Netherlands
happy
My experience with the stats plugin is that it really slows down the query time by the seconds. This only after one month, and the database grew from 2MB to 15MB.

So i removed it now.

It would be great if this GUS plugin solves those problems.

I forgot, i'm using PHP 5.0.3 and mysql 4.1.8
 Quote

Status: offline

xardoz

Forum User
Regular Poster
Registered: 24/02/04
Posts: 98
mods, please delete this post.
 Quote

anony

Anonymous
Why should this post be deleted?
 Quote

Status: offline

dbsmall

Forum User
Junior
Registered: 22/02/02
Posts: 23
1) GUS install was incredibly easy and error-free.
2) So far, this looks great!
3) While I'm at it, Mr. Maloney's Amazon plugin is pretty nifty, too (and enables you to support it by giving a fraction of your referrals to his Associates ID, which is pretty darn cool.)
 Quote

All times are EDT. The time is now 07:42 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content