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_timeout 180
innodb_max_dirty_pages_pct 20
lock_wait_timeout 180
log_bin_trust_function_creators 1
max_allowed_packet 104857600
max_heap_table_size 1610612736
sql_mode 0
tmp_table_size 67108864
wait_timeout 31536000

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_client utf8
    character_set_connection utf8
    character_set_database utf8
    character_set_filesystem binary
    character_set_results utf8
    character_set_server utf8
    collation_connection utf8_general_ci
    collation_server utf8_unicode_ci
    innodb_default_row_format DYNAMIC
    innodb_file_per_table 1
    lower_case_table_names 1