The reason I don't use version 4.0 is that it is a development alpha version. I do not know when it will be beta or considered stable like 3.23.xx. I have foreign key references in the schema (same model as for other dbs we support) and though up to version 3.23.43, these foreign key references do nothing, for version 4.0 they will be exercised. Looking at the syntax for version 4.0 for ALTER TABLE you have a subcommand DISABLE KEYS and the documentation says it disables secondary indexes, which is not the same as disabling referential integrity.
In version 4.0, do these foreign keys generate secondary indexes? Regards, Gisella -----Original Message----- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 2:38 PM To: Gisella Saavedra; [EMAIL PROTECTED] Cc: Miguel Angel Solórzano Subject: RE: deadlock - Innodb Monitor 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
