Page 1 of 1

Cant change AVG_ROW_LENGTH parameter

Posted: Tue 17 Dec 2019 15:13
by vialus
AVG_ROW_LENGTH has somehow been automatically inserted in create table script and there is no table option to remove it. Why is it there and how I remove it?

Code: Select all

CREATE TABLE user_data.accounts (
  ID int(11) NOT NULL,
  Email varchar(255) DEFAULT NULL,
  MobilePhone varchar(32) DEFAULT NULL,
  PasswordHash varchar(255) DEFAULT NULL,
  PRIMARY KEY (ID)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 8192,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Wed 18 Dec 2019 12:04
by alexa
You would need to exclude the 'Include average row length' option in the settings (select 'Tools -> Options...' from the main menu)
Image

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Wed 18 Dec 2019 12:43
by vialus
Thanks! I have found the settings but I can't figure our how to remove it for the current tables that already have it. Unchecking the box in main menu does not remove it and there is no table option to remove it.

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Thu 19 Dec 2019 12:41
by alexa
Please set this setting to 0 in the table editor

Image

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Thu 19 Dec 2019 13:02
by vialus
Does not work. Upon saving it is reverted back to that number of 8192. All other tables are fine. Only this one behaves that strange. Look like more like a bug. Why would you force the number there?

Bellow is the version info

=========================
Application: dbForge Studio 2019 for MySQL
Product: Devart dbForge Studio 2019 for MySQL
Product Edition: Русская редакция
Product Locale: Russian
Trial Info: Активирован
HardwareID: 6127-3597-8D4E-3BAF-25B4
Assembly: dbforgemysql, Version=8.2.23.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.exe
Global cache: False
Framework: 4.6.2 or later
=========================

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Fri 20 Dec 2019 08:41
by alexa
Unfortunately, we were not able to reproduce this issue.

Will it be possible to record a video demonstrating this?

You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Tue 24 Dec 2019 10:44
by vialus
I have fixed it by
1. deleting the table
2. deleting this line of average row length from the project file
3. restoring the table from the project file

Re: Cant change AVG_ROW_LENGTH parameter

Posted: Wed 25 Dec 2019 13:15
by alexa
Thank you for updating us on this issue.

Please let us know if any questions arise.