← Back to team overview

maria-developers team mailing list archive

Re: Default parameter settings / Windows MSI installer


I think we need to avoid a situation where there is yet another set of mariadb defaults located in yet another place (in this case, I assume in the WiX XML description file).

Previously, we already had a situation with the old MySQL windows config wizard where an option would be deprecated and removed by the server whereas the config wizard will still try to configure it.

Right now we have 3 separate things:
- server defaults in the code, I belive mysqld.cc
- various example .cnf files that are no longer current
- windows-specific settings

It would be nice if we can get those down to 1 or 2. For example, have the windows installer use one of the example .cnf files (once those are updated to be current to existing hardware).

I also think that "Standard configuration" is a bit misleading here, since the standard configuration created by this option will be different from the default configuration. Maybe something like "Configuration optimized for transactions" would be more descriptive and better alligned with setting a transactional storage engine and a restrictive SQL mode.

Also, I believe "bufferpool" from Vlad's PNG should be written "Buffer pool". Dbart can provide the best wording.

Philip Stoev

----- Original Message ----- From: "Vladislav Vaintroub" <wlad@xxxxxxxxxxxxxxxx> To: <maria-developers@xxxxxxxxxxxxxxxxxxx>; "Kazuhisa Ichikawa" <kahz@xxxxxxxxxxxxxxxx>; "Peter Laursen" <peter_laursen@xxxxxxxxxx>; "Philip Stoev" <pstoev@xxxxxxxxxxxx>; "Arjen Lentz" <arjen@xxxxxxxxxxxxx>; <haidong.ji@xxxxxxxxx>
Sent: Tuesday, April 05, 2011 9:30 PM
Subject: Default parameter settings / Windows MSI installer

After recent discussion about appropriate or not appropriate default setting
on in my.cnf , I have created a prototype minimal settings for Windows
Here is the picture of  this attempt

For those who have familiar the 5.2 MSI installer already,  what I have
added is a checkbox "Standard configuration", explanation text, and input
field for innodb bufferpool size (preset with RAM/8,  in my case it is
"Standard configuration" is on by default,

if it is "on", then 4 parameters are added to the my.ini file
1) default_storage_engine=innodb
2) innodb_buffer_pool_size=[VALUE_IN_EDIT_BOX]M
3) innodb_log_file_size= min(innodb_buffer_pool_size/4, 50)

I made this formula almost out of thin air and using some blog reading and
comments in the templates.  It is likely that 50M is more than the average
user needs, however it only takes some disk space, and  If user has to
increase from default 5MB , the procedure is awkward.  I checked, MySQL
Config Wizard set this parameter to  54M on my box, so it is in  the same


If "Standard configuration" is off, hen input field for bufferpool size is
disabled, and none of those 4 parameters  is added to my.ini

Do you think it is useful in this form?  So far I tried to avoid
"calibration" topics  altogether since it is a  controversial topic where
people never have same opinions. Also I tried to avoid it because I cannot write GUIs . However, this one change is small in and it does not introduce additional dialogs. It makes some important defaults the same as "standard
configuration" in existing MySQL installers. I think it was PeterL who
already asked for non-default buffer pool size already, also Monty also
spoke about it in Lisbon.

Comments welcome,  also those on the picture above - I'm not sure  if
wording and use of brackets and quotes is correct.


Follow ups