安装mysql 报Fatal error: cannot allocate memory for the buffer pool-freeterman
mysql 启动后自动停止 内存不足导致的120710 11:01:38 InnoDB: Initializing buffer pool,> InnoDB: mmap(8791261184 bytes) failed; errno 12
120710 11:01:38 InnoDB: Completed initialization of buffer pool
120710 11:01:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120710 11:01:38 Plugin 'InnoDB' init function returned error.
120710 11:01:38 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120710 11:01:38 Unknown/unsupported storage engine: InnoDB
120710 11:01:38 Aborting
从err日志，可以看出，我分配的Initializing buffer pool,> 这个值=>my.cnf的innodb_buffer_pool_size
只要重新设置innodb_buffer_pool_size即可。官方文档默认值给出的是128M，如下图所示。
NameOld DefaultNew Defaultinnodb_additional_mem_pool_size1MB8MBinnodb_buffer_pool_size8MB128MBinnodb_change_bufferinginsertsallinnodb_file_format_checkON1innodb_log_buffer_size1MB8MBinnodb_max_dirty_pages_pct9075innodb_sync_spin_loops2030innodb_thread_concurrency80
页:
[1]