Cool. Thanks, John. --Walt
-----Original Message----- From: John Kemp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:06 PM To: Weaver, Walt Cc: [EMAIL PROTECTED] Subject: Re: innoDB confusion Walt, It'll go to the database_machine_name.err file on that machine. John Weaver, Walt wrote: > Heikki, > > I must be missing something really simple here, but I can't get the InnoDB > Monitor to work. I created the innodb_monitor table with "create table > innodb_monitor(a int) type=innodb;" > > What do I do next? The manual says mysqld will print the output to stdout. I > guess I'm confused as to how I capture this. > > I'm running on Linux Redhat 6.2 with the 2.4 kernel, mysql 3.23.44. > > Thanks, > -- Confused In Bozeman > > -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 11:18 AM > To: [EMAIL PROTECTED] > Subject: Re: innoDB confusion > > > Hi! > > "Weaver, Walt" wrote in message ... > >>Do a "show table status" at the mysql prompt. Under "type" you should see >>InnoDB. >> > > Yes, and in really problematic situations, where you have lost your .frm > files, for example, you can use innodb_table_monitor as explained in the > InnoDB online manual. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at https://order.mysql.com/ > See http://www.innodb.com for the online manual and latest news on InnoDB > > >>--Walt Weaver >> Bozeman, Montana >> >>-----Original Message----- >>From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, January 15, 2002 10:57 AM >>To: Mysql List (E-mail) >>Subject: RE: innoDB confusion >> >> >>One final question, and I am done. You have helped me >>tremendously--thank you. Wow, I really didn't expect the developer of >>the software to answer my questions--this is terrific. >> >>Is there way to verify that the tables I create are in the InnoDB >>tablespace? I am assuming that if I set 'default-table-type=innodb' in >>my.ini that all tables created by the MySQL client will be created in >>the innodb tablespace. However, they also show up in the MySQL data >>directory as .frm files. How do I also know that it was created in the >>InnoDB tablespace? Aaron >> > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- > 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 > > . > > --------------------------------------------------------------------- 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