[Maria-discuss] System lock thread state

2019-07-24 Thread mariadb
On a system with skip-external-locking = ON, why would I ever see a thread state of "System lock" on a MyISAM table? This documentation: https://mariadb.com/kb/en/library/general-thread-states/ suggests that "... MyISAM storage engine uses file-based locks. However, MyISAM's external locks are

Re: [Maria-discuss] System lock thread state

2019-07-24 Thread Daniel Black
On Wed, 24 Jul 2019 14:00:05 -0400 mari...@biblestuph.com wrote: > On a system with skip-external-locking = ON, why would I ever see a > thread state of "System lock" on a MyISAM table? Explicit "FLUSH TABLES WITH READ LOCK" in effect in one of the threads I assume. ___