sitelink1 | https://blog.naver.com/pjt3591oo/221505148267 |
---|---|
sitelink2 | |
sitelink3 | |
extra_vars4 | |
extra_vars5 | |
extra_vars6 |
[TextRow {
id: 25,
age: 27,
name: 'mung1',
createAt: 2019 - 04 - 04T00: 25: 51.000Z,
updateAt: 2019 - 04 - 04T00: 25: 51.000Z
}]
{Error: Too many connections
at Packet.asError(/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / packets / packet.js: 684: 17)
at ClientHandshake.execute(/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / commands / command.js: 28: 26)
at PoolConnection.handlePacket(/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / connection.js: 449: 32)
at PacketParser.Connection.packetParser.p[as onPacket](/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / connection.js: 72: 12)
at PacketParser.executeStart(/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / packet_parser.js: 75: 16)
at Socket.Connection.stream.on.data(/Users/bagjeongtae / Desktop / mysql / node_modules / mysql2 / lib / connection.js: 79: 25)
at Socket.emit(events.js: 189: 13)at addChunk(_stream_readable.js: 284: 12)at readableAddChunk(_stream_readable.js: 265: 11)
at Socket.Readable.push(_stream_readable.js: 220: 10)
code: 'ER_CON_COUNT_ERROR',
errno: 1040,
sqlState: '',
sqlMessage: 'Too many connections'}
mysql pool 정보 조회
- pool_size 의 default는 128MB (단위:Byte)
- pool_size는 pool_instances*pool_shunk_size 값과 같아야 한다
- pool_size/chunk_size는 100이 넘어가면 성능 이슈가 발생한다
mysql pool 설정 변경
- 커맨드 명령어로 변경
mysql> SET GLOBAL innodb_buffer_pool_size=402653184;
- Database 실행 시점에 설정
$ mysql --innodb-buffer-pool-size=2147483648 --innodb-buffer-pool-instances=4 --innodb-buffer-pool-chunk-size=1073741824;
- 설정파일에서 변경 (설정후 재시작)
[mysqld] innodb_buffer_pool_chunk_size=134217728