At 13:50 31/10/2001 -0800, Gisella Saavedra wrote: Gisella, The 3.23.xx tree wasn't compiled with flag for to shows the semaphores section. The sample I sent was using the 4.0.0-alpha release. Why you don't try this release ?
Regards, Miguel >Miguel & Heikki, > >I tried > mysqld-max-nt --standalone --console >and now get the output on stdout, and mysql.err is not created. > >BUT I still get the message non-debug version >under the SEMAPHORES section. > >Gisella > >-----Original Message----- >From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, October 31, 2001 1:15 PM >To: Heikki Tuuri; [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED]; Gisella Saavedra >Subject: Re: deadlock - Innodb Monitor > > >At 22:52 31/10/2001 +0200, Heikki Tuuri wrote: > >Heikki, > >For you to have at the shell prompt the output is necessary >the command: mysqld-max-net --standalone --console > >Like I show below: > >Microsoft Windows 2000 [Versăo 5.00.2195] >(C) Copyright 1985-1999 Microsoft Corp. > >C:\>cd\mysql\bin > >C:\mysql\bin>mysqld-max-nt --standalone --console >011031 19:08:59 InnoDB: Started >mysqld-max-nt: ready for connections >===================================== >011031 19:11:05 INNODB MONITOR OUTPUT >===================================== >---------- >SEMAPHORES >---------- >OS WAIT ARRAY INFO: reservation count 4, signal count 4 >Mutex spin waits 0, rounds 0, OS waits 0 >RW-shared spins 4, OS waits 2; RW-excl spins 2, OS waits 2 >------------ >TRANSACTIONS >------------ >Purge done for all trx's with n:o < 0 1795, undo n:o < 0 0 >Total number of lock structs in row lock hash table 0 >-------- >FILE I/O >-------- >I/O thread 0 state: wait windows aio for n pages >I/O thread 1 state: wait windows aio for n pages >I/O thread 2 state: wait windows aio for n pages >I/O thread 3 state: wait windows aio for n pages >Pending normal aio reads: 0, aio writes: 0, > ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 >Pending flushes (fsync) log: 0; buffer pool: 0 >61 OS file reads, 3 OS file writes, 0 OS fsyncs >0.48 reads/s, 0.02 writes/s, 0.00 fsyncs/s >------------- >INSERT BUFFER >------------- >Ibuf for space 0: size 1, free list len 0, seg size 2, >0 inserts, 0 merged recs, 0 merges >--- >LOG >--- >Log sequence number 0 49463 >Log flushed up to 0 49463 >Last checkpoint at 0 47975 >0 pending log writes, 0 pending chkp writes >8 log i/o's done, 0.06 log i/o's/second >---------------------- >BUFFER POOL AND MEMORY >---------------------- >Total memory allocated 112635463; in additional pool allocated 177568 >Free list length 5082 >LRU list length 37 >Flush list length 10 >Buffer pool size 5120 >Pending reads 0 >Pending writes: LRU 0, flush list 0, single page 0 >Pages read 36, created 1, written 0 >0.28 reads/s, 0.01 creates/s, 0.00 writes/s >Buffer pool hit rate 798 / 1000 >-------------- >ROW OPERATIONS >-------------- >InnoDB main thread state: sleeping >Number of rows inserted 0, updated 0, deleted 0, read 0 >0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s >---------------------------- >END OF INNODB MONITOR OUTPUT >============================ > >Regards, >Miguel > >Gisella, > > > > >Heikki, > > >I looked at the mysql error log and all the stuff was there. > > >I was expecting it on the standard output as the documentation said. > > > >it should come to the standard output. I am sending a copy > >of this email to Miguel of MySQL AB. He should check why > >mysqld started as --standalone redirects stdout to > >mysql.err. When mysqld is run as a service it should go to > >mysql.err, but not when run as standalone. By the way, are > >you sure you did not have two mysqlds running in your > >computer? What does the processlist in the Task Manager say? > > > > >Thanks again. I'll have to restart the server again since the > > >innodb monitor output on the error log says that I'm not running a >debugable > > >version, so there is no information about locking. So, I should issue > > > >It actually means 'no information about semaphore locking'. > >You will get the user lock info with > > > >innodb_lock_monitor > > > >not with plain innodb_monitor. > > > > > mysqld-max-nt --debug --standalone > > >Nothing was printed on stdout when I issued > > > mysqld-max-nt --standalone > > >Gisella > > > >Regards, > > > >Heikki > >-- >For technical support contracts, goto https://order.mysql.com/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer >/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil > <___/ www.mysql.com > > >--------------------------------------------------------------------- >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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
