XAMPP: Innodb error/warning messages in mysql_error.log

[TomXampp]

I'm using the current version of XAMPP (5.6.8 ) on a Windows 8.1 machine. Everything executes correctly, and my site runs without a problem. However, the mysql_error.log file contains an InnoDB Warning message, as on the second line here:

Code: Select all

2015-04-27 09:15:30 5828 [Note] Plugin 'FEDERATED' is disabled.
2015-04-27 09:15:30 d7c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-04-27 09:15:30 5828 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-27 09:15:30 5828 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-27 09:15:30 5828 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-04-27 09:15:30 5828 [Note] InnoDB: Memory barrier is not used
2015-04-27 09:15:30 5828 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-27 09:15:30 5828 [Note] InnoDB: Not using CPU crc32 instructions
2015-04-27 09:15:30 5828 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-04-27 09:15:30 5828 [Note] InnoDB: Completed initialization of buffer pool
2015-04-27 09:15:30 5828 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-27 09:15:30 5828 [Note] InnoDB: 128 rollback segment(s) are active.
2015-04-27 09:15:30 5828 [Note] InnoDB: Waiting for purge to start
2015-04-27 09:15:30 5828 [Note] InnoDB: 5.6.24 started; log sequence number 1665374
2015-04-27 09:15:30 5828 [Note] Server hostname (bind-address): '*'; port: 3306
2015-04-27 09:15:30 5828 [Note] IPv6 is available.
2015-04-27 09:15:30 5828 [Note]   - '::' resolves to '::';
2015-04-27 09:15:30 5828 [Note] Server socket created on IP: '::'.
2015-04-27 09:15:30 5828 [Note] Event Scheduler: Loaded 0 events
2015-04-27 09:15:30 5828 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.24'  socket: ''  port: 3306  MySQL Community Server (GPL)

I discovered that commenting-out this line:

Code: Select all

innodb_additional_mem_pool_size = 2M

...in the my.ini file suppressed that message. However...

1) I'm not sure what to do with the other notice (now suppressed) that "innodb_use_sys_malloc" will be deprecated; I couldn't located that in the my.ini file...is it elsewhere?

2) Likewise, I'm not sure how to disable "InnoDB's internal memory allocator", the third thing listed in the warning message that is suppressed when that one line in MY.INI is commented-out.

3) Is there anything else in the mysql_error.log file, as shown here, that I should attend to? (The rest of the lines remain when the "innodb_additional_mem_pool_size" is commented-out.)

Many thanks!

[mark.mcdonald]

Everything executes correctly, and my site runs without a problem. However, the mysql_error.log file contains an InnoDB Warning message

This is a warning, not an error. This is an informational message that lets you know that a certain aspect of mysql has been cut back. 99% of users using XAMPP don't need to worry or do anything with this as this warning is generated with every install of XAMPP. I have not seen this cause an issue yet with any development with xampp.