ies.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 8:39 AM
To: Matthew Walker
Cc: Craig Westerman; MySQL List
Subject: Re: MySQL counter for HIGH traffic site
Hello.
First le
Hello.
On Sun, Apr 14, 2002 at 11:16:02PM -0400, [EMAIL PROTECTED] wrote:
> On Sun, 2002-04-14 at 22:17, Craig Westerman wrote:
> > I'm needing counter for site that receives 80 to 120 hits a minute at peak
> > load. Many I
[...]
> I personally wouldn't recommend logging to mysql. 80 to 120 quer
re Engineer
> ePliant Marketing
>
>
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 14, 2002 9:47 PM
> To: Matthew Walker
> Cc: Craig Westerman; MySQL List
> Subject: Re: MySQL counter for HIGH traffic site
>
ginal Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 9:47 PM
To: Matthew Walker
Cc: Craig Westerman; MySQL List
Subject: Re: MySQL counter for HIGH traffic site
Hi.
There is a one-query method to do that and it is even explicitly
documented:
Hi.
There is a one-query method to do that and it is even explicitly
documented: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
(under LAST_INSERT_ID([expr])). This requires an UPDATE and using a
client API function like mysql_insert_id(). No locks needed and the
operation is atomic (i
On Sun, 2002-04-14 at 22:17, Craig Westerman wrote:
> I'm needing counter for site that receives 80 to 120 hits a minute at peak
> load. Many I
> have tried cause excessive server load and need to be deactivated or they
> lose data and return to zero without warning. All tried so far have been
> w
"Craig Westerman" <[EMAIL PROTECTED]> writes:
> I'm needing counter for site that receives 80 to 120 hits a minute
> at peak load. Many I have tried cause excessive server load and need
> to be deactivated or they lose data and return to zero without
> warning. All tried so far have been written
I'd recomment PHP4 using pconnect and MySQL. And I'd /not/ use locking
on the table. Run a query to update the row, then run a select to grab
the current total. In the case of a counter, it doesn't require the
precision that most things would. (i.e., it's okay if the row you read
doesn't have the
These guys have written a PHP/MySQL counter script thats available for
download.
http://www.kastle.net/products/php/dbcounter/
I've used their old one thats writes to a text file rather than a MySQL db
and its very good also.
cheers
Mark Dale
On Sun, 14 Apr 2002, Colin Faber wrote:
> Having
Having objectively looked at both I would say a simple DBI perl app
running under mod_perl with Apache::DBI installed would be your best
bet for performance. Connection pooling is something you'll need to
keep the overall load down.
PHP's pconnect is good but seems to be a bit broken in it's poo
10 matches
Mail list logo
