WampServer

I need to increase my innodb-buffer-pool-size to 1G. When I try to do this from the desktop icon->MySal->mySql settings->innodb-buffer-pool-size->Size->Choose
I see that I can set it to
Enter Size: xxxx followed by M for Mega or G for Giga The symbol M or G must be attached to the number. For example : 64M ; 256M ; 1G

But if I type 1G I get an error message "The value you entered (1G) is out of range.
The number must be between 10 and 9999.
The number must be followed by M (For Mega) or G (For Giga)
The value is set to 128M by default."
This seems illogical...

If I to the change manually in the my.ini file: innodb_buffer_pool_size = 1G and restart Wampserver, the change is not taken into account!

RTFM - MySQL Documentation

For versions 8.0 and 8.1 the default value is 1G

I think there is a bug in check of the value.

but with

innodb_buffer_pool_size=1G

in my.ini file, it works.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Thanks @Otomatic
1.- There is indeed a bug in the value checking
2.- My mistake when setting the value in my.ini file comes from the misleading display of the mysql settings in the wampserver interface, where we can see e.g.
MySQL settings
• key_buffer_size = 256M
...
• innodb_buffer_pool_size = 1G
were the equal sign is between space characters, when in fact there should be no spaces in the my.ini settings!
this does NOT work: innodb_buffer_pool_size = 1G
this works: innodb_buffer_pool_size=1G
You might consider revising the settings screens in wampserver to make them look more like the exact syntax?

Hi papijo

I am sorry but this is just not true.

innodb_buffer_pool_size = 1G

works just fine. I would suggest there is something else wrong in your case.



However I to get the error message if I try to set a value using the wampmanager menus that is less than 10G as the following error message says it is validating

The value you entered (1G) is out of range.
The number must be between 10 and 9999.
The number must be followed by M (For Mega) or G (For Giga)
The value is set to 128M by default.
Press ENTER to continue...

So Oto may need to take a quick look at that.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi,

> 1.- There is indeed a bug in the value checking

> So Oto may need to take a quick look at that.

Yes. There is a bug. It will be corrected by Wampserver 3.3.2 update

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi,

If you want to patch file wamp64\scripts\changeMysqlParam.php

Line 36 replace

if(preg_match('/^[1-9][0-9]{1,3}(M|G)$/m',$newvalue) != 1) {

by

if(preg_match('/^[1-9][0-9]{0,3}(M|G)$/m',$newvalue) != 1) {

Line 39 replace

The number must be between 10 and 9999.

by

The number must be between 1 and 9999.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons