ESS to MySQL (5.6) from FMServer 15 on windows 2012r2
Script in FM which does the following:
Enter data in 2 fields on TABLE1 in MySQL
Change layout to another table in MySQL (Same database)
Enter data in 4 fields on TABLE2 in MySQL
This opens 2 connections to MySQL server.
Change record on TABLE1
run script again
2 more connections to MySQL are opened
If you keep paging through the found set, running the script each time, you will max out the connections to MySQL.
Quitting FM Client and 2 minutes later the connections to MySQL will all drop.
MySQL wait_timeout is 5 minutes so FM is doing the open/close.
Running the same process with FM16 clients - no new connections made.