Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 11:27:19PM +, Khapare Joshi wrote: Only guessing, but it sounds to me like a problem with your gnustepdefauls bindDN. Is it a working DN/bindPassword combination? Or maybe your ldap server running out of connections? yes it is working DN/bindPassword. running out of connection (is there a limit ? where can I check in LDAP - i have fedora driectory server) There's a max number of file descriptors setting in the Configuration-Performance tab in the management console. You probably need to have a higher ulimit -n in /etc/sysconfig/dirsrv. I don't quite remember, but think there's an errors file on the ldap-server that should show if you're running out of connections. You might also want to make sure that the fields sogo is searching for in ldap are indexed. I believe sogo will search for all fields mentioned in SearchFieldNames and bindFields, so these needs to be indexed. -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 10:39:30PM +, Khapare Joshi wrote: My sogo server sometime response very very slow. I use improxy but my sogo server is rather slow and this performance issue is random. I think hardware spec of the server is fine. I added /etc/sysconfig/sogo PREFORK=6. server memory looks 1G free CPU utilization average is arond 3-4 % Assuming your backends are not the problem, maybe try increasing PREFORK a lot (and remember to also increase postgresql max_connections to match). We're currently running with PREFORK=60. It's seldom that that many processes are needed, but when the server has the resources for it we would rather use cpu than stall the users requests. Rebooted server, restarted sogod daemon. But this is bugging me. Sogo should be fast (:) and faster than squriell mail. What can I do to optimize the sogo server and what are you guys doing for better performance for sogo server, any sogo configuration parameter ? postgres indexing ? apache config ? What IMAP server are you running? -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 10:39:30PM +, Khapare Joshi wrote: server, any sogo configuration parameter ? postgres indexing ? Is your postgres database busy? We were struggeling with high cpu usage on our databaseserver recently, and it turned out it was a problem with the session table growing and growing. We now run a daily deletion of all rows older than 24 hours: DELETE from sogo_sessions_folder WHERE extract('epoch' from current_timestamp)-c_lastseen 86400; I believe there's also an index fix for this table in v1.3.12.. -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 10:52:08PM +, Khapare Joshi wrote: the sogo server and what are you guys doing for better performance for sogo server, any sogo configuration parameter ? postgres indexing ? apache config ? What IMAP server are you running? CYRUS IMAP murder Ok, I'm not familiar with cyrus.. -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 10:53 PM, Jan-Frode Myklebust janfr...@tanso.netwrote: On Tue, Feb 14, 2012 at 10:39:30PM +, Khapare Joshi wrote: server, any sogo configuration parameter ? postgres indexing ? Is your postgres database busy? We were struggeling with high cpu usage on our databaseserver recently, and it turned out it was a problem with the session table growing and growing. We now run a daily deletion of all rows older than 24 hours: DELETE from sogo_sessions_folder WHERE extract('epoch' from current_timestamp)-c_lastseen 86400; I believe there's also an index fix for this table in v1.3.12.. No, my database not yet too busy. I do not see much high load either. however my /var/lib/pgsql/data/postgresql.conf max connection is set to 100 and changed the PERFORK to 70 however, I have tons of error in /var/log/sogo/sogo Could not bind to the LDAP server ldap.hi.is (389) using the bind DN: uid=test,ou=People,dc=test,dc=com but again I can access sogo and all. I am not sure about this error. It could be thunderbird or iphone are trying to synchronize the event and somehow sogo could not bind on that particular synchonization. Do you know how to debug this ? Thanks K -jf -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 11:07:34PM +, Khapare Joshi wrote: No, my database not yet too busy. I do not see much high load either. however my /var/lib/pgsql/data/postgresql.conf max connection is set to 100 and changed the PERFORK to 70 That will fail under load. You need minimum 3 postgres connections per sogod = 3*70 = 210. however, I have tons of error in /var/log/sogo/sogo Could not bind to the LDAP server ldap.hi.is (389) using the bind DN: uid=test,ou=People,dc=test,dc=com but again I can access sogo and all. I am not sure about this error. It could be thunderbird or iphone are trying to synchronize the event and somehow sogo could not bind on that particular synchonization. Do you know how to debug this ? Only guessing, but it sounds to me like a problem with your gnustepdefauls bindDN. Is it a working DN/bindPassword combination? Or maybe your ldap server running out of connections? -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
On Tue, Feb 14, 2012 at 11:15 PM, Jan-Frode Myklebust janfr...@tanso.netwrote: On Tue, Feb 14, 2012 at 11:07:34PM +, Khapare Joshi wrote: No, my database not yet too busy. I do not see much high load either. however my /var/lib/pgsql/data/postgresql.conf max connection is set to 100 and changed the PERFORK to 70 That will fail under load. You need minimum 3 postgres connections per sogod = 3*70 = 210. Thanks for this. however, I have tons of error in /var/log/sogo/sogo Could not bind to the LDAP server ldap.hi.is (389) using the bind DN: uid=test,ou=People,dc=test,dc=com but again I can access sogo and all. I am not sure about this error. It could be thunderbird or iphone are trying to synchronize the event and somehow sogo could not bind on that particular synchonization. Do you know how to debug this ? Only guessing, but it sounds to me like a problem with your gnustepdefauls bindDN. Is it a working DN/bindPassword combination? Or maybe your ldap server running out of connections? yes it is working DN/bindPassword. running out of connection (is there a limit ? where can I check in LDAP - i have fedora driectory server) -jf -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo Slow Performance
Hi, For slapd.conf i think it is threads. Philipp Strobl -pilarkto.net- Am 15.02.2012 um 00:27 schrieb Khapare Joshi khapar...@gmail.com: On Tue, Feb 14, 2012 at 11:15 PM, Jan-Frode Myklebust janfr...@tanso.net wrote: On Tue, Feb 14, 2012 at 11:07:34PM +, Khapare Joshi wrote: No, my database not yet too busy. I do not see much high load either. however my /var/lib/pgsql/data/postgresql.conf max connection is set to 100 and changed the PERFORK to 70 That will fail under load. You need minimum 3 postgres connections per sogod = 3*70 = 210. Thanks for this. however, I have tons of error in /var/log/sogo/sogo Could not bind to the LDAP server ldap.hi.is (389) using the bind DN: uid=test,ou=People,dc=test,dc=com but again I can access sogo and all. I am not sure about this error. It could be thunderbird or iphone are trying to synchronize the event and somehow sogo could not bind on that particular synchonization. Do you know how to debug this ? Only guessing, but it sounds to me like a problem with your gnustepdefauls bindDN. Is it a working DN/bindPassword combination? Or maybe your ldap server running out of connections? yes it is working DN/bindPassword. running out of connection (is there a limit ? where can I check in LDAP - i have fedora driectory server) -jf -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists