Create Custom DB Parameter Groups

You must modify some of the parameters for your database instance.

Note: Any parameters not modified retain their default values.
ParameterRecommended Value
innodb_lock_wait_timeout180
innodb_max_dirty_pages_pct20
lock_wait_timeout180
log_bin_trust_function_creators1
max_allowed_packet104857600
max_heap_table_size1610612736
sql_mode0
tmp_table_size67108864
wait_timeout31536000

To create custom DB parameter groups:

  1. Navigate to the Parameter groups page on the Amazon RDS in the AWS console.
  2. Click Create parameter group on the top right of the page.Create parameter group button
  3. Enter the group details:
  4. Modify the parameter values in this group:
  5. Create a custom DB cluster parameter group:

  6. Modify the parameter values in this group as follows:

    ParameterRecommended Value
    character_set_clientutf8
    character_set_connectionutf8
    character_set_databaseutf8
    character_set_filesystembinary
    character_set_resultsutf8
    character_set_serverutf8
    collation_connectionutf8_general_ci
    collation_serverutf8_unicode_ci
    innodb_default_row_formatDYNAMIC
    innodb_file_per_table1
    lower_case_table_names1