InnoDB Disabled

[Mubarak Abdallah]

I'm a MySQL newbie, but I creating this thread under Innodb

I have newly installed mysql 5.0.92 on CentOS 5.7 and I copied my.cnf from a mysql server (5.1.48) of which the new mysql should a duplicate.

my.cnf file (innod related):
+++++++++++++++++++++++++++++
#slow_query_log
log_slow_queries
log-queries-not-using-indexes
innodb_file_per_table
innodb_buffer_pool_size=28G
innodb_additional_mem_pool_size=10M
innodb_log_buffer_size=8M
innodb_log_file_size=1G
tmp_table_size=1024M
max_heap_table_size=1G
innodb_thread_concurrency=8
max_length_for_sort_data=4096
#innodb_flush_log_at_trx_commit=2
+++++++++++++++++++++++++++++

I have changed buffer_pool_size=28G from 100GB to accommodate the difference in memory size between the servers and to resolve "InnoDB: Error: cannot allocate memory" issue, the total memory size is 32GB.

after the changes i restarted mysql and I get the following messages


+++++++++++++++++++++++++++++
111227 17:57:28 mysqld started
InnoDB: HugeTLB: Warning: Failed to allocate 107374198784 bytes. errno 22
InnoDB HugeTLB: Warning: Using conventional memory pool
111227 17:57:32 InnoDB: Error: cannot allocate 107374198784 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 40716000 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
111227 17:58:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.92-community-log' socket: '/trovix.com/data/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
120103 14:20:07 [Note] /usr/sbin/mysqld: Normal shutdown

120103 14:20:09 [Note] /usr/sbin/mysqld: Shutdown complete

120103 14:20:09 mysqld ended

120103 14:23:38 mysqld started
InnoDB: HugeTLB: Warning: Failed to allocate 30064787456 bytes. errno 12
InnoDB HugeTLB: Warning: Using conventional memory pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 1073741824 bytes!
120103 14:23:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.92-community-log' socket: '/trovix.com/data/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

+++++++++++++++++++++++++++++

but now when i display the engines, it shows InnoDB is disabled (skip_inooDB is not defined in my.cnf)

+++++++++++++++++++++++++++++
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | YES | Archive storage engine |
| CSV | YES | CSV storage engine |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | YES | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+

+++++++++++++++++++++++++++++

I have two questions, how can I enable innoDB & make it the default table format?
and how to verify the current tables/databases format (innoDB or MyISAM)?

could the "InnoDB: Error: cannot allocate memory" error caused the Innodb to be disabled since first start ?

Appreciate everyone help & input :)