Mysql connection sharing in python
<p>I am working on an application which uses multiprocessing module of python to fork new processes when required. Now each sub process need to access the database to read or insert data. I am currently opening a new connection for each sub process. I want to know whether it is a good approach to open new connection for every sub process or only one connection should be shared amongst the processes. Also what is the maximum number of connections mysql can open? What if the number of sub processes become more than this limit? </p>

<p>Please advice on the best approach to follow for connecting to database in a multiprocessing environment.</p>
