Menu
What is the MySQL statement to alter the row_format to dynamic?
I am not sure how I am supposed to do it (i.e. using the information_schema or by using a table ALTER).
690
Select a row or a range of rows. On the Home tab, select Format > Row Width (or Row Height).
The DYNAMIC row format is based on the idea that if a portion of a long data value is stored off-page, it is usually most efficient to store the entire value off-page. With DYNAMIC format, shorter columns are likely to remain in the B-tree node, minimizing the number of overflow pages required for a given row.
The default row format for InnoDB tables is COMPACT . The row format of a table can be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. For example: CREATE TABLE t1 (c1 INT) ROW_FORMAT=COMPACT; ROW_FORMAT options include REDUNDANT , COMPACT , DYNAMIC , and COMPRESSED .
try
ALTER TABLE `test` ROW_FORMAT=DYNAMIC;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
