高并发时mysql使用的连接数无法达到最大连接数
操作系统centos7.6+mysql8.0
我的项目使用的是springboot2.6.10 + druid连接池
我的druid连接池配置 application文件
#数据库配置
spring.datasource.url=jdbc:mysql://192.168.160.123:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
db.type=MySQL
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=600
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
spring.datasource.filters=stat,wall,log4j
spring.datasource.druid.WebStatFilter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*
-----------------------------------------------------------------
mysql的my.cnf配置参数如下
[client]
port=3306
socket=/var/opt/mitec/mysql/mysql.sock
[mysqld]
log-bin=mysql-bin
datadir=/var/opt/mitec/mysql
socket=/var/opt/mitec/mysql/mysql.sock
lower_case_table_names = 1
server-id=1
skip_ssl
character-set-server = utf8
character-set-filesystem = utf8
init_connect='SET NAMES utf8'
default-time_zone = '+8:00'
default-storage-engine=INNODB
log-error=/var/opt/mitec/mysql/mi_error.log
general_log=OFF
general_log_file=/var/opt/mitec/mysql/mysql.log
server-id= 1
expire_logs_days = 30
innodb_buffer_pool_size = 8G
innodb_log_buffer_size = 16M
innodb_log_file_size = 64M
max_connections = 15000
slow_query_log = 0
binlog_format=mixed
lower_case_table_names = 1
back_log = 600
open_files_limit = 65535
binlog_cache_size = 1M
max_heap_table_size = 16M
tmp_table_size = 16M
read_rnd_buffer_size = 8M
table_open_cache = 2048
max_allowed_packet = 32M
read_buffer_size = 6M
read_rnd_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size=64
key_buffer_size = 384M
sort_buffer_size = 6M
wait_timeout = 38400
innodb_file_per_table = 0
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
interactive_timeout = 28800
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
collation-server=utf8_general_ci
default_authentication_plugin=mysql_native_password
[mysqld_safe]
