ACD Router is a single threaded PHP daemon that heavily relies on PosgreSQL database.
Profiling revealed that SQL backend tuning is critical otherwise update queries can take 100ms and performance can drop to as low as 10 calls a second.

postgreSQL tuning

/var/lib/pgsql/data/postgresql.conf

# - Settings -

fsync = off                             # turns forced synchronization on or off
synchronous_commit = off                # immediate fsync at commit

Changing these options requires

 service sipxecs stop
 service postgres restart 
 service sipxecs start

This "little" change gives 10 fold performance boost!

ACD Performance tuning

postgreSQL tuning

Labels