XAMPP: Innodb error/warning messages in mysql_error.log

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP: Innodb error/warning messages in mysql_error.log

Postby TomXampp » 27. April 2015 16:01

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!
Posts: 54
Joined: 12. March 2015 03:58
Operating System: Windows 8.1

Re: XAMPP: Innodb error/warning messages in mysql_error.log

Postby mark.mcdonald » 27. April 2015 20:04

TomXampp wrote: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.
Posts: 160
Joined: 13. March 2015 15:48
Location: Edmonton
Operating System: Windows Server 2012 R2

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 37 guests