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
