Comparez les prix des domaines et des services informatiques des vendeurs du monde entier

É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
Invité:

Babette

Confirmation de:

Installation du serveur MySQL (Ubuntu 10.04):

apt-get install mysql-server

Ensuite, vérifiez le moteur par défaut (MyISAM):

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| 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 |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

Puis changer /etc/mysql/my.cnf - Ajouter default-storage-engine = innodb Dans la section mysqld:

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking

default-storage-engine = innodb

Ça fonctionne:

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | 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 | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

Pour répondre aux questions, connectez-vous ou registre