Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Multiple write locking for BerkeleyDB

by pc88mxer (Vicar)
on Apr 23, 2008 at 18:25 UTC ( [id://682446]=note: print w/replies, xml ) Need Help??


in reply to Multiple write locking for BerkeleyDB

How many updates a second do you need? Do you need to read the counters for any other reason (other than to increment them)? Are there any other processes accessing this data?

An alternative approach is to write a simple server which mediates access to the data store. Writers communicate with it via a pipe or socket. It would also allow you to implement complex atomic operations (like incrementing a value) without having to resort to locking.

  • Comment on Re: Multiple write locking for BerkeleyDB

Replies are listed 'Best First'.
Re^2: Multiple write locking for BerkeleyDB
by dino (Sexton) on Apr 23, 2008 at 18:38 UTC
    Atm I'm getting about 30k updates/min from mysql and the file based approach. DB_File gives around 200k and BerkeleyDB around 150k. On the reader side I'm using cacti and a perl script to total counts and display different traffic flows with greater detail than snmp queries. Read rate can be a lot lower than write rate.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://682446]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (6)
As of 2024-04-19 08:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found