Re: Unexpected Innodb table lock
Also, I was very hopeful that the link you sent on the "INFORMATION SCHEMA" was going to give me some good details, but none of the ones listed contain any data. It says:
'INFORMATION_SCHEMA.INNODB_LOCKS' is deprecated and will be removed in a future release.
'INFORMATION_SCHEMA.INNODB_LOCK_WAITS' is deprecated and will be removed in a future release.
and the INNODB_TRX table is empty.
Here is the version Im running. Should I look elsewhere?
'innodb_version', '5.7.23'
'protocol_version', '10'
'slave_type_conversions', ''
'tls_version', 'TLSv1,TLSv1.1'
'version', '5.7.23-log'
'version_comment', 'MySQL Community Server (GPL)'
'version_compile_machine', 'x86_64'
'version_compile_os', 'Win64'
Subject
Written By
Posted
February 15, 2019 09:13AM
February 15, 2019 09:52AM
February 15, 2019 10:09AM
February 15, 2019 02:07PM
February 15, 2019 02:21PM
February 15, 2019 03:51PM
February 19, 2019 08:28AM
February 19, 2019 12:25PM
February 22, 2019 08:04AM
Re: Unexpected Innodb table lock
February 19, 2019 09:01AM
February 15, 2019 10:20AM