… perform non locking reads, meaning unless you use some modifiers such as LOCK IN SHARE MODE or FOR UPDATE, SELECT statements will not lock any rows… statement will perform locking read (shared locks) for table2 table. It also applies to similar tables with where clause and joins. It is important…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…commanual interactive_timeoutblogpercona.commanual join_buffer_sizeblogpercona.commanual …local_infileblogpercona.commanual lock_wait_timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual…server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…as for read-write locks. For these information both for exclusive locks and for shared locks is displayed. OS…iz` trx id 0 42313620 lock_mode X locks rec but not gap Record lock, heap no 5 PHYSICAL … kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one…
