Skip to content

New Aurora lower_case_table_names

0

The major update to aurora seems not to have the lower_case_table_names parameter. Am I missing something?

asked 3 years ago1.2K views
1 Answer
2

The lower_case_table_names parameter is a MySQL configuration parameter that determines how the database engine stores and looks up table names.

In Amazon Aurora, the value of the lower_case_table_names parameter is determined by the underlying MySQL version and cannot be modified.

It's worth noting that Amazon Aurora MySQL is compatible with MySQL 5.6 and 5.7, and the lower_case_table_names parameter behaves differently between these two versions. In MySQL 5.6, lower_case_table_names can be set to 0, 1, or 2. In MySQL 5.7, lower_case_table_names can only be set to 0 or 1.

So, to answer your question, the lower_case_table_names parameter is not explicitly available for modification in Amazon Aurora, but its behavior is determined by the underlying MySQL version.

AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.