mysql - 启动错误InnoDB: mmap(137363456 bytes) failed; errno 1

来源：互联网发布：优化行政审批编辑：程序博客网时间：2024/06/05 05:19

公司的服务器 mysql开起来过段时间久宕机后来开socket写聊天也是开了基本上一会就宕机查看服务器是

130716 17:09:15 mysqld_safe mysqld from pid file /var/mysql/data/AY1305070924544.pid ended

130716 17:09:52 mysqld_safe Starting mysqld daemon with databases from /var/mysql/data

InnoDB: mmap(137363456 bytes) failed; errno 12

130716 17:09:53 InnoDB: The InnoDB memory heap is disabled

130716 17:09:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins

130716 17:09:53 InnoDB: Compressed tables use zlib 1.2.3

130716 17:09:53 InnoDB: Initializing buffer pool, size = 128.0M

130716 17:09:53 InnoDB: Completed initialization of buffer pool

130716 17:09:53 InnoDB: highest supported file format is Barracuda.

130716 17:09:53 InnoDB: Waiting for the background threads to start

130716 17:09:54 InnoDB: 1.1.8 started; log sequence number 4703029

130716 17:09:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

130716 17:09:54 [Note] - '0.0.0.0' resolves to '0.0.0.0';

130716 17:09:54 [Note] Server socket created on IP: '0.0.0.0'.

130716 17:09:54 [Note] Event Scheduler: Loaded 0 events

130716 17:09:54 [Note] /usr/local/mysql-DMYSQL_DATADIR=/var/mysql-DMYSQL_UNIX_ADDR=/var/mysql/mysqld.sock/bin/mysqld: ready for

connections.

查看内存显示

[root@AY1305070924544 /]# free -m

total used free shared buffers cached

Mem: 995 928 66 0 6 19

-/+ buffers/cache: 903 91

Swap: 0 0 0

重启错误提示

[root@AY1305070924544 /]# /etc/init.d/mysqld start

Starting MySQL. ERROR! The server quit without updating PID file (/var/mysql/data/AY1305070924544.pid).

[root@AY1305070924544 /]# /etc/init.d/mysqld restart

ERROR! MySQL server PID file could not be found!

Starting MySQL. ERROR! The server quit without updating PID file (/var/mysql/data/AY1305070924544.pid).

这个其实日志里面说的很明白就是 mysql要占用内存的时候物理内存不够用导致的所有 vi /etc/my.cnf

[inonodb]

innodb_buffer_pool_size=64MB 把这个数值改小高版本的默认是128mb 版本的默认是 8mb

0 0