MySQL or XAMPP will not start: unknown variable innodb_additional_mem_pool_size
unknown variable 'innodb_additional_mem_pool_size=2M'Short answer
innodb_additional_mem_pool_size was deprecated in MySQL 5.6 and removed in 5.7, together with innodb_use_sys_malloc. A config file carried over from an older install still sets it, and the server refuses to start on an option it does not know. Delete both lines from the file the server really reads.
Fix it fast
1Find out which cause you have
Search the option files your install reads for the removed variables, to see which file still sets them.
findstr /S /I "innodb_additional_mem_pool_size innodb_use_sys_malloc" C:\xampp\mysql\bin\my.ini C:\my.ini C:\Windows\my.ini2Match what you see, then jump to its fix
What does the error look like?
unknown variable 'innodb_additional_mem_pool_size=2M'[ERROR] Aborting
Cause 1 of 2
The option was removed in MySQL 5.7
1Check
innodb_additional_mem_pool_size and innodb_use_sys_malloc were deprecated in 5.6.2 and removed in 5.7. They were a pair: the memory pool setting was unused whenever sys malloc was on, so both go.
findstr /S /I "innodb_additional_mem_pool_size innodb_use_sys_malloc" C:\xampp\mysql\bin\my.ini2Fix
Delete both lines from the option file.
[mysqld]
# removed:
# innodb_additional_mem_pool_size=2M
# innodb_use_sys_malloc=ON3Verify
Search again: nothing should print. Then start the server and read the error log.
findstr /S /I "innodb_additional_mem_pool_size" C:\xampp\mysql\bin\my.iniConfirmed by dev.mysql.com
Cause 2 of 2
A second option file still carries the line
1Check
The server reads several option files in a fixed order, and later ones win. On Windows these include the Windows directory, C:\, and the base directory of the install, so an old copy can sit in a place you did not edit.
dir /S /B C:\my.ini C:\my.cnf C:\Windows\my.ini C:\xampp\mysql\my.ini2Fix
Remove the variable from every file that sets it, or rename the stray old copy.
rem edit each file found above, then search again
findstr /S /I "innodb_additional_mem_pool_size" C:\my.ini C:\Windows\my.ini3Verify
No file prints a match any more.
findstr /S /I "innodb_use_sys_malloc" C:\my.ini C:\Windows\my.iniConfirmed by dev.mysql.com
How do I stop it coming back?
- When you upgrade a major version, start from the new default config and add your own settings back one by one.
- Read the removed-feature list in the release notes before copying an old my.ini.
- Search the option files for removed variables after every upgrade.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Every cause above names the document that confirms it. I have not reproduced this fix on a machine of my own yet, so read it as documented guidance, not a test report. Found a mistake? Tell me.
Which stack is behind this page?
Projects of mine built on the same technologies:
- TaxiDexMy own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.
- QistLockA NestJS and React SaaS driving an Android Device Owner agent that locks financed phones when payments lapse.
- ShopGoAn e-commerce aggregator with a Python scraping engine behind its catalog, past 10K Google Play downloads.
Related fixes
Databases
Installing the Airflow MySQL provider fails on pkg-config or mysqlclient
Building the mysqlclient wheel fails during the install
The Airflow MySQL provider depends on mysqlclient, which pip compiles against the MySQL C client library.
2 causes, each with a fixDatabases
A query on Aurora MySQL dies with 'table /rdsdbdata/tmp/#sql... is full'
ERROR 1114 (HY000): The table '/rdsdbdata/tmp/#sqlfd_1586_2' is full
In Aurora MySQL 3, internal temporary tables share one pool, and when that pool and the memory-mapped overflow file are used up, a reader instance ends the query with error 1114.
3 causes, each with a fixDatabases
Azure Database for MySQL refuses a connection that does not use SSL
ERROR 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.
Azure Database for MySQL Flexible Server requires encrypted connections by default (require_secure_transport = ON, TLS 1.2).
4 causes, each with a fixDatabases
Compiling a C or C++ program that includes mysql.h fails
undefined reference to `mysql_init'
The compiler only finds mysql.h when the MySQL client development files are installed and their folder is on the include path.
3 causes, each with a fixDatabases
DBeaver fails to resolve Maven dependencies when downloading a database driver
A driver library does not download automatically
DBeaver downloads driver jars from a Maven repository.
3 causes, each with a fixDatabases
DBeaver cannot verify the MySQL server certificate
unable to find valid certification path to requested target
DBeaver's MySQL driver is checking the server certificate and Java does not trust the CA that signed it.
2 causes, each with a fix