Re: Table_locks_immediate and Innodb Selects

2005-11-08 Thread Heikki Tuuri
ansactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php . List: mysql Subject:Re: Table_locks_immediate and Innodb Selects From: Gleb Pahar

Re: Table_locks_immediate and Innodb Selects

2005-11-08 Thread Gleb Paharenko
Hello. In my opinion, it is just for some statistics. The variable locks_immediate (which corresponds to Table_locks_immediate) is incremented very often in mysys/thr_lock.c in this way: statistic_increment(locks_immediate,&THR_LOCK_lock); lee wrote: > Why would a simple select a