mysql 无法启动求助

jimmy

root@VM-195-19-ubuntu:/usr/local/mysql/var# /etc/init.d/mysql start
Starting MySQL
. * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).


160415 12:17:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160415 12:17:53 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 9910 ...
160415 12:17:53 [Note] Plugin 'FEDERATED' is disabled.
160415 12:17:53 InnoDB: The InnoDB memory heap is disabled
160415 12:17:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160415 12:17:53 InnoDB: Compressed tables use zlib 1.2.8
160415 12:17:53 InnoDB: Initializing buffer pool, size = 16.0M
160415 12:17:53 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
InnoDB: a new database to be created!
160415 12:17:53  InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160415 12:17:53  InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160415 12:17:53  InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new

licess

InnoDB: Database physically writes the file full: wait... 当前分区或磁盘空间已满

jimmy

root@VM-195-19-ubuntu:/var/run# df -k
Filesystem     1K-blocks    Used Available Use% Mounted on
/dev/vda1       20510332 4909264  14552544  26% /
none                   4       0         4   0% /sys/fs/cgroup
udev              504612       4    504608   1% /dev
tmpfs             101792     300    101492   1% /run
none                5120       0      5120   0% /run/lock
none              508948      24    508924   1% /run/shm
none              102400       0    102400   0% /run/user

但是军哥 我查询了下磁盘 都是很空的啊

licess

你发的日志是4月15日的，请发最新的报错时的日志

jimmy

0610 11:16:19 mysqld_safe Number of processes running now: 0
160610 11:16:19 mysqld_safe mysqld restarted
160610 11:16:20 [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.
160610 11:16:20 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 21543 ...
160610 11:16:20 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
160610 11:16:20 [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.
160610 11:16:20 [Note] Plugin 'FEDERATED' is disabled.
160610 11:16:20 InnoDB: The InnoDB memory heap is disabled
160610 11:16:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160610 11:16:20 InnoDB: Compressed tables use zlib 1.2.8
160610 11:16:20 InnoDB: Initializing buffer pool, size = 16.0M
InnoDB: mmap(17170432 bytes) failed; errno 12
160610 11:16:20 InnoDB: Completed initialization of buffer pool
160610 11:16:20 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160610 11:16:20 [ERROR] Plugin 'InnoDB' init function returned error.
160610 11:16:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160610 11:16:20 [ERROR] Aborting

160610 11:16:20 [Note]
160610 11:16:20 mysqld_safe mysqld from pid file /usr/local/mysql/var/VM-195-19-ubuntu.pid ended



麻烦军哥了 帮忙看看怎么回事

licess

[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
这个错误可以 find / -name my.cnf 看一下

160610 11:16:20 InnoDB: Completed initialization of buffer pool
160610 11:16:20 InnoDB: Fatal error: cannot allocate memory for the buffer pool
这个是内存不够用了

你机器什么配置？