Check active transactions

[miguelenguica]

Hi.

Is there a way to check the number of active transactions (on the database, not on the local UniConnection component) at any given time, using MySQL + UniConnection?


Thanks.

[DemetrionQ]

Hello.

TUniConnection allows to retrieve the information about the state of the current connection only. As for questions concerning retrieving information about all transactions for all connections to the server, please forward them to MySQL support.

If you need to check if the table is locked, you can do this using the 'SHOW OPEN TABLES' SQL command ( http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html ), for example:

Code: Select all

SHOW OPEN TABLES WHERE in_use <> 0 AND `Table` = 'YourTable' AND `Database` = 'YourDatabase';