Problem collection for InnoDB in the error log

1. The error log report is as follows:

.....

120223 23:36:06 innodb:compressed tables use zlib 1.2.3

120223 23:36:06 innodb:initializing buffer pool, size = 24.0G

Innodb:mmap (26474446848 bytes) failed; errno 12

120223 23:36:06 innodb:completed initialization of buffer pool

120223 23:36:06 innodb:fatal Error:cannot Allocate memory for the buffer pool

120223 23:36:06 [ERROR] Plugin ' InnoDB ' init function returned ERROR.

120223 23:36:06 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.

120223 23:36:06 [ERROR] Failed to initialize plugins.

120223 23:36:06 [ERROR] Aborting

Analysis:

the memory allocated to Innodb_buffer_pool exceeds the physical memory

Workaround :

Review the my.cnf configuration file and set the Innodb_buffer_pool to the appropriate value .

Problem collection for InnoDB in the error log