MySQL : Plantage

Support Debian
#21

Salut,
Désolé du temps de réponse mais j’étais très occupé :blush:

Désolé aussi, j’avais mal lu

Donc j’ai tapé mysqld et celà donne ceci:

[code]root@176:~# mysqld
141018 4:54:26 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
141018 4:54:26 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141018 4:54:26 [Note] Plugin ‘FEDERATED’ is disabled.
141018 4:54:27 InnoDB: The InnoDB memory heap is disabled
141018 4:54:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141018 4:54:27 InnoDB: Compressed tables use zlib 1.2.7
141018 4:54:27 InnoDB: Using Linux native AIO
141018 4:54:27 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
141018 4:54:29 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
141018 4:54:29 InnoDB: Fatal error: cannot initialize AIO sub-system
141018 4:54:29 [ERROR] Plugin ‘InnoDB’ init function returned error.
141018 4:54:29 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
141018 4:54:29 [ERROR] Unknown/unsupported storage engine: InnoDB
141018 4:54:29 [ERROR] Aborting

141018 4:54:29 [Note] mysqld: Shutdown complete

root@176:~#[/code]

Bonne journée

#22

Essaye d’ajouter
skip-innodb
à /etc/mysql/my.cnf (section mysqld)
Éventuellement rajoute default_storage_engine=MyISAM aussi

#23

Merci à toi pour ta réponse rapide, j’ai ajouté ce que tu m’as dit :slightly_smiling:

root@176:~# nano /etc/mysql/my.cnf root@176:~# mysqld 141018 6:39:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 141018 6:39:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 141018 6:39:48 [Note] Plugin 'FEDERATED' is disabled. 141018 6:39:48 [Note] Plugin 'InnoDB' is disabled. 141018 6:39:48 [Note] Server hostname (bind-address): 'localhost'; port: 3306 141018 6:39:48 [Note] - 'localhost' resolves to '::1'; 141018 6:39:48 [Note] - 'localhost' resolves to '127.0.0.1'; 141018 6:39:48 [Note] Server socket created on IP: '127.0.0.1'. 141018 6:39:49 [Note] Event Scheduler: Loaded 0 events 141018 6:39:49 [Note] mysqld: ready for connections. Version: '5.5.38-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)

root@176:~# /etc/init.d/mysql start [ ok ] Starting MySQL database server: mysqld already running. root@176:~# /etc/init.d/mysql stop [ ok ] Stopping MySQL database server: mysqld. root@176:~# /etc/init.d/mysql start [ ok ] Starting MySQL database server: mysqld. [info] Checking for tables which need an upgrade, are corrupt or were not closed cleanly..

Nouvelle erreur sur le forum:

[code]
General Error
SQL ERROR [ mysqli ]

Unknown storage engine ‘InnoDB’ [1286]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.[/code]

#24

Damned, bon, on va essayer autre chose, tu vas commenter le
#skip-innodb
et tu vas mettre
innodb_native_aio = off
(ou innodb_use_native_aio = 0)
à la place

#25

En appliquant ce que tu m’as dit:

root@176:~# nano /etc/mysql/my.cnf root@176:~# /etc/init.d/mysql start [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! root@176:~#

#26

Et lancé en console?
Peux tu mettre le résultat de

ainsi que