| View previous topic :: View next topic |
| Author |
Message |
KayZee
Apprentice
Joined: 15 Oct 2003
Posts: 202
Location: Arlington, VA
|
 Posted: Mon Aug 17, 2009 12:18 am Post subject: enabling MySQL innodb |
 |
|
How do I enable the innodb storage engine in MySQL? I have an application that needs innodb.
I am running dev-db/mysql-5.0.70-r1.
If I add the innodb use flag to either package.use or make.conf
The innodb use flag is not picked up. Is innodb still a valid use flag? |
|
| Back to top |
|
 |
desultory
Bodhisattva
Joined: 04 Nov 2005
Posts: 9410
|
| Posted: Mon Aug 17, 2009 4:23 am Post subject: |
|
|
| It is not, and innodb should be enabled in the default configuration installed by emerge --config =dev-db/mysql-5.0.70-r1. |
|
| Back to top |
|
|
vincent-
Retired Dev
Joined: 13 Jan 2007
Posts: 415
Location: Valencia (Spain)
|
| Posted: Mon Aug 17, 2009 8:42 am Post subject: |
|
|
When you create a table, add "engine=innodb;" or "type=innodb;"
For instance:
| Code: | | create table users(id int, name text, pass text) engine=innodb; |
or
| Code: | | create table users(id int, name text, pass text) type=innodb; |
If works, you have innodb enabled  |
|
| Back to top |
|
|
desultory
Bodhisattva
Joined: 04 Nov 2005
Posts: 9410
|
| Posted: Tue Aug 18, 2009 4:30 am Post subject: |
|
|
| peratu wrote: | | If works, you have innodb enabled |
It can appear to work without actually doing specifically what it was instructed to do, such as by falling back to another storage engine, so be sure to check the results and read any messages produced while processing those commands. |
|
| Back to top |
|
|
|
Networking & Security
