From: Ben Clewett
Date: May 23 2006 10:36am
Subject: Re: InnoDB problems under 5.1.9
List-Archive: http://lists.mysql.com/mysql/198199
Message-Id: <4472E5A8.5040305@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Very very odd.

I am compiling with the --use-innodb option.  I am starting mysqld with 
the --innodb option.

The table space is created for innodb.  But SHOW ENGINE shows InnoDB = 
DISABLED.

There are relevant no errors in the .err file.

Thanks for sending me your compilation options.  I'll give those a go 
and see what happens...

Regards,

Ben.



Logan, David (SST - Adelaide) wrote:
> Hi Ben,
> 
> I thought the InnoDB engine was included without having to set a
> ./configure option. On my latest build (admittedly a 5.0.18 one) InnoDB
> was enabled without setting any ./configure option.
> 
> My options were
> 
> hambone /usr/dev/src/mysql-5.0.18 $ cat ../../build_scripts/mysql-5.0.18
> #!/bin/bash
> 
> ./configure \
>         --prefix=/usr/local/mysql-5.0.18 \
>         --enable-thread-safe-client \
>         --with-unix-socket-path=/tmp \
>         --with-openssl \
>         --with-example-storage-engine \
>         --with-archive-storage-engine \
>         --with-csv-storage-engine \
>         --with-blackhole-storage-engine \
>         --with-ndbcluster \
>         --with-ndb-test \
>         --with-ndb-port=3510 \
>         --with-ndb-port-base=3710 \
>         --with-federated-storage-engine
> 
> This worked fine. If I get time later, I may give it a punt with your
> version. Sorry I can't be of more help.
> 
> 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 5:50 PM
> To: Logan, David (SST - Adelaide)
> Cc: mysql@stripped
> Subject: Re: InnoDB problems under 5.1.9
> 
> 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
>>
>>
>>
>>
>>
>>
>>
> 
>