Python MySQL Tutorial | MYSQL Databases and Connection Pooling | Get Connection From Connection Pool

Python MySQL Tutorial | MYSQL Databases and Connection Pooling | Get Connection From Connection Pool
#python #codeasitis #pythonmysql #mysql #connectionpool

A database connection allows client software to talk to database server. A connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.

Database connections and connection pooling allow us too:
* Exchange data in both directions between a MYSQL and an application program.
* Manage relationships in MYSQL and how they translate into the programming languages in memory model.
* Manage differences in data type between programming language and SQL
* Increase system performance by decreasing overhead for CPU and memory by managing a connection pool.

**********
To learn Python, start our Python Playlist HERE:

**********
**********
Connect with us!

**********

Thank you!
CodeAsItIs

[ydgaming]

Hi! I'm using the same code, and trying to test negative test case by putting wrong credentials, it is not expecting exception block. Can you please guide me into this.?

[leonwinkel]

thanks for the video! You said we can set the pool size to 1000, what i would need is much more than that. When i set it to anything higher than 32 ill get an exception (also in the error you created after setting it to 0 it was said only up to 32 connections) do you have an idea how we can create a pool of more than that?