MySQL/MariaDB: InnoDB - Get more information about current transaction
I wanted to find out how many rows were modified by the current transaction. Seems like MariaDB doesn’t have a straight forward way to retrieve the transaction ID. To narrow down transactions I used the current connection as the thread ID. You can run the below command to check the information about the transaction.
SELECT * FROM information_schema.innodb_trx WHERE trx_mysql_thread_id = CONNECTION_ID() \G
Here is an example: