Recommended DSN connection settings

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

which version of the driver are you running?

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

version?

Oops…

Version 5.1.38

so, try the latest and see if that helps?