dbTalk Databases Forums  

slow performance during write (sync on commit)

comp.databases.berkeley-db comp.databases.berkeley-db


Discuss slow performance during write (sync on commit) in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
wst305@gmail.com
 
Posts: n/a

Default slow performance during write (sync on commit) - 06-24-2008 , 05:57 AM






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/pro...files/perf.zip

Test of all following items except the last one show machine A is a
bit faster than machine B:

Data Store (read):
Data Store (bulk read):
Data Store (write):
Transactional Data Store (read):
Transactional Data Store (write, in-memory logging):
Transactional Data Store (write, no-sync on commit):
Transactional Data Store (write, write-no-sync on commit):
Transactional Data Store (write, sync on commit):

Performance of machine B on (write, sync on commit) is almost 2 to 3
times of that of machine A. I've no idea about the reason. Would
anyone please help?

Thank you very much.
Regards,
/ST Wong

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.