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