My projects depends heavily on KT. It works well so far, the *.kch is above 40GB (around 100millions records), query and insertion speed is still okay. Currently, because async replication is not working, we can only have a daily Hot Backup... :(
We had tried many times but no luck, the problem is, the synchronization get slower and slower after few GB and finally stop after around 9GB. Any suggestion what may be the problem? What should I look into...?
Here is my configuration.
/usr/local/bin/ktserver -port 1998 -dmn -pid /data/ktserver/pid -le -th 2 -tout 10 -log /data/ktserver/log -ulog /data/ktserver/ulog -ulim 64m -sid 6 /data/ktserver/test.kch#bnum=200000000#msiz=1073741824#dfunit=8#ktopts=p
/usr/local/bin/ktserver -port 1999 -dmn -pid /data/ktserver/pid -le -th 2 -tout 10 -log /data/ktserver/log -sid 106 -mhost 10.0.0.6 -mport 1998 -rts /data/ktserver/0006.rts /data/ktserver/test.kch#bnum=200000000#msiz=1073741824#dfunit=8#ktopts=p
One more question, should i increase the number of thread?