[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: How to improve performance with MDB backend?
First test with your sugestions.
I am using Phyton program writen by me to add data to server.
Server is Centos 6.2 based (hardware described in my first post)
Python runs on separeate dual core PC with 1Gb connection to servers.
Servers are configured as N-way Multymaster
Test startÂÂÂ Test stopÂÂÂÂ Test durationÂÂÂ ÂÂÂÂÂ Num usersÂÂÂ User/sec
19.4.2013ÂÂ 19.4.2013ÂÂÂÂÂ sec 7789,00ÂÂÂ ÂÂÂÂ 1000000ÂÂÂ ÂÂÂ 128,39
11:53:45ÂÂ Â 14:03:34ÂÂÂÂÂÂÂ min 129,8166667
Database location mounted as:
UUID=616c291a-7fe4-47a1-87d1-c221a8e1c4f8 /optÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ ext4ÂÂÂ noatime,autoÂÂÂ 1 2
vm.dirty_ratio = 90
vm.dirty_expire_centisecs = 60000
Scheduler is:
[root@spr1 ~]# cat /sys/block/sda/queue/scheduler
noop anticipatory deadline [cfq]
memory manager libhoard.so (latest from hoard site)
Database size 36GB
-rw-------. 1 openldap openldap 14471663616 Apr 19 12:01 data.mdb
-rw-------. 1 openldap openldapÂÂÂÂÂÂÂ 8192 Apr 19 12:02 lock.mdb
[root@spr1 openldap-data]# du -hs data.mdb
14GÂÂÂÂ data.mdb
This is user data (one user). I can add 128,39 complete users in 1 second.
dn: uid=1,ds=USERS,o=STANDARD,dc=SPR
objectClass: sprUser
uid: 1
dn: subdata=userData,uid=1,ds=USERS,o=STANDARD,dc=SPR
roamingAllowed: TRUE
objectClass: sprUserData
subdata: userData
prepaidFlag: TRUE
sn: TestProv
pfUsername: user1
givenName: pcrfUser
loginPassword: 123
pfPassword: 123
dn: subdata=applicationData,uid=1,ds=USERS,o=STANDARD,dc=SPR
objectClass: sprUserData
subdata: applicationData
dn: ds=aaa,subdata=applicationData,uid=1,ds=USERS,o=STANDARD,dc=SPR
objectClass: sprDs
ds: aaa
dn: ds=2g3g,ds=aaa,subdata=applicationData,uid=1,ds=USERS,o=STANDARD,dc=SPR
objectClass: sprDs
ds: 2g3g
dn: ds=pcrf,ds=aaa,subdata=applicationData,uid=1,ds=USERS,o=STANDARD,dc=SPR
objectClass: sprDs
ds: pcrf
dn: subdata=2g3gProf,ds=2g3g,ds=aaa,subdata=applicationData,uid=1,ds=USERS,o=STA
ÂNDARD,dc=SPR
service2g3g: defaultService
profile2g3g: profile1
productCode2g3g: prodCode
barringStatus2g3g: barringStatus
objectClass: spr2g3gUser
uniqueId2g3g: user1
apnGroup2g3g: apnGG
provider2g3g: memyselveandi
framedIPAddress2g3g: 1.1.1.1
accountGroup2g3g: acctGroup
subdata: 2g3gProf
msisdn: 1234560001
flagStatus2g3g: flagStatus
class2g3g: classs
type2g3g: type
creationDate2g3g: 01.10.2010.
classification2g3g: 111
poolGroup2g3g: poolGroup
status2g3g: ACTIVE
dn: subdata=pcrfProf,ds=pcrf,ds=aaa,subdata=applicationData,uid=1,ds=USERS,o=STA
ÂNDARD,dc=SPR
profile: 3100
totalUsedVolume: 3
msisdn: 1234560001
objectClass: sprPcrfProf
totalMaximumVolume: 5
imsi: 1991234560001
subdata: pcrfProf
subscriberServiceProfile: TM00003100
featureList: Faeture1
paymentTypexy: NeverPaid
pfUsername: user1
tariffId: 1
pcrfServiceId: 3100
dn: pfUsername=user1,dc=USERNAME,dc=SPR
objectClass: alias
objectClass: extensibleObject
pfUsername: user1
aliasedObjectName: uid=1,ds=USERS,o=STANDARD,dc=spr
dn: msisdn=1234560001,dc=MSISDN,dc=SPR
objectClass: alias
objectClass: extensibleObject
msisdn: 1234560001
aliasedObjectName: uid=1,ds=USERS,o=STANDARD,dc=spr
dn: imsi=1991234560001,dc=IMSI,dc=SPR
objectClass: alias
objectClass: extensibleObject
aliasedObjectName: uid=1,ds=USERS,o=STANDARD,dc=spr
imsi: 1991234560001