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: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** 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:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 5:50 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
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: [EMAIL PROTECTED]
> **** _/ _/ _/ _/ **** 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:[EMAIL PROTECTED]
> Sent: Tuesday, 23 May 2006 4:57 PM
> To: mysql@lists.mysql.com
> 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
>
>
>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
