Thanks Simon,
Just did that, I guess it will improve when the buffer get loaded. Right now
the timing is very similar.
Atte,
Ricardo Pertuz
On 25 Aug 2023, 11:46 AM -0500, Simon Weller , wrote:
> Kuasar,
>
> It looks like you have the innodb_buffer_pool_size set to the default. Can
> you try
Kuasar,
It looks like you have the innodb_buffer_pool_size set to the default. Can
you try and increase this to 70% of your available memory? I think you
mentioned you have 4GB assigned. If it's a dedicated server/VM for MySQL,
can you edit your my.cnf and change the innodb_buffer_pool_size = 2.8G
Hey guys
Rohit that sounds great about the performance improvement. Regarding the
questions
root admin, domain admin and/or user accounts
Yes, for all users/projects/accounts etc
multiple management servers
2 management servers, but our front is pointing to only one
+---
Hi Ricardo,
Thanks for sharing, in addition to what Simon has asked; can you also share if
this behaviour is consistent across different types of account (root admin,
domain admin and/or user accounts) and domains, was there any change in the
infrastructure after which this was observed?
We've
Kuasar,
How big is your installation, and what do you have your MySQL
innodb_buffer_pool_size set to?
Are you running a single, or multiple management servers?
-Si
On Fri, Aug 25, 2023 at 8:43 AM Kuasar
wrote:
> Hi Rohit,
>
> Thanks for you prompt reply.
>
> Could you say try with a MySQL 8.
Hi Rohit,
Thanks for you prompt reply.
Could you say try with a MySQL 8.x?
We are having this problem in production which is bigger and changing the db
engine right now will take us weeks
you could try Ubuntu 22.04/20.04
Yes, we are using Ubuntu 20.04
Can you measure (say using dev tools of
Hi Ricardo,
Thanks for sharing. I can't say without more details on how to reproduce the
env/condition, or look at the DB server. It might be statistics or something
else, you could try to log mysql queries and see if they're slow(ing down).
Could you say try with a MySQL 8.x server and use a d
