AnsweredAssumed Answered

Filemaker 17 opens mysql connections on every record

Question asked by alex.hellier on Dec 14, 2018
Latest reply on Mar 11, 2019 by mrwatson-gbs

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

Commit

Change layout to another table in MySQL (Same database)

Enter data in 4 fields on TABLE2 in MySQL

Commit.

 

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.

Outcomes