Feature Mariadb Innodb settting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: March 02, 2022 02:47PM

innodb-default-row-format=dynamic


Retionale: Prevent errors when importing from production databases with this settings

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: RiggsFolly (Moderator)
Date: March 03, 2022 10:50AM

Please see Previous answer

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<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-



Edited 1 time(s). Last edit at 03/03/2022 04:14PM by RiggsFolly.

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: theking2 (---.static.upc.ch)
Date: March 10, 2022 03:56PM

RiggsFolly Wrote:
-------------------------------------------------------
> Please see
> [url=http://forum.wampserver.com/read.php?2,163191
> ,163192#msg-163192]Previous answer[/url]


Sure.

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: theking2 (---.static.upc.ch)
Date: March 28, 2022 12:35PM

In this specific case however the wampserver team decided to go aganst the standard [mariadb.com]. Apparently since 10.2.2 the default for the default_row_format is dynamic and not compact.


Is there a reason why a learning user should be using compact?

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: Otomatic (Moderator)
Date: March 28, 2022 01:20PM

Hi,

Contrary to the various versions of PHP which are distributed by php.net with examples of php.ini, the versions of MariaDB as well as MySQL are distributed without any example of my.ini.

I'm not going to spend my time reading the MariaDB and MySQL documentations for each new version to see what the default values have changed.

If you have any comments, please ask MariaDB and MySQL to integrate a standard my.ini file in each new version.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.10 32 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.10 64 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: May 09, 2022 08:58PM

I understand.

I did read throw the manuals and rest assured adding

innodb-default-row-format=dynamic

to the ini does have it benefits, not only for me but for everyone using multi-byte character sets. MariaDB will through very confusing error messages at the user when this is the case.

On that note. If the my.ini deployed is never changed, for understandable reasons, this might have in some point of time have detrimental effects. The world changes

Options: ReplyQuote
Re: Feature Mariadb Innodb settting
Posted by: theking2 (---.dyn.cable.fcom.ch)
Date: May 09, 2022 09:05PM

Btw I even recommend to remove the setting altogether and let MariaDB decide by commenting it:

;innodb-default-row-format = compact

Options: ReplyQuote


Sorry, only registered users may post in this forum.