Antville Project

/mostread counting is off again

The story read counter is off again, this time for good or until the feature is re-implemented. Updating a big and very busy table every few seconds just doesn't work well with MySQL table locking stragegies. Every now and then, an story read counter update statement took too long, blocking all select statements on the table, driving up CPU usage and response times.

I guess the solution would be to use a separate supersimple table for story read counters.

comment    

 
supatyp, February 20, 2003 at 5:18:46 PM CET

Rats!

(nevermind)

link  

 
hns, February 20, 2003 at 6:38:48 PM CET

I know I know

maybe I'll try again tomorrow.

link  

 
hns, February 21, 2003 at 12:36:40 PM CET

I temporarily switched it on again

Maybe it was a MySQL config problem (too much memory allocated for the per-thread buffers). I'll check the access logs for problems within a few hours to see if it works. If you experience slow page load times (more than a few seconds, of course depending on your internet access) please drop a note here.

link  


... comment


The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 8549 Days
last updated: 1/4/11, 10:22 AM
status
Youre not logged in ... Login
menu
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
July
recent
zfuture's house here is zfuture's
house
by zfuture (7/31/03, 2:59 AM)
i understand your concerns however,
i hardly can think of a solution. certainly, if the...
by tobi (7/29/03, 9:47 AM)
Found several more similar sites
listed This is getting to be quite a concern to...
by cobalt123 (7/27/03, 7:56 PM)
Second Post Alert on Referrer
bug livecatz I put this into "help" and now here:...
by cobalt123 (7/26/03, 7:14 PM)
well it's not easy to
find from here, anyway. think we should include a link,...
by tobi (7/24/03, 11:25 AM)
So finally I found
the helma Bugzilla - stupid me.
by mdornseif (7/24/03, 10:28 AM)
clock not that it's particularly
earthshattering but the antclock is running slow by about 15...
by kohlehydrat (7/23/03, 8:25 PM)
but blogosphere.us isn't can't really
be rated as spam can it?
by kohlehydrat (7/23/03, 8:08 PM)
More referrer spam www.webfrost.com
by Irene (7/23/03, 7:55 PM)
How to log skin names
I accessed to console?? Hi, I would like to know...
by winson (7/23/03, 4:12 PM)

Click here to get an XML version of this weblog.

Made with Antville
powered by
Helma Object Publisher