mysql connection pool?

[MuntyScruntfundle]

Ho folks.

I need to use a mysql connector to write/read data to/from a table every few seconds.

In terms of keeping overhead as low as possible, what should I keep/reuse/delete? Does the unix/python connector pool the same as Windows, or do I need to be more careful and keep a cursor open?

The read thread will only ever be reading and the write thread will only ever be writing.

Thanks.