Échec de l'installation innodb Comme le moteur par défaut dans Ubuntu 10.04

J'ai un problème avec le cadre innodb En tant que moteur de base de données par défaut MySQL 5.1 sur Ubuntu 10.04. Dès que je passe à innodb En tant que moteur par défaut, le serveur refuse de démarrer. C'est ce que j'entre dans le magazine System pour essayer de courir MySQL Après incorporation innodb:

Oct  6 21:18:29 artemis init: mysql main process ended, respawning

Oct  6 21:18:58 artemis init: mysql post-start process (5825) terminated with status 1

Oct  6 21:18:59 artemis init: mysql main process (5943) terminated with status 7

Oct  6 21:18:59 artemis init: mysql main process ended, respawning

Oct  6 21:19:28 artemis init: mysql post-start process (5944) terminated with status 1

Oct  6 21:19:29 artemis init: mysql main process (6056) terminated with status 7

Oct  6 21:19:29 artemis init: mysql main process ended, respawning

Oct  6 21:19:58 artemis init: mysql post-start process (6057) terminated with status 1

Oct  6 21:20:00 artemis init: mysql main process (6163) terminated with status 7

Oct  6 21:20:00 artemis init: mysql main process ended, respawning

Oct  6 21:20:28 artemis init: mysql post-start process (6164) terminated with status 1

Oct  6 21:20:30 artemis init: mysql main process (6239) terminated with status 7

Oct  6 21:20:30 artemis init: mysql main process ended, respawning

Oct  6 21:20:59 artemis init: mysql post-start process (6240) terminated with status 1

Oct  6 21:21:00 artemis init: mysql main process (6358) terminated with status 7

Oct  6 21:21:00 artemis init: mysql main process ended, respawning

Oct  6 21:21:29 artemis init: mysql post-start process (6359) terminated with status 1

Oct  6 21:21:30 artemis init: mysql main process (6434) terminated with status 7

Oct  6 21:21:30 artemis init: mysql main process ended, respawning

Oct  6 21:21:59 artemis init: mysql post-start process (6435) terminated with status 1

Oct  6 21:22:01 artemis init: mysql main process (6540) terminated with status 7

Oct  6 21:22:01 artemis init: mysql main process ended, respawning

Essayer de supprimer tous les programmes d'interférence, j'ai supprimé apparmor et redémarré. Après avoir effectué une installation propre, le retrait réel du répertoire / etc / mysql et / var / lib / mysql, Pour vous assurer que les fichiers obsolètes ne mentent pas, le serveur commence normalement avec MyIsam en tant que moteur par défaut. InnoDB Inclus dans le nombre de moteurs disponibles lors de la montrage des moteurs:

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |

| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |

| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |

| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |

| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |

| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |

| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

8 rows in set (0.00 sec)

Configuration InnoDB, que j'ai essayé et qui est ajouté à [mysqld] défaut my.cnf, qui vient avec un paquet mysql-server-5.1, comme suit:

# TEST #####################################################



init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'



default-character-set=utf8

character-set-server=utf8

collation-server=utf8_general_ci

skip-character-set-client-handshake



max_allowed_packet = 16M



# Network buffer length (I think this is the linux default)

#net_buffer_length = 8K



# Query caching

query_cache_type = 1



# Default table storage engine when creating new tables

# (comment out when running mysql_install_db)

#default_storage_engine=InnoDB

#default_table_type=InnoDB



# Default transaction isolation level, levels available are:

# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE

# see: [url=http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html]http://dev.mysql.com/doc/refma ... .html[/url]

transaction_isolation = READ-COMMITTED



innodb_data_file_path = ibdata1:50M:autoextend





# TEST #####################################################

Je peux ajouter le fragment ci-dessus sans aucun problème, mais dès que je peux insquement default_storage_engine = InnoDB ou default_table_type = InnoDB, Le serveur ne commencera pas. Après avoir ré-commenter des rangées et redémarrer InnoDB Pas parmi les moteurs classés.

    mysql> show engines;

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |

| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |

| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |

| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |

| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |

| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |

| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |

+------------+---------+----------------------------------------------------------------+--------------+------+------------+

7 rows in set (0.00 sec)

Qu'est-ce que je fais mal, ce qui manque? Tout indice qui peut faire la lumière sur elle est la bienvenue.

Hourra! // John