Database [connection과 pool-05] pool 생성이 너무 많은 경우의 database에서의 에러 - Too many connections

    [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> 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