Re: How Do I Know If mySQL is using MyISAM or InnoDB?
Hi, If you are particular about a table, i.e what engine my table uses? Try, mysql > show table status like 'tablename' \G Thanks ViSolve DB Team. - Original Message - From: "John Kopanas" <[EMAIL PROTECTED]> To: Sent: Friday, November 17, 2006 10:43 PM Subject: How Do I Know If mySQL is using MyISAM or InnoDB? Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How Do I Know If mySQL is using MyISAM or InnoDB?
show variables like 'table_type'; (MySQL 4) show variables like 'storage_engine'; (MySQL 5) Both of these work. However, in future releases of MySQL table_type will goes away because it was kept from backward compatiblity with MySQL 4 - Original Message - From: Mike Kruckenberg <[EMAIL PROTECTED]> To: John Kopanas <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB? For any specific table if you do: show create table ; It will tell you what the able was created using. To create tables using a specific engine add ENGINE= to the end of your create statement. To see the default that is used (I think this is what the table_type variable does): mysql> show variables like 'table_type'; +---++ | Variable_name | Value | +---++ | table_type| MYISAM | +---++ 1 row in set (0.00 sec) John Kopanas wrote: > Is there a command at the command line that can tell me if I am using > MyISAM > or InnoDB? Thanks :-). > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How Do I Know If mySQL is using MyISAM or InnoDB?
This is in 4.0, it has changed in more recent versions. Mike Kruckenberg wrote: For any specific table if you do: show create table ; It will tell you what the able was created using. To create tables using a specific engine add ENGINE= to the end of your create statement. To see the default that is used (I think this is what the table_type variable does): mysql> show variables like 'table_type'; +---++ | Variable_name | Value | +---++ | table_type| MYISAM | +---++ 1 row in set (0.00 sec) John Kopanas wrote: Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How Do I Know If mySQL is using MyISAM or InnoDB?
For any specific table if you do: show create table ; It will tell you what the able was created using. To create tables using a specific engine add ENGINE= to the end of your create statement. To see the default that is used (I think this is what the table_type variable does): mysql> show variables like 'table_type'; +---++ | Variable_name | Value | +---++ | table_type| MYISAM | +---++ 1 row in set (0.00 sec) John Kopanas wrote: Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How Do I Know If mySQL is using MyISAM or InnoDB?
show variables like 'storage_engine'; I forgot the underscore in the lastmessage - Original Message - From: Rolando Edwards <[EMAIL PROTECTED]> To: John Kopanas <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:30:51 PM GMT-0500 US/Eastern Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB? This is will tell you your default storage engine type should you create a table without specifying an engine: show variables like 'storage engine'; If you want to create a table with a specific engine, specify it at the end od the CREATE TABLE like this: CREATE TABLE ( ... ) ENGINE=MyISAM; CREATE TABLE ( ... ) ENGINE=InnoDB; To show what engines are available on your MySQL server, do this: show engines; - Original Message - From: John Kopanas <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern Subject: How Do I Know If mySQL is using MyISAM or InnoDB? Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How Do I Know If mySQL is using MyISAM or InnoDB?
This is will tell you your default storage engine type should you create a table without specifying an engine: show variables like 'storage engine'; If you want to create a table with a specific engine, specify it at the end od the CREATE TABLE like this: CREATE TABLE ( ... ) ENGINE=MyISAM; CREATE TABLE ( ... ) ENGINE=InnoDB; To show what engines are available on your MySQL server, do this: show engines; - Original Message - From: John Kopanas <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern Subject: How Do I Know If mySQL is using MyISAM or InnoDB? Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How Do I Know If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info