Hi Jenny, mysql> SHOW VARIABLES LIKE '%have%'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | have_bdb | YES | | have_crypt | NO | | have_innodb | YES | | have_isam | YES | | have_raid | NO | | have_symlink | YES | | have_openssl | NO | | have_query_cache | YES | +--------------------+-------+ 8 rows in set (0.03 sec)
You might find the following helpful http://www.codeant.com/tutorials/mysql/MySQLTutorial.html Matt -----Original Message----- From: Chen, Jenny [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 10:23 AM To: '[EMAIL PROTECTED]' Subject: InnoDB MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]