Odoo 8 with 10 users tips to fine tuning the database and workers
I'm planning to use Odoo Version 8 with 8/10 active users in the cloud.
I would like to ask if the following steps that I have taken are correct:
I created an instance on digital ocean with 2 GB Memory / 2 CPUs / 40 GB SSD Disk.
Would this be enough for 8/10 concurrent users ? If not what do you suggest to use to get a server with good performance?
To fine tune the PostgreSQL Database according to:
I changed parameters in the file: /etc/postgresql/9.3/main/postgresql.conf as follow:
listen_addresses = '*'
max_connections = 15
shared_buffers = 512MB
effective_cache_size = 1024MB
autovacuum = on
checkpoint_segments = 10
checkpoint_completion_target = 0.9
work_mem = 8MB
maintenance_work_mem = 32MB
I left all other parameters in postgresql.conf unchanged.
To set up Workers in Odoo V8
I changed parameters in the file: /etc/odoo-server.conf as follow:
db_maxconn = 64 (is this maximum connection to the DB ? Can I change it to 15 to get a better performance ?)
workers = 2
xmlrpc_port = 8069
longpolling_port = 8072
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
max_cron_threads = 2
Are the memory limits and cpu limits well set ? If not what do you suggest to change ?
Setting "workers = 2" is the correct choice for the server specification listed above?
Should I do anything else to fine tune the database, configuration files and workers ?
Should I setup 1 cron thread per available CPU ? If yes where and how to change this parameter ?