List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:May 23 2006 1:41pm
Subject:Re: InnoDB problems under 5.1.9
View as plain text  
Hi Gerald,

I am sure I don't have this in my my.cfg.  I am using the supplied 
'large table' my.cfg.  The *only* innodb option I have is the command 
line parameter to mysqld:

--innodb

If anybody has any other options about how to get innodb working in 
5.1.9, I'd be very interested!

Thanks for the advise,

Ben


gerald_clark wrote:
> Ben Clewett wrote:
> 
>> 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
> 
> make sure you don't have
> skip--innodb
> in your my.cnf file.
> 

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