Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Increasing MySQL Connection Count

DZone's Guide to

Increasing MySQL Connection Count

· Java Zone
Free Resource

Just released, a free O’Reilly book on Reactive Microsystems: The Evolution of Microservices at Scale. Brought to you in partnership with Lightbend.

Checking max number of MySQL Connection

show variables like 'max_connections';

Let increase the size of connection count 250

SET global max_connections = 250;

Max size of increment size is up to 100,000

image

Strategies and techniques for building scalable and resilient microservices to refactor a monolithic application step-by-step, a free O'Reilly book. Brought to you in partnership with Lightbend.

Topics:

Published at DZone with permission of Madhuka Udantha, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}