node-mysql2

node-mysql2 copied to clipboard

Pooling connections destroy

2

Created a config property `idleTime` to destroy the pool connection.If not set then it will work as default.

saravjotsingh

Is it possible to create a pool from a connection string?

5

For example, to create a single connection using a connection string we do: ``` mysql.createConnection(connectionString); ``` I can't seem to find a way to do the same to create a...

rcoundon

Element implicitly has an 'any' type because expression of type '0' can't be used to index type 'RowDataPacket[] | RowDataPacket[][] | OkPacket | OkPacket[] | ResultSetHeader'. Property '0' does not exist on type 'RowDataPacket[] | RowDataPacket[][] | OkPacket | OkPacket[] | ResultSetHeader'. When trying to access any index of the result parameter in the callback

4

Hi there so I have this code ```ts static async getById(id: string): Promise { return new Promise((resolve, reject) => { connection.execute( "SELECT * FROM business WHERE ID = ?;", [id],...

destroyer22719

Fix backpressure when using TLS

1

This PR fixes two related issues when using TLS: - Using LOAD DATA LOCAL, backpressure is not respected, causing out of memory errors if the data stream supplied by infileStreamFactory...

vobarian

Add taggedExecute helper

6

RFC at this stage, but I think the feature was mentioned / requested few times in the past and looks like a safe and useful addition At this stage I...

sidorares

How to set another collation (utf8mb4_unicode_ci)?

2

Hi! I have a database with next settings `CREATE DATABASE catabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;` When i send cyrillic symbols ('привет') thru my app, i get '???????' on database...

Hellek

Warning: got packets out of order. Expected 10 but received 0

11

Error has been occuring for a while, happens after a while where the bot will error. I recently upgraded from mysql to mysql2 to see if it would fix the...

chriscousinsdev

How to handle exceptions which returned from MySQL stored procedure - TypeScript

2

Consider the below code (TypeScript), I m trying to call MYSQL procedure using connection pool. ```ts const mysql = require( 'mysql2/promise'); import { config } from '../config/config'; const pool =...

arjunankv1980

Process crash/end when do pool.query without internet

2

Hi everyone, I have error (with process end): ``` events.js:292 throw er; // Unhandled 'error' event ^ Error: connect EHOSTUNREACH 45.67.57.43:3306 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1146:16) Emitted 'error' event on...

ferogot

Commit with pool

3

I have a script that is inserting tons of rows inside a mysql table. At the end of the script I do: 1) At the beginning of the script: Create...

frankred