Community mailing list archives

community@mail.odoo.com

Re: How to optimize general performance

by
Alejandro Perez Cosio
- 02/10/2016 11:10:19
We are also having some performance problems right now.

We have 5 physical POS with 4000 products which are loaded at the same time (7:30 am) for 5 sessions.
The server specs: EC2 m4.xlarge (4 vCPU and 16GB Mem) + RDS db.t2.small (1 vCPU and 2GB Mem)
The stores have 20Mb/s internet connection.

The thing is the POS sessions take 10 minutes or more to load the products and some times the server crashes while loading (100% processor use while products are being loaded)..
The odoo config file was not edited.

Is this an expected behavior?
I really don't understand how these loads can crash a server with such specs..

Regards
--
Alejandro

On 07/02/16 11:08, Graeme Gellatly wrote:

Tbh Alex I do it slightly differently. Hard limit around 12gb, soft limit at 2gb. That way really big batch processes complete, but run of the mill requests don't take a lot of ram.  That's with 25 workers and ram usage for python rarely exceed 20gb. But of course monitoring logs is really the only way to tune that to a specific workload.  Although I'm wondering now if restarting workers clears cache and a higher soft setting may be better.

In terms of postgres I pretty much use the setting you suggest but I think it's largely ignored in recent versions except by the query planner.  But it's what pgtune spits out anyway.


On Sun, 7 Feb 2016 10:27 PM Alexandre Fayolle <alexandre.fayolle@camptocamp.com> wrote:
Odoo is clearly OLTP.


Regarding memory: if there are 8 cores, plan for 8 workers, and configure a hard limit of 4GB per worker. This means 32GB for Odoo, say 40. You may assign ~64GB for postgresql.



2016-02-05 22:34 GMT+01:00 Andreas Becker <andi@lisandi.com>:
+ Kitti

What would be best to set:

Web application
Online transaction processing system
Data warehouse
Desktop 
Mixed type of applications

what is your experience?

How many connections would be best?

Total Memory - does it mean all memory of the system or if you run also other applications on the server which use. i.e. mariaDB or MySQL etc.only the memory you would like to give to postgres?


With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่อง ที่เกี่ยวกับชนิด,
與親切 的問候,

 ANDI BECKER

CEO/General Manager LisAndi Co., Ltd.

--------------------------------------------------

LisAndi Co. Ltd., Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:  andi@lisandi.com

--------------------------------------------------

This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Sat, Feb 6, 2016 at 12:17 AM, Naresh Soni <jmnaresh@gmail.com> wrote:
+1 Kitti, very useful website.
On 5 February 2016 at 19:42, Kitti U. <kittiu@ecosoft.co.th> wrote:
Hello,

There is this website that we use, http://pgtune.leopard.in.ua/

Kitti
On Fri, Feb 5, 2016 at 7:22 PM, Lionel Sausin <ls@numerigraphe.com> wrote:
The 2 most simple, quick efficient things to tune are :
- enable workers in the Odoo config, so you can use your multi-core CPU
- configure Postgresql with PGTune, which will set sensible values for 
your hardware
LS.

_______________________________________________

--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th

_______________________________________________

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Alexandre Fayolle
Chef de Projet
Tel : + 33 (0)4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe