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
