最近几天网站又出现和以前一样的mysql链接错误
指尖风暴 和以前一样的问题，但是我这次没有选择更改mysql引擎为MyISAM，而是修改了缓冲池大小，再看看还出问题不。先发下日志
- 150708 9:02:11 [Warning] IP address '104.149.88.221' could not be resolved: Name or service not known
- 150708 13:40:40 mysqld_safe Number of processes running now: 0
- 150708 13:40:40 mysqld_safe mysqld restarted
- 150708 13:40:41 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 19697 ...
- 150708 13:40:41 [Note] Plugin 'FEDERATED' is disabled.
- 150708 13:40:41 InnoDB: The InnoDB memory heap is disabled
- 150708 13:40:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 150708 13:40:41 InnoDB: Compressed tables use zlib 1.2.3
- 150708 13:40:41 InnoDB: Using Linux native AIO
- 150708 13:40:41 InnoDB: Initializing buffer pool, size = 128.0M
- InnoDB: mmap(135987200 bytes) failed; errno 12
- 150708 13:40:41 InnoDB: Completed initialization of buffer pool
- 150708 13:40:41 InnoDB: Fatal error: cannot allocate memory for the buffer pool
- 150708 13:40:41 [ERROR] Plugin 'InnoDB' init function returned error.
- 150708 13:40:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- 150708 13:40:41 [ERROR] Unknown/unsupported storage engine: InnoDB
- 150708 13:40:41 [ERROR] Aborting
- 150708 13:40:41 [Note] /usr/libexec/mysqld: Shutdown complete
- 150708 13:40:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- 150708 15:31:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 150708 15:31:38 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 25879 ...
- 150708 15:31:38 [Note] Plugin 'FEDERATED' is disabled.
- 150708 15:31:38 InnoDB: The InnoDB memory heap is disabled
- 150708 15:31:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 150708 15:31:38 InnoDB: Compressed tables use zlib 1.2.3
- 150708 15:31:38 InnoDB: Using Linux native AIO
- 150708 15:31:38 InnoDB: Initializing buffer pool, size = 128.0M
- 150708 15:31:38 InnoDB: Completed initialization of buffer pool
- 150708 15:31:38 InnoDB: highest supported file format is Barracuda.
- InnoDB: The log sequence number in ibdata files does not match
- InnoDB: the log sequence number in the ib_logfiles!
- 150708 15:31:38 InnoDB: Database was not shut down normally!
- InnoDB: Starting crash recovery.
- InnoDB: Reading tablespace information from the .ibd files...
- InnoDB: Restoring possible half-written data pages from the doublewrite
- InnoDB: buffer...
- 150708 15:31:39 InnoDB: Waiting for the background threads to start
- 150708 15:31:40 InnoDB: 5.5.44 started; log sequence number 8538586
- 150708 15:31:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 150708 15:31:40 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 150708 15:31:40 [Note] Server socket created on IP: '0.0.0.0'.
- 150708 15:31:40 [Note] Event Scheduler: Loaded 0 events
- 150708 15:31:40 [Note] /usr/libexec/mysqld: ready for connections.
- Version: '5.5.44' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
发下修改的方法：
修改mysql的配置文件/etc/my.cnf 在InnoDB 添加 innodb_buffer_pool_size=64M
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。
