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
177
November 21, 2018 03:59PM
72
November 21, 2018 07:21PM
93
November 21, 2018 09:53PM
112
November 22, 2018 02:01AM
Re: Memory governor for Workbench
75
November 22, 2018 12:47PM
85
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.