Tomcat+Mysql high concurrency configuration optimization explanation

1.Tomcat Optimization Configuration

(1) Change Tomcat's catalina.bat

Change Java to server mode, increase the memory of jvm, and add

setJAVA_OPTS=-server -Xms1024m -Xmx2048m -Xss512K -XX:PermSize=128m -XX:MaxPermSize=256m
setCATALINA_OPTS=-server -Xms512m -Xmx512m

As shown below:

Xms: Initial memory

Xmx: Maximum memory

(2) Change Tomcat's Server.xml

Add the following configuration in <Servicename="Catalina"> (tested, 2000 concurrent connections within 10 seconds are no problem).

<Executorname="tomcatThreadPool" namePrefix="catalina-exec-"
maxThreads="800"minSpareThreads="25" maxIdleTime="60000"/>
<Connectorexecutor="tomcatThreadPool"
port="80"protocol="HTTP/1.1"
connectionTimeout="60000"
keepAliveTimeout="15"
maxKeepAliveRequests="200"         
           disableUploadTimeout="false"
           enableLookups="false"
redirectPort="8443"/>

Note that the maxThreads number should not be adjusted too large, which may easily cause the following errors:

2. Optimize MySQL configuration

(1) Change MySql's my.ini (windows) or my.cnf (linux)

max_connections=12000 //The maximum number of connections is generally between 0 and 15000, try not to exceed 15000
max_user_connections=0 // Maximum number of user connections, 0 means no limit interactive_timeout=31536000 // Timeout, set to one year to avoid the following error in the connection pool wait_timeout=31536000

query_cache_size=512m //Query cache, try to set it larger to avoid the following error

key_buffer_size=1024m
query_cache_type = 1
max_allowed_packet=600m

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links

You may also be interested in:

MySQL Series 10 MySQL Transaction Isolation to Implement Concurrency Control
Detailed explanation of MySQL multi-version concurrency control mechanism (MVCC) source code
Implementation of MySQL's MVCC multi-version concurrency control
MySQL high concurrency method to generate unique order number
MySQL lock control concurrency method
Mysql transaction concurrency problem solution
How to solve the high concurrency problem in MySQL database
MySQL concurrency control principle knowledge points
Implementation of MySQL multi-version concurrency control MVCC
How to handle concurrent updates of MySQL data
How does MySQL achieve multi-version concurrency?

<<: Vue3+TypeScript encapsulates axios and implements request calls

>>: Solution to 1449 and 1045 exceptions when connecting to MySQL

In-depth explanation of the style feature in Vue3 single-file components

Tomcat+Mysql high concurrency configuration optimization explanation

In-depth explanation of the style feature in Vue3 single-file components

Example of how to increase swap in CentOS7 system

HTML implements a fixed floating semi-transparent search box on mobile

How to install and deploy ftp image server in linux

Example code for text origami effect using CSS3

Vue3+script setup+ts+Vite+Volar project

Detailed explanation of mysql partition function and example analysis

Detailed process of implementing the 2048 mini game in WeChat applet

Webpack builds scaffolding to package TypeScript code

Detailed explanation of Vue advanced construction properties

Recommend

Dynamic SQL statement analysis in Mybatis

Detailed explanation of outfile, dumpfile, load_file functions in MySQL injection

Diagram of the Hyperledger Fabric 1.4 environment construction process under Windows 10

Introduction to Kubernetes (k8s)

MySQL 8.0.22 decompression version installation tutorial (for beginners only)

The pitfalls encountered when learning Vue.js

Detailed explanation and practical exercises of Mysql tuning Explain tool (recommended)

Sample code for nginx to achieve dynamic and static separation

Solution to the problem that the page is blank when opening the page with source file in IE7

MySQL 5.7.24 installation and configuration method graphic tutorial

Detailed explanation of the concept of docker container layers

About Vue's 4 auxiliary functions of Vuex

How to use Font Awesome 5 in Vue development projects

How to use lodop print control in Vue to achieve browser compatible printing

Implementation of mysql using mysqlbinlog command to restore accidentally deleted data