[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: deadlock - Innodb Monitor
From:       Heikki Tuuri <Heikki.Tuuri () innobase ! inet ! fi>
Date:       2001-10-31 22:57:10
[Download RAW message or body]

Gisella,

sorry, the printout in InnoDB Monitor is
ambiguous in its words: non-debug version
there means a version not compiled with

#define UNIV_SYNC_DEBUG

in univ.i

The monitor in .44 does not use the ambiguous
term any more.

But you do not need semaphore info, only user
lock info. When I spoke about a "semaphore"
row I used apostrophes because it does the
job of a "semaphore" though it is actually
about user locks.

Locks set in transactions are user locks.
Semaphores are internal guards set by the
C/C++ code in InnoDB and MySQL.

Regards,

Heikki



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread89679@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]