Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mysql connection pool?
#1
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Virtual Env changing mysql connection string in python Fredesetes 0 322 Dec-20-2023, 04:06 PM
Last Post: Fredesetes
  Mysql and mysql.connector error lostintime 2 610 Oct-03-2023, 10:25 PM
Last Post: lostintime
  Multiprocessing Pool Multiple Instances How to Kill by Pool ID sunny9495 0 735 Nov-16-2022, 05:57 AM
Last Post: sunny9495
  Mysql error message: Lost connection to MySQL server during query tomtom 6 15,673 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  Python MYSQL connection does not work after 1h idle zazas321 9 6,616 Oct-07-2021, 12:02 PM
Last Post: ndc85430
  Serial connection connection issue Joni_Engr 15 7,828 Aug-30-2021, 04:46 PM
Last Post: deanhystad
  Pool multiprocessing - know current status in loop? korenron 0 1,604 Jul-28-2021, 08:49 AM
Last Post: korenron
  pool mysql error - not catch by try\except? korenron 1 2,101 Jul-05-2021, 11:26 AM
Last Post: ibreeden
  Process (pool,map) strange behaviour maverick76 1 1,913 Feb-03-2020, 02:43 PM
Last Post: maverick76
  How to use pool.map effectively? AlekseyPython 10 6,335 Oct-11-2019, 05:50 AM
Last Post: AlekseyPython

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020