Hi All,

Fresher's Jobs :- http://itjobguru.com/forum/viewforum.php?f=45

Jobs for Experienced :- http://itjobguru.com/forum/viewforum.php?f=11

Certification Material:- http://itjobguru.com/forum/viewforum.php?f=49

Interview Questions:- http://itjobguru.com/forum/viewforum.php?f=62

Books and Articles:- http://itjobguru.com/forum/viewforum.php?f=20

Regards,
Mishra

http://survival.googlebong.com

Maggie Joslin GoogleBong

img { border: 2px solid Black }

pre { font: 6pt/8pt }

p,blockquote { font: 16pt; font-family: verdana, arial, 'sans serif' }

h1,h2,h3,h4,ul { font-family: verdana, arial, 'sans serif'; font: 14p }

table,li,td { font-family: verdana, arial, 'sans serif'; font: 12p }

ul { list-style: disc }

ol { list-style: decimal }

body { background: "#EEEEEE" }

h1,h2,h3,h4,hr,p,ul,blockquote,pre { color:Black }

a:link { color:Blue }

a:visited { color:Blue }

a:active { color:"#008000" }

a:hover { color:"#008000" }

h1.header { padding:0em; margin:0 }

div.container { width:100%%; margin:0px; border:1px solid Black; line-height:150%% }

div.header,div.footer { padding:0.5em; color:white; background-color:Black; clear:left }

div.left { width:15%%; margin:0; float:left; padding:0; }

I believe it's purely related to cache size, not to TDS. The issue is
Berkeley DB's approximation to LRU in the cache. We don't maintain a
pure LRU list because it's a concurrency bottleneck.

You could try defining HAVE_FILESYSTEM_NOTZERO in db_config.h, and
changing the __os_fs_notzero function to return 1. This won't change
the order in which pages are flushed from the cache, but will ensure
that the file grows without holes.

Please let us know if this does make a difference.

Regards,
Michael Cahill, Oracle.

I tested this again after a couple of years, and the behavior doesn't
seem to have changed: If a Berkeley DB database is written using TDS
with a reasonably sized cache, data is written from the cache to the
file system in what a appears to be a random fashion. Apparently, a lot
of holes are created, which are then filled. This degrades file system
performance and makes hot backups somewhat difficult (because the read
performance is a fraction of that what can actually achieved).

Is there still no way to preallocate the contents of B-tree files?

(Without TDS, the problem disappears, it seems to be related TDS or the
cache size.)

When loading a database into a TDS environment (or changing every single
row of an existing database), is it possible to avoid allocating a lock
for each page touched? Obviously, even for medium-sized databases, the
number of locks required by the default approach is prohibitive.

Hi all, I'm newbie to BerkeleyDB ,when i do tutorial's example "query
'insert nodes
Some new text
after
doc("dbxml:/modify.dbxml/mod1.xml")/mod1/nodeOne'
" i get a syntax error saying "Unrecgnize character 'n' ". Is anyone
have the same problem.

I have two room,room 1 ,room2,have bdbs A1,B1,C1 in room1 ,A2,B2,C2 in
room2 ,and all this servers are in one replication group,
A1 as master and others are replica,when the network connection
between room1 and room2 broken,servers in room1 elect A1 as master
and A2 as master in room2,then my part of my data will be writen to A1
and part will be to A2,I'm wandering what will happen
when connection between room1 and room2 is recoverd?????will the data
in all six servers be same??

Hi all,

I'm newbie to BerkeleyDB and testing 4.6.21 on CentOS 5 on 2 Dell
PowerEdge 1950 (8GB RAM each, SAS 6/iR controller). The only
difference is disk:
machine A: 2 x 146GB (15000rpm, RAID 1)
machine B: 2 x 500GB (7200rpm, RAID 1)

Both systems has drive cache enabled as shown in dmesg:

"...
SCSI device sda: drive cache: write back
..."

Some IO performance test tools show result as expected (machine A is a
bit faster than machine B):

- time dd if=/dev/zero of=/tmp/a bs=64k count=100k
- iozone
- bonnie++

However, when I run load test against openldap 2.4.10 using BerkeleyDB
as backend, write performance of machine B is much faster than machine
A (ranging from 8 - 10 times) with the same DB_CONFIG setting. Then I
tried performance tool from Oracle : http://www.oracle.com/technology/products/berkeley-db/files/perf.zip

sql cvv database

WereEveryWhere.net seeks to become the most popular Social Networking Website
offering an interactive, user-submitted network of friends, personal profiles,
video chat, blogs, groups, photos, music and videos for adults internationally.

Log on at http://www.WereEveryWhere.net Its FREE!

-----------------------------------------------------------------------------
--This Message Has Been Posted Using A Trial Version Of Message Poster 2003--