Skip to content

anonystick/mysql-create-connect-pool-multiple

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Tips JavaScriptTips JavaScript
Tips JavaScript
and
Tips JavaScript
Jun 16, 2023
ee3fadf Β· Jun 16, 2023

History

4 Commits
Jun 12, 2023
Jun 12, 2023
Jun 16, 2023
Jun 12, 2023
Jun 12, 2023

Repository files navigation

How to check

That an application with a pool of 96 connections performs almost 50x faster than one with 1000 (or 4000) connections. Even 96 connections is very large unless you have a 48-core server. Basically, the formula is this:

connections = ((core_count * 2) + effective_spindle_count)

Where "effective_spindle_count" is the number of storage disks. For a simple 4-core server with one hard disk this means 9 connection pool -- call it 10 as a round number.

πŸ‘‰ πŸ‘‰ πŸ‘‰ πŸ‘‰ Video Demo

how to test

pls view video on youtube...

About

Configuring MySQL Connection Pooling. MySQL High Availability

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published