MySQL Connector/Python Release Notes
close() is a synonym for
Section 10.2.20, “MySQLConnection.disconnect() Method”.
For a connection obtained from a connection pool,
close() does not actually close it but
returns it to the pool and makes it available for subsequent
connection requests. See
Section 9.2, “Connector/Python Connection Pooling”.