Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Use row_format=dynamic by default when creating a table #16834

Closed
tsteur opened this issue Nov 29, 2020 · 1 comment · Fixed by #18002
Closed

Use row_format=dynamic by default when creating a table #16834

tsteur opened this issue Nov 29, 2020 · 1 comment · Fixed by #18002
Assignees
@peterhashair
Labels
Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Milestone
4.6.0

Comments

@tsteur
Copy link
Member

tsteur commented Nov 29, 2020 •
edited

see https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html

when creating a table can we specify the dynamic format like CREATE TABLE t1 (c1 INT) ROW_FORMAT=DYNAMIC;?

refs #16810 to avoid row size too large error.

We'd need to check that this works on all MySQL or not sure if we need to check whether dynamic row format is supported or whether some MySQL maybe don't support it.
@tsteur tsteur added the Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change. label Nov 29, 2020
@tsteur tsteur added this to the 4.2.0 milestone Nov 29, 2020
@tsteur
Copy link
Member Author

tsteur commented Nov 29, 2020

Note: row format dynamic requires the same settings as utf8mb4... e.g innodb_file format=Barracuda and enabled innodb_file_per_table

@tsteur tsteur added the Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement. label Jul 15, 2021
@peterhashair peterhashair self-assigned this Sep 15, 2021
This was linked to pull requests Sep 15, 2021
M 16834 mysql row format #18000
Closed
add mysql row format dynamic option #18002
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@peterhashair peterhashair

Labels
Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Projects
None yet
Milestone
4.6.0
2 participants
@tsteur @peterhashair