The number of Tomcat threads combined with MySQL connection tuning

At present, the online system contains data collection + Data analysis + Center services, three are Tomcat, a common MySQL service.

Since Tomcat has a maximum number of threads of 200 * = 600, the maximum concurrency will be 600 jdbc connections. This is, of course, an extreme situation.

The data Analysis service does not require high concurrency, so it sets its maximum number of threads to 200,JDBC maximum active connection 30.

The central service is not high-concurrency at the moment, and TPs is 10.

The receipt collection belongs to high concurrency, TPS 150.

So, tuning measures: Set MySQL maximum connection number to 200. Data analysis JDBC Active Connection 30 (avoid wasting leading to max_connections)

The number of Tomcat threads combined with MySQL connection tuning