Recommended DSN connection settings


#1

Can I ask what settings folks recommend or use for connectionTimeout and connectionLimit in your dsn and why?

I’m using Lucee 5.2.6.59-RC and mysql 5.6 with the above setting default values. I had a issue where connections spiked from 30 to 250 within a couple of minutes. No increase in traffic or db CPU at that time and rendered all servers unable to connect to the db.

Regards,
Adam


#2

which version of the driver are you running?


#3

class: ‘org.gjt.mm.mysql.Driver’


#4

version?


#5

Oops…

Version 5.1.38


#6

so, try the latest and see if that helps?