# MySQL crashes when InnoDB variables uncommented in my.cnf

**URL:** <https://forums.percona.com/t/mysql-crashes-when-innodb-variables-uncommented-in-my-cnf/532>\
**Category:** Other MySQL® Questions\
**Created:** [November 20, 2007, 3:23am UTC](https://forums.percona.com/t/mysql-crashes-when-innodb-variables-uncommented-in-my-cnf/532 "2007-11-20T03:23:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomiford](https://avatars.discourse-cdn.com/v4/letter/t/f0a364/32.png) [@tomiford](https://forums.percona.com/u/tomiford)\
**Post date:** [November 20, 2007, 3:23am UTC](https://forums.percona.com/t/mysql-crashes-when-innodb-variables-uncommented-in-my-cnf/532/1 "2007-11-20T03:23:24Z")

</div>

We have changed one of our databases to InnoDB, after doing this we tried to uncomment the following in the my.cnf file and restart mysql:

# Uncomment the following if you are using InnoDB tables

innodb\_data\_home\_dir = /usr/local/mysql/var/ibdata  
innodb\_data\_file\_path = ibdata1:2000M;ibdata2:10M:autoextend  
innodb\_log\_group\_home\_dir = /usr/local/mysql/var/ibdata  
innodb\_log\_arch\_dir = /usr/local/mysql/var//

# You can set ..\_buffer\_pool\_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

innodb\_buffer\_pool\_size = 512M  
innodb\_additional\_mem\_pool\_size = 20M

# Set ..\_log\_file\_size to 25 % of buffer pool size

innodb\_log\_file\_size = 128M  
innodb\_log\_buffer\_size = 8M  
innodb\_flush\_log\_at\_trx\_commit = 1  
innodb\_lock\_wait\_timeout = 50

After doing this we cannot start mysql.

We are running:  
MySQL 5.0.45  
PHP 5.2.5  
Apache: 2.2.6  
FreeBSD: 6.1

The server has a gig of RAM.

If we comment out the InnoDB values in my.cnf again and restart mysql everything works fine accessing both InnoDB and MyISAM tables.

Any advice would be much appreciated, as we need to optomize the server to handle a decent amount of traffic.

---

<div class="post-metadata">

**Author:** ![tomiford](https://avatars.discourse-cdn.com/v4/letter/t/f0a364/32.png) [@tomiford](https://forums.percona.com/u/tomiford)\
**Post date:** [November 20, 2007, 7:29am UTC](https://forums.percona.com/t/mysql-crashes-when-innodb-variables-uncommented-in-my-cnf/532/2 "2007-11-20T07:29:15Z")

</div>

If I run SHOW ENGINES in mysql, InnoDB is set to YES.