Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
performancehardwaresizingworkers
2 Odgovori
13418 Prikazi
Avatar
Martin Schubert

In 10 days our product is featured in a tv-show at prime time.

We expect 50k visitors on our website.

Cause we are a small company (5 users) we would like to avoid a load balancing server scenario for this single visitor peak.

Question 1: Is this configuration working for this case?

- Hardware: Google Cloud instance with 64 vCPUs, 240gb RAM, 20gb SSD

- Debian: default

- Nginx: default

- Odoo: 10 community - fresh database with 30 products and this modules: Ecommerce, Sales, Purchase, Manufacturing, Inventory, Accounting, no custom modules

workers = 100

limit_memory_hard = 1677721600 (1,6GB)

limit_memory_soft = 1073741824 (1GB)

limit_request = 8192

limit_time_cpu = 60

limit_time_real = 120

- Postgres: max_connections = 6500 (100 worker * 64 connections)

Question 2: How can I simulate the load to locate bottelnecks?

Has anyone experience with www.loader.io ?

Avatar
Opusti
Avatar
Martin Schubert
Avtor Best Answer

TV-Show is done and Odoo ran stable.

Visitors: 27k, concurrend 10k

with this settings:

- Hardware: Google Cloud instance with 64 vCPUs, 240gb RAM, 20gb SSD

- workers = 100

- limit_memory_hard = 1677721600 (1,6GB)

- limit_memory_soft = 1073741824 (1GB)

- http://pgtune.leopard.in.ua/

Load average:

CPUs: 30%

RAM: 25GB

Avatar
Opusti
Avatar
Dipak Shah
Best Answer

Hello Martin Schubert,

By Setting only workers is not enough you have to configure few things,

: (parameter of odoo/postgres database).

1> IN odoo config :   

    limit-memory-soft,limit-memory-hard

2> IN postgres (database) :

    max_connections,shared_buffers,effective_cache_size,work_mem

    maintenance_work_mem,checkpoint_segments,checkpoint_completion_target

    wal_buffers,default_statistics_target.

  • To share the workload between workers mostly you need to divide and allocate memory in such a way so its depending on the system config. (e.g Hard disc Type, Memory (RAM), Size of it,version of postgres and your O.S) .

You do not need to worry about it ,just go through either of below URL to boost up your server speed.

> http://pgtune.leopard.in.ua

> https://github.com/gregs1104/pgtune

HOPE this will help you a lot !

Many Thanks.


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Odoo.sh performance / sizing
performance sizing odoo.sh
Avatar
Avatar
Avatar
Avatar
4
maj 22
13602
Do Database Workers affect the Odoo SH platform performance?
performance slow workers OdooSH
Avatar
Avatar
1
avg. 23
5235
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users
performance postgresql workers tuning odoo
Avatar
0
mar. 24
6572
Odoo 10 CE performance tuning - enabling workers Solved
performance serversecurity workers odoo v10.0
Avatar
Avatar
1
avg. 22
31674
Odoo 8 with 10 users tips to fine tuning the database and workers
configuration performance postgresql9.3 workers tuning
Avatar
0
maj 16
11555