Bug 110593 - InnoDB warnings in /var/log/mysqld.log
Summary: InnoDB warnings in /var/log/mysqld.log
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Fedora
Classification: Fedora
Component: mysql
Version: 1
Hardware: i386
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Patrick Macdonald
QA Contact: David Lawrence
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2003-11-21 16:22 UTC by Joseph Tate
Modified: 2007-11-30 22:10 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2003-11-21 18:01:13 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Joseph Tate 2003-11-21 16:22:51 UTC
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5)
Gecko/20031007

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
skip-innodb
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
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

Version-Release number of selected component (if applicable):
mysql-server-3.23.58-4

How reproducible:
Always

Steps to Reproduce:
1. service mysqld stop
2. service mysqld start

    

Actual Results:  See above.

Expected Results:
No message about InnoDB in the log.

Additional info:
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.

Comment 1 Patrick Macdonald 2003-11-21 18:01:13 UTC
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.


Note You need to log in before you can comment on or make changes to this bug.