Hello Mandar,
At Néréide, we use postgresql instead mysql for the database, so I have
no idea if mysql can be a pb in your case.
But with your explanation, I can't help you because I have no
information on what process you have an issue (data loading, displaying
page, order processing, ...), there is a lot of layer present that can
be explain why you have some latency
Nicolas
Le 31/01/2025 à 14:55, Mandar K a écrit :
Dear All, We need your urgent inputs to come out of this situation. We are
facing significant performance issues.
Team, candidly this is a critical situation for us, any help taking out of
this situation is truly appreciated. Thanks a ton.
The environment summary is :
Server : Win 16 Standard
Intel Xeon (R) CPU 2.1 GHz
RAM : 128 GB
Cores : 24
key_buffer_size = 256M
read_buffer_size = 2M
innodb_flush_log_at_trx_commit = 1
innodb_buffer_pool_size = 1G
sort_buffer_size = 4M
Application and Database are in the same server.
Also can someone assist on how Ofbiz architecture is in handling
threads/multi-threading, MySQL connections. What are best practices in our
architecture that are inbuilt.
