MySQL Forums
Forum List  »  MySQL Workbench

Re: Memory governor for Workbench
Posted by: Beeling Chang
Date: November 22, 2018 12:47PM

MySQL workbench is hosted on a server for shared usage. So we don't really have control over how they use the tool and how long is being used. We did observe the memory spike for some processes (each user has its own workbench process). A single workbench process can take 7-10 GB memory. If 10 users are running this tool simultaneously, the server can hit 100% memory consumption (32GB). This also cause the Windows page file grow over 100GB!!!
Eventually, the server became unresponsive and we have to reboot it. That is the reason why we want to governor memory per user/process. if they consume more with bad query, it will only run OOM for their own process and will not bring down others.
In SQL Workbench/J, we can configure (vm.heapsize.preferred = 4096) so that each process won't go over 4GB. What about MySQL Workbench?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
61
November 21, 2018 03:59PM
19
November 21, 2018 07:21PM
27
November 21, 2018 09:53PM
30
November 22, 2018 02:01AM
Re: Memory governor for Workbench
19
November 22, 2018 12:47PM
17
November 30, 2018 04:49PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.