List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:May 23 2006 8:20am
Subject:Re: InnoDB problems under 5.1.9
View as plain text  
Logan, David (SST - Adelaide) wrote:
> Hi Ben,
> 
> Try doing
> 
> SHOW ENGINES;

Here: (pertinent cols only)

+------------+----------+--------------+-----+------------+
| Engine     | Support  | Transactions | XA  | Savepoints |
+------------+----------+--------------+-----+------------+
| CSV        | YES      | NO           | NO  | NO         |
| MEMORY     | YES      | NO           | NO  | NO         |
| MRG_MYISAM | YES      | NO           | NO  | NO         |
| InnoDB     | DISABLED | YES          | YES | YES        |
| BLACKHOLE  | YES      | NO           | NO  | NO         |
| MyISAM     | DEFAULT  | NO           | NO  | NO         |
| BerkeleyDB | DISABLED | YES          | NO  | YES        |
| ARCHIVE    | YES      | NO           | NO  | NO         |
+------------+----------+--------------+-----+------------+

Ok, now I believe this does mean I have compiled the InnoDB.

Just to save me trawling though the manual, can you tell me how I should 
enable InnoDB?

Thanks for the info!

Ben





> 
> and see what it says. It should say InnoDB is supported, if not then it
> hasn't compiled in.
> 
> Regards
> 
> ---------------------------------------------------------------
> ********** _/     **********  David Logan 
> *******   _/         *******  ITO Delivery Specialist - Database
> *****    _/            *****  Hewlett-Packard Australia Ltd
> ****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
> ****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
> ****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
> *****        _/       ******    
> ******      _/      ********  Postal: 148 Frome Street,
> ********   _/     **********          Adelaide SA 5001
>                                       Australia 
> i    n    v    e    n    t                                   
> ---------------------------------------------------------------
> 
> -----Original Message-----
> From: Ben Clewett [mailto:ben@stripped] 
> Sent: Tuesday, 23 May 2006 4:57 PM
> To: mysql@stripped
> Subject: InnoDB problems under 5.1.9
> 
> Dear MySQL,
> 
> I've installed 5.1.9 from source on a SUSE 10 box.  But I can't get 
> InnoDB tables respected.
> 
> I have used the correct compilation flag (--with-innodb).
> SHOW VARIABLES; lists all the usual innodb variables.
> The innodb table space has been created in ~/var/ibdata1.
> 
> But if I enter:
> 
> CREATE TABLE a (
>    a int NOT NULL PRIMARY KEY
> ) ENGINE=InnoDB;
> 
> SHOW CREATE TABLE a;
> 
> CREATE TABLE `a` (
>    `a` int(10) NOT NULL PRIMARY KEY
> ) ENGINE=MyISAM
> 
> As you can see, an InnoDB has become an MyISAM and will be stored in 
> ~/var/test/a.*
> 
> I am using the large table .cnf file.  Everything else is much as
> default.
> 
> Can anybody help me?
> 
> Regards,
> 
> Ben
> 
> 
> 
> 
> 
> 
> 

Thread
InnoDB problems under 5.1.9Ben Clewett23 May
  • RE: InnoDB problems under 5.1.9SST - Adelaide)23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
      • RE: InnoDB problems under 5.1.9SST - Adelaide)23 May
        • Re: InnoDB problems under 5.1.9Ben Clewett23 May
        • I think I need a joinCritters23 May
          • Re: I think I need a joinPeter Brawley23 May
    • How do I get off this list that I do not remember joining in the first place!!!!Phil Robbins25 May
      • Re: How do I get off this list that I do not remember joining inthe first place!!!!Daniel Kasak25 May
        • Re: How do I get off this list that I do not remember joining in the firstplace!!!!Phil Robbins26 May
          • Re: How do I get off this list that I do not remember joining inthe first place!!!!James Harvard26 May
          • Re: How do I get off this list that I do not remember joining inthe first place!!!!Daniel Kasak26 May
      • RE: How do I get off this list that I do not remember joining in the first place!!!!Tim Lucia25 May
  • Re: InnoDB problems under 5.1.9gerald_clark23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
      • Re: InnoDB problems under 5.1.9Dan Buettner23 May
        • Re: InnoDB problems under 5.1.9Ben Clewett23 May
          • Re: InnoDB problems under 5.1.9Dan Buettner23 May
            • Re: InnoDB problems under 5.1.9Ben Clewett23 May
            • Re: InnoDB problems under 5.1.9Ben Clewett23 May