requested global read lock.
All tables are myisam. MariaDB is 10.0.22 (mysql 5.6 based as i understand)
Artem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
? And both lock tables and delete requested global read lock.
All tables are myisam. MariaDB is 10.0.22 (mysql 5.6 based as i
understand)
Artem
You gave the answer in your last statement: "All tables are myisam" .
The MyISAM storage engine is not transactional and it does not do
On 12/9/2015 12:06 PM, Artem Kuchin wrote:
09.12.2015 19:35, shawn l.green пишет:
INSERT operations are special as you can enable a mode to allow
INSERTs to happen only at the end of the file and not be blocked while
one of the other two operations are in progress.
Cannot find anything
09.12.2015 19:35, shawn l.green пишет:
On 12/9/2015 9:59 AM, Artem Kuchin wrote:
Hello!
|THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE
TABLE_SCHEMATABLE_NAME
268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock
270022 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global
On 12/9/2015 11:59 AM, Artem Kuchin wrote:
09.12.2015 19:35, shawn l.green пишет:
On 12/9/2015 9:59 AM, Artem Kuchin wrote:
Hello!
|THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE
TABLE_SCHEMATABLE_NAME
268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock
270022
Artem -
> |THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA
> TABLE_NAME
> 268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock
> 270022 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global read lock
> 268871 MDL_SHARED_NO_READ_WRITEMDL_EXPLICITTable
09.12.2015 19:35, shawn l.green пишет:
INSERT operations are special as you can enable a mode to allow
INSERTs to happen only at the end of the file and not be blocked while
one of the other two operations are in progress.
Cannot find anything about that. Can you be a little more