Hi Akhilesh , @akhilesh.s
Thanks for your response. Yes, we are using MySql as external database for GitLab servers. Recently we have seen a issue with related huge groups [ with members almost 1700 as of now this could reach 2000].
We have two huge groups AB and CD with members 1700 and 800 members in it. Our teams use group/sub group concept for their development process. Let me explain in detail.
Team : Group structure looks like, Main group XY, Subgroup YZ and under the sub group they have lot of projects. They want to share these projects to large groups whenever needed. So they took a project and shared with AB and CD large groups. When they did that it was shared without any issue for 800 members group. But, when they shared with 1600 members group our instance stopped responding for a while [ more than a minute or so] with 500 error and its kind ON/OFF situation gitlab page is coming back and going again into 500 error. I have checked log file and seen this below error ,
Started POST “/api/v3/groups/eg-dt-esw-agency-employees/members” for xx.xx.xx.xxx at 2018-03-08 11:00:09 -0600
Mysql2::Error (User paramm already has more than ‘max_user_connections’ active connections):
So I am thinking this will be fixed when we increase the max_user_connection value. But now our leader groups want to use these type of large main groups for every team. That means we will be end of having lots of 2000 member groups.
We are using version - GitLab Community Edition 9.1.2
Do you think this is something we can handle without comprising any performance and errors ?