Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for InnoDB.
See http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html, near the
bottom of the page it explains what DISABLED means and refers you to the
error log for messages.
Dan
Ben Clewett wrote:
> Hi Dan,
>
> This is what I have. What does this mean with regards to InnoDB?
>
>
> +------------+----------+----------------------------------------------------------------+--------------+-----+------------+
>
>
> | Engine | Support | Comment | Transactions | XA
> | Savepoints |
>
> +------------+----------+----------------------------------------------------------------+--------------+-----+------------+
>
>
> | CSV | YES | CSV storage engine |
> NO | NO | NO |
> | MEMORY | YES | Hash based, stored in memory, useful for
> temporary tables | NO | NO | NO |
> | MRG_MYISAM | YES | Collection of identical MyISAM tables
> | NO | NO | NO |
> | InnoDB | DISABLED | Supports transactions, row-level locking, and
> foreign keys | YES | YES | YES |
> | BLACKHOLE | YES | /dev/null storage engine (anything you write
> to it disappears) | NO | NO | NO |
> | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
> performance | NO | NO | NO |
> | BerkeleyDB | DISABLED | Supports transactions and page-level locking
> | YES | NO | YES |
> | ARCHIVE | YES | Archive storage engine |
> NO | NO | NO |
>
> +------------+----------+----------------------------------------------------------------+--------------+-----+------------+
>
>
>
> Thanks,
>
>
> Dan Buettner wrote:
>> Ben, what does SHOW ENGINES show you? It should list all known
>> storage engines and indicate whether your MySQL install supports it or
>> not.
>>
>> Here's mine (5.0.21) for comparison; I was able to create a test table
>> as InnoDB and the SHOW CREATE showed it as InnoDB:
>>
>> -> show engines;
>>
> +------------+---------+----------------------------------------------------------------+
>
>>
>> | Engine | Support | Comment |
>>
> +------------+---------+----------------------------------------------------------------+
>
>>
>> | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
>> performance |
>> | MEMORY | YES | Hash based, stored in memory, useful for
>> temporary tables |
>> | InnoDB | YES | Supports transactions, row-level locking, and
>> foreign keys |
>> | BerkeleyDB | NO | Supports transactions and page-level locking
>> |
>> | BLACKHOLE | NO | /dev/null storage engine (anything you write
>> to it disappears) |
>> | EXAMPLE | NO | Example storage engine |
>> | ARCHIVE | YES | Archive storage engine |
>> | CSV | NO | CSV storage engine |
>> | ndbcluster | NO | Clustered, fault-tolerant, memory-based
>> tables |
>> | FEDERATED | NO | Federated MySQL storage engine |
>> | MRG_MYISAM | YES | Collection of identical MyISAM tables
>> |
>> | ISAM | NO | Obsolete storage engine |
>>
> +------------+---------+----------------------------------------------------------------+
>
>>
>> 12 rows in set (0.00 sec)
>>
>>
>>
>>
>> Ben Clewett wrote:
>>> 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.
>>>>
>>>
>>>
>>
>
>
