InnoDB: Fatal error: cannot allocate memory for the buffer pool
Bonjour,
Sur un serveur Web fonctionnant sous MariaDB 5.5.40 et Ubuntu 12.04 LTS je rencontre de temps en temps un crash.
Dans mon syslog j'ai :
Citation:
kernel: [606312.044861] Out of memory: Kill process 1860 (mysqld) score 24 or sacrifice child
kernel: [606312.048008] Killed process 1860 (mysqld) total-vm:922576kB, anon-rss:10680kB, file-rss:0kB
mysqld_safe: Number of processes running now: 0
mysqld_safe: mysqld restarted
mysqld: 141217 11:10:48 InnoDB: The InnoDB memory heap is disabled
mysqld: 141217 11:10:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysqld: 141217 11:10:48 InnoDB: Compressed tables use zlib 1.2.3.4
mysqld: 141217 11:10:48 InnoDB: Using Linux native AIO
mysqld: 141217 11:10:48 InnoDB: Initializing buffer pool, size = 256.0M
mysqld: InnoDB: mmap(275513344 bytes) failed; errno 12
mysqld: 141217 11:10:48 InnoDB: Completed initialization of buffer pool
mysqld: 141217 11:10:48 InnoDB: Fatal error: cannot allocate memory for the buffer pool
mysqld: 141217 11:10:48 [ERROR] Plugin 'InnoDB' init function returned error.
mysqld: 141217 11:10:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysqld: 141217 11:10:48 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
mysqld: 141217 11:10:48 [Note] Plugin 'FEEDBACK' is disabled.
mysqld: 141217 11:10:48 [ERROR] Unknown/unsupported storage engine: InnoDB
mysqld: 141217 11:10:48 [ERROR] Aborting
mysqld:
mysqld: 141217 11:10:48 [Note] /usr/sbin/mysqld: Shutdown complete
mysqld:
mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
ET une partie de mon fichier my.cnf :
Citation:
#innodb_log_file_size = 50M
innodb_buffer_pool_size = 256M
innodb_log_buffer_size = 8M
innodb_file_per_table = 1
innodb_open_files = 400
innodb_io_capacity = 400
innodb_flush_method = O_DIRECT
En fait, il n'arrive pas à donner de la mémoire vive au innodb_buffer_pool_size ? C'est ça ? C'est étrange car j'ai largement de mémoire :
Citation:
Mem: 4049228k total, 1074800k used, 2974428k free, 86496k buffers
Swap: 1949692k total, 22344k used, 1927348k free, 718208k cached
Pouvez-vous m'éclairer svp ?
