Significant Performance Issue

[Mandar K <ma...@gmail.com>]

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.

-- 
Regards
Mandar

Re: Significant Performance Issue

[Nicolas Malin <ni...@nereide.fr>]

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.
>