Red Hat Bugzilla – Bug 110593
InnoDB warnings in /var/log/mysqld.log
Last modified: 2007-11-30 17:10:33 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5)
Description of problem:
When I start mysqld, the following appears in my /var/log/mysqld.log
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
/usr/libexec/mysqld: ready for connections
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. service mysqld stop
2. service mysqld start
Actual Results: See above.
No message about InnoDB in the log.
my.conf is the default installed. Adding skip-innodb to the [mysqld]
section stops the warning message. However it would disable any
innodb databases if I had any.
These are just warning/informational messages that have been
in MySQL for some time. MySQL is built with InnoDB support and the
user has to do a little setup work.