MySQL Server Questions (FireDAC)
Go Up to FAQ (FireDAC)
This topic contains a list of questions and answers related to MySQL Server.
Q1: Is there a way to use MySQL C API function mysql_thread_id from FireDAC?
A: Yes, although a bit cryptic:
- FDConnection1.ConnectionIntf.Driver.CliObj - returns a reference to TMySQLLib;
- FDConnection1.ConnectionIntf.CliObj - returns a reference to TMySQLSession, which has MySQL property;
- all together:
uses FireDAC.Phys.MySQLCli, FireDAC.Phys.MySQLWrapper; ... with FDConnection1.ConnectionIntf do TMySQLLib(Driver.CliObj).mysql_thread_id(TMySQLSession(CliObj).MySQL);
Q2: Updating BLOB field with data greater than 512 KB on MySQL causes "MySQL server has gone away" error
A: Please see http://dev.mysql.com/doc/refman/5.0/en/gone-away.html, which suggests to increase max_allowed_packet.
Q3: Is it possible to establish a SSL connection to a MySQL server?
A: Yes, it is possible. See Connect to MySQL Server, Using a Secure Connection.
Q4: Why does the application hang for a few seconds at exiting? I am using only MySQL connection
A: If your application creates threads, this issue is possible with libmysql.dll v5.x. Please see http://bugs.mysql.com/bug.php?id=37226 for details. As a workaround, try to terminate all threads before terminating the application.