O servidor MySQL não irá instalar em um novo sistema operacional (Debian, Ubuntu)

Question

Hoje eu queria instalar (em um novo VPS com novo sistema operacional) um servidor MySQL.

Eu usei este comando:

apt-get install mysql-server mysql-common mysql-client-5.5

Eu tentei com o Debian 7 (x64 e x86) e com o Ubuntu 13.04 (x64 e x86).

Toda vez que recebo esta mensagem de erro:

140223  9:37:33 [Warning] Using unique option prefix key_buffer instead of key_b
uffer_size is deprecated and will be removed in a future release. Please use the
 full name instead.
140223  9:37:33 [Warning] Using unique option prefix myisam-recover instead of m
yisam-recover-options is deprecated and will be removed in a future release. Ple
ase use the full name instead.
140223  9:37:33 [Note] Plugin 'FEDERATED' is disabled.
140223  9:37:33 InnoDB: The InnoDB memory heap is disabled
140223  9:37:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140223  9:37:33 InnoDB: Compressed tables use zlib 1.2.7
140223  9:37:33 InnoDB: Using Linux native AIO
140223  9:37:33  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 att
empts 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.

Um vídeo em que estou tentando instalar o Ubuntu: link

    

Answer 1

Desativando via my.cnf

Isso soa como o seu problema, intitulado: InnoDB: Aviso: io_setup () falhou com o EAGAIN. Fará 5 tentativas antes de desistir. .

trecho

and you find this error somewhere in it:

    131201 19:22:27 InnoDB: Using Linux native AIO
    131201 19:22: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.
    131201 19:22:30  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
    131201 19:22:30 InnoDB: Fatal error: cannot initialize AIO sub-system

then the solution would be to add:

  innodb_use_native_aio = 0

to the [mysqld] section of your /etc/my.cnf file.

Aumentando o aio-max-nr

Você também pode aumentar a configuração do kernel via:

$ cat /proc/sys/fs/aio-max-nr
1048576

As configurações do kernel, como esta, podem ser substituídas usando o comando sysctl :

$ sudo sysctl -a | grep aio
fs.aio-max-nr = 1048576
fs.aio-nr = 0

$ sysctl -w fs.aio-max-nr=200000