Bug #42346 InnoDB Pluging 1.0.2 Warning Messages on Windows at start-up
Submitted: 26 Jan 2009 12:51 Modified: 29 Jan 2009 1:04
Reporter: Miguel Solorzano Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S3 (Non-critical)
Version:1.0.2 OS:Windows (Vista 64-bit)
Assigned to: Calvin Sun CPU Architecture:Any

[26 Jan 2009 12:51] Miguel Solorzano
Description:
I am not quite sure if it's InnoDB Plugin's bug, anyway below the warnings printed:

c:\dbs>c:\dbs\5.1p\bin\mysqld --defaults-file=c:\dbs\5.1p\my.ini --standalone --console
090126 10:43:16 [Warning] option 'innodb-additional-mem-pool-size': signed value -1 adjusted to 524288
090126 10:43:16 [Warning] option 'plugin-innodb-additional-mem-pool-size': signed value -1 adjusted to 524288
090126 10:43:16 [Warning] option 'innodb-log-buffer-size': signed value -1 adjusted to 262144
090126 10:43:16 [Warning] option 'plugin-innodb-log-buffer-size': signed value -1 adjusted to 262144
090126 10:43:16 [Warning] option 'innodb-open-files': signed value -1 adjusted to 10
090126 10:43:16 [Warning] option 'plugin-innodb-open-files': signed value -1 adjusted to 10
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090126 10:43:16  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090126 10:43:16  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090126 10:43:17  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090126 10:43:17 InnoDB Plugin 1.0.2 started; log sequence number 0
090126 10:43:18 [Note] Event Scheduler: Loaded 0 events
090126 10:43:18 [Note] c:\dbs\5.1p\bin\mysqld: ready for connections.
Version: '5.1.32-nt-log'  socket: ''  port: 3511  Source distribution

Configuration File:

[mysqld]
basedir=c:/dbs/5.1p/
datadir=c:/dbs/5.1p/data
server-id=511
log-bin=server51p
#sync_binlog=1
binlog-ignore-db=mysql
#default-character-set=utf8
#sql_mode=strict_trans_tables
##log-error=server51.err
#port=3306
port=3511
#enable-shared-memory=1
#ssl-ca=C:/dbs/5.0/cacert.pem
#ssl-cert=C:/dbs/5.0/server-cert.pem
#ssl-key=C:/dbs/5.0/server-key.pem
lower_case_table_names = 2
#sql_mode=strict_trans_tables
query_cache_size=30M
#innodb_log_file_size=100M
#innodb_buffer_pool_size=512M
#innodb_log_buffer_size=8M
#innodb_file_per_table

How to repeat:
See above.

Suggested fix:
-
[26 Jan 2009 17:14] Calvin Sun
I am seeing the same on Win32 platform:

090126 11:05:30 [Warning] option 'innodb-additional-mem-pool-size': signed value -1 adjusted to 524288
090126 11:05:30 [Warning] option 'plugin-innodb-additional-mem-pool-size': signed value -1 adjusted to 524288
090126 11:05:30 [Warning] option 'innodb-log-buffer-size': signed value -1 adjusted to 262144
090126 11:05:30 [Warning] option 'plugin-innodb-log-buffer-size': signed value -1 adjusted to 262144
090126 11:05:30 [Warning] option 'innodb-open-files': signed value -1 adjusted to 10
090126 11:05:30 [Warning] option 'plugin-innodb-open-files': signed value -1 adjusted to 10
MySQL Version 5.1.31
[27 Jan 2009 19:44] Calvin Sun
The warnings are caused by the fix of bug#31177. The warnings will go away when merging the changes to ha_innodb.cc into the plugin tree.
[29 Jan 2009 1:04] Calvin Sun
Changes merged into the plugin tree under r4056. No documentation needed.