Cant change AVG_ROW_LENGTH parameter

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
vialus
Posts: 5
Joined: Tue 17 Dec 2019 15:08

Cant change AVG_ROW_LENGTH parameter

Post by vialus » Tue 17 Dec 2019 15:13

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;

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: Cant change AVG_ROW_LENGTH parameter

Post by alexa » Wed 18 Dec 2019 12:04

You would need to exclude the 'Include average row length' option in the settings (select 'Tools -> Options...' from the main menu)
Image

vialus
Posts: 5
Joined: Tue 17 Dec 2019 15:08

Re: Cant change AVG_ROW_LENGTH parameter

Post by vialus » Wed 18 Dec 2019 12:43

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.

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: Cant change AVG_ROW_LENGTH parameter

Post by alexa » Thu 19 Dec 2019 12:41

Please set this setting to 0 in the table editor

Image

vialus
Posts: 5
Joined: Tue 17 Dec 2019 15:08

Re: Cant change AVG_ROW_LENGTH parameter

Post by vialus » Thu 19 Dec 2019 13:02

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
=========================

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: Cant change AVG_ROW_LENGTH parameter

Post by alexa » Fri 20 Dec 2019 08:41

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 .

vialus
Posts: 5
Joined: Tue 17 Dec 2019 15:08

Re: Cant change AVG_ROW_LENGTH parameter

Post by vialus » Tue 24 Dec 2019 10:44

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

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: Cant change AVG_ROW_LENGTH parameter

Post by alexa » Wed 25 Dec 2019 13:15

Thank you for updating us on this issue.

Please let us know if any questions arise.

Post Reply