Autoriser les tables InnoDB
Bonjour,
j'ai un soucis, je ne peux pas créer de table InnoDB du fait qu'elle soit désactiver quand je fais un SHOW ENGINES;
skip-innodb est en commentaire dans mon my.cnf .
Ne devrait-il pas activer les tables InnoDB automatiquement ?
SHOW ENGINES;
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
mysql> 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 | DISABLED | 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 | YES | CSV storage engine |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | YES | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec) |
mon fichier my.cnf :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /u1/databases
tmpdir = /u0/tmp
language = /usr/share/mysql/english
skip-external-locking
old_passwords = 1
bind-address = X.X.X.X
key_buffer = 1500M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
sort_buffer = 4M
read_buffer = 1M
server-id = 2
skip-bdb
innodb_data_file_path = ibdata:400G:autoextend
#skip-innodb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M |
Auriez vous une idée de ce qui ne va pas ?