I have a MySQL 5.7.16 Enterprise running on a Centos 6 machine with InnoDB as the default storage engine. I have around 300 tables in which around 90 are "list" partitioned.

I have the option innodb_stats_on_metadata=0 in my server configuration.

When I query the metadata using the query,

SELECT * FROM information_schema.TABLES WHERE TABLE_sCHEMA = 'mydb';

I can see the column CREATE_OPTIONS as empty for some non-partitioned columns, row_format=DYNAMIC for some non-partitioned tables, partitioned for some partitioned tables and row_format=DYNAMIC partitioned for some partitioned tables.

Why does this happen when all my tables have the same row format "Dynamic"?

I have table collations as "utf8_general_ci" for some tables and "latin1_swedish_ci" for some tables. Does this have something to do with the above scenario?

  • Do you have any evidence that LIST partitioning is beneficial?
    – Rick James
    Oct 8, 2017 at 0:32
  • Besides being beneficial, it's required for our domain. Oct 9, 2017 at 7:09
  • What do you mean by "required for our domain"??
    – Rick James
    Oct 9, 2017 at 21:38
  • We have to maintain data for multiple clients and each client has huge and different data in the same structure. So, list partitioning is the only method we can adopt Oct 10, 2017 at 6:05

1 Answer 1


I got answer for my question. "CREATE_OPTIONS" gets updated as row_format=DYNAMIC when you specify it in the create statement explicitly. For partitioned tables, it takes row_format=DYNAMIC partitioned.

Table collation has nothing to do with it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.