Opened 12 years ago

Closed 12 years ago

#327 closed defect (fixed)

Per-user sql connection limit

Reported by: adehnert Owned by:
Priority: major Milestone:
Component: sql Keywords:


We relatively often hit the cap on number of database connections. We should set max_user_connections (; in addition to max_connections ( Hopefully, this will mean that a single runaway account doesn't block other users from accessing

This was previously brought up on -c scripts -i 2129340 on Sept. 26, 2012.

Change History (2)

comment:1 Changed 12 years ago by adehnert

max_connections is currently 512. I propose setting max_user_connections to, oh, 128.

comment:2 Changed 12 years ago by adehnert

  • Resolution set to fixed
  • Status changed from new to closed

I set max_user_connections to 128 in the live mysqld and in the config file on k-s and s-b, and successfully restarted k-s's mysqld. This is (hopefully) fixed. We'll see if it reduces our "too many connections" errors.

Note: See TracTickets for help on using tickets.