[Csync2] large database file drops performances

[Vincent Régnard]

Lars Ellenberg a écrit :
> On Thu, Feb 07, 2008 at 05:41:54PM +0100, Vincent Régnard wrote:
>> Hi all,
>>
>> I have a preproduction environement with csync replication 
>> (master/failover) configuration. My csync database suddenly grow from 
>> 80MB to about 1Gb size when I added somme new files for a final set-up, 
> 
> how much is "some"?


Was ~20.000 and is now ~350.000


> 
>> and performances are really bad now. And I have some more files to add 
>> to my replicated file system !
> 
> how much is "some more"?


Is expected to become ~600.000


> 
> (number of directories, files, and out of curiosity: file sizes)
> 
>> I am wondering if there is a way to 
>> optimize my set-up or configuration to avoid the performance issue with 
>> this now large sqlite db file.
>>
>> Is there any way to reduce the database file size ?
> 
> maybe
> 
>> Is it possible to have several databases by any mean (eg make several 
>> groups and have one DB per group) ?
> 
> probably will not really help.
> but yes, you can use different _configurations_ (-C switch).

I'll try that tomorrow. I have semi-static and dynamic content, that do 
not require same refresh interval, that solution may be usefull in my case.

> 
>> Would using inotify help in that case ?
> 
> different context.
> 


-- 
Vincent Régnard
vregnard at tbs-internet.com
TBS-internet.com
027 630 5902

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5793 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.linbit.com/pipermail/csync2/attachments/20080207/41c1ef76/smime.bin