View Revisions: Issue #3727

Summary 0003727: MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id
Revision 2018-09-19 13:39 by hanes
Description user guide should reflect the need to grant the PROCESS priv due to the following:

"We had to change the way we looked up the transaction id for MySQL versions after 5.7.6. Prior to 5.7.6 we used:

select VARIABLE_VALUE from INFORMATION_SCHEMA.SESSION_STATUS where VARIABLE_NAME='COM_COMMIT';

Post 5.7.6 we are using:

select TRX_ID from INFORMATION_SCHEMA.INNODB_TRX where TRX_MYSQL_THREAD_ID = CONNECTION_ID();
"
Revision 2018-09-19 13:36 by hanes
Description user guide should reflect the need for the grant PROCESS priv due to the following:

"We had to change the way we looked up the transaction id for MySQL versions after 5.7.6. Prior to 5.7.6 we used:

select VARIABLE_VALUE from INFORMATION_SCHEMA.SESSION_STATUS where VARIABLE_NAME='COM_COMMIT';

Post 5.7.6 we are using:

select TRX_ID from INFORMATION_SCHEMA.INNODB_TRX where TRX_MYSQL_THREAD_ID = CONNECTION_ID();
"