{"id":162169,"date":"2012-12-11T12:04:03","date_gmt":"2012-12-11T08:04:03","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=162169"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=162169","title":{"rendered":"AWS Insight: RDS Parameter Groups \u2014 \u0447\u0442\u043e \u044d\u0442\u043e \u0438 \u0437\u0430\u0447\u0435\u043c<\/span>"},"content":{"rendered":"
\t\u041f\u0440\u0438\u0432\u0435\u0442! \"image\"<\/p>\n

\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0430\u0445 AWS RDS<\/a>. \u041a\u0430\u043a \u0432\u044b \u0437\u043d\u0430\u0435\u0442\u0435, RDS \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u0430\u043c \u043f\u0440\u043e\u0441\u0442\u0443\u044e \u0442\u043e\u0447\u043a\u0443 \u0432\u0445\u043e\u0434\u0430 \u0432 \u0411\u0414. \u041d\u0438 \u043a \u0434\u0438\u0441\u043a\u0443, \u043d\u0438 \u0432 \u0441\u0430\u043c\u0443 \u041e\u0421 \u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u043c \u0411\u0414 \u0443 \u043d\u0430\u0441 \u043d\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f\u0430. \u0422\u0430\u043a \u0436\u0435 \u043c\u044b \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u044b \u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u043d\u0435\u043a\u043e\u0435\u0433\u043e \u0441\u0443\u043f\u0435\u0440\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f, \u043d\u043e \u044d\u0442\u043e \u043d\u0435 root \u0432\u0441\u0451 \u0440\u0430\u0432\u043d\u043e. <\/p>\n

RDS Parameter Groups \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u0443\u0436\u043d\u0443\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044e \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u043e\u043a\u0430\u0436\u0443 \u043a\u0430\u043a \u0440\u0430\u0437\u0440\u0435\u0448\u0438\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440 \u0432 RDS \u043f\u043e\u0434 MySQL. \u041f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0434\u0435\u0444\u043e\u043b\u0442\u043d\u0430\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0430. \u0412 \u043d\u0435\u0439 \u0436\u0435 \u043c\u043e\u0436\u043d\u043e \u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432: <\/p>\n

$ rds-describe-db-parameters default.mysql5.1 <\/code><\/pre>\n
<\/a>  <\/p>\n
\u0412\u044b\u0432\u043e\u0434 \u043a\u043e\u043c\u0430\u043d\u0434\u044b<\/b><\/p>\n
\n
 DBPARAMETER  allow-suspicious-udfs                                                               engine-default  boolean  static   false   DBPARAMETER  auto_increment_increment                                                            engine-default  integer  dynamic  true    DBPARAMETER  auto_increment_offset                                                               engine-default  integer  dynamic  true    DBPARAMETER  automatic_sp_privileges                                                             engine-default  boolean  dynamic  true    DBPARAMETER  back_log                                                                            engine-default  integer  static   true    DBPARAMETER  basedir                                  \/rdsdbbin\/mysql                            system          string   static   false   DBPARAMETER  binlog_cache_size                        32768                                      system          integer  dynamic  true    DBPARAMETER  binlog_format                            MIXED                                      system          string   dynamic  false   DBPARAMETER  bulk_insert_buffer_size                                                             engine-default  integer  dynamic  true    DBPARAMETER  character-set-client-handshake                                                      engine-default  boolean  static   true    DBPARAMETER  character_set_client                                                                engine-default  string   dynamic  true    DBPARAMETER  character_set_connection                                                            engine-default  string   dynamic  true    DBPARAMETER  character_set_database                                                              engine-default  string   dynamic  true    DBPARAMETER  character_set_filesystem                                                            engine-default  string   dynamic  true    DBPARAMETER  character_set_results                                                               engine-default  string   dynamic  true    DBPARAMETER  character_set_server                                                                engine-default  string   dynamic  true    DBPARAMETER  collation_connection                                                                engine-default  string   dynamic  true    DBPARAMETER  collation_server                                                                    engine-default  string   dynamic  true    DBPARAMETER  completion_type                                                                     engine-default  integer  dynamic  true    DBPARAMETER  concurrent_insert                                                                   engine-default  integer  dynamic  true    DBPARAMETER  connect_timeout                                                                     engine-default  integer  dynamic  true    DBPARAMETER  datadir                                  \/rdsdbdata\/db\/                             system          string   static   false   DBPARAMETER  default_storage_engine                   InnoDB                                     system          string   dynamic  false   DBPARAMETER  default_time_zone                                                                   engine-default  string   static   false   DBPARAMETER  default_week_format                                                                 engine-default  integer  dynamic  true    DBPARAMETER  delay_key_write                                                                     engine-default  string   dynamic  true    DBPARAMETER  delayed_insert_limit                                                                engine-default  integer  dynamic  true    DBPARAMETER  delayed_insert_timeout                                                              engine-default  integer  dynamic  true    DBPARAMETER  delayed_queue_size                                                                  engine-default  integer  dynamic  true    DBPARAMETER  div_precision_increment                                                             engine-default  integer  dynamic  true    DBPARAMETER  event_scheduler                                                                     engine-default  string   dynamic  true    DBPARAMETER  flush                                                                               engine-default  boolean  dynamic  false   DBPARAMETER  flush_time                                                                          engine-default  integer  dynamic  true    DBPARAMETER  ft_boolean_syntax                                                                   engine-default  string   dynamic  false   DBPARAMETER  ft_max_word_len                                                                     engine-default  integer  static   true    DBPARAMETER  ft_min_word_len                                                                     engine-default  integer  static   true    DBPARAMETER  ft_query_expansion_limit                                                            engine-default  integer  static   true    DBPARAMETER  ft_stopword_file                                                                    engine-default  string   static   true    DBPARAMETER  general_log                                                                         engine-default  boolean  dynamic  true    DBPARAMETER  group_concat_max_len                                                                engine-default  integer  dynamic  true    DBPARAMETER  ignore_builtin_innodb                    1                                          system          boolean  static   false  5.1.49 DBPARAMETER  init_connect                                                                        engine-default  string   dynamic  true    DBPARAMETER  innodb_adaptive_flushing                                                            engine-default  boolean  dynamic  true   5.1.49 DBPARAMETER  innodb_adaptive_hash_index                                                          engine-default  boolean  static   true    DBPARAMETER  innodb_additional_mem_pool_size          2097152                                    system          integer  static   true    DBPARAMETER  innodb_autoextend_increment                                                         engine-default  integer  dynamic  true    DBPARAMETER  innodb_autoinc_lock_mode                                                            engine-default  integer  static   true    DBPARAMETER  innodb_buffer_pool_size                  {DBInstanceClassMemory*3\/4}                system          integer  static   true    DBPARAMETER  innodb_change_buffering                                                             engine-default  string   dynamic  true   5.1.49 DBPARAMETER  innodb_commit_concurrency                                                           engine-default  integer  static   true    DBPARAMETER  innodb_concurrency_tickets                                                          engine-default  integer  dynamic  true    DBPARAMETER  innodb_data_home_dir                     \/rdsdbdata\/db\/innodb                       system          string   static   false   DBPARAMETER  innodb_file_format                                                                  engine-default  string   dynamic  true   5.1.49 DBPARAMETER  innodb_file_per_table                    1                                          system          boolean  static   true    DBPARAMETER  innodb_flush_log_at_trx_commit                                                      engine-default  integer  dynamic  true    DBPARAMETER  innodb_flush_method                      O_DIRECT                                   system          string   static   false   DBPARAMETER  innodb_io_capacity                                                                  engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_lock_wait_timeout                                                            engine-default  integer  static   true    DBPARAMETER  innodb_locks_unsafe_for_binlog                                                      engine-default  boolean  static   false   DBPARAMETER  innodb_log_buffer_size                   8388608                                    system          integer  static   true    DBPARAMETER  innodb_log_file_size                     134217728                                  system          integer  static   false   DBPARAMETER  innodb_log_group_home_dir                \/rdsdbdata\/log\/innodb                      system          string   static   false   DBPARAMETER  innodb_max_dirty_pages_pct                                                          engine-default  integer  dynamic  true    DBPARAMETER  innodb_max_purge_lag                                                                engine-default  integer  dynamic  true    DBPARAMETER  innodb_old_blocks_pct                                                               engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_old_blocks_time                                                              engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_open_files                                                                   engine-default  integer  static   true    DBPARAMETER  innodb_random_read_ahead                                                            engine-default  boolean  dynamic  true   5.1.61 DBPARAMETER  innodb_read_ahead_threshold                                                         engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_read_io_threads                                                              engine-default  integer  static   true   5.1.49 DBPARAMETER  innodb_replication_delay                                                            engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_rollback_on_timeout                                                          engine-default  boolean  static   true    DBPARAMETER  innodb_spin_wait_delay                                                              engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_stats_on_metadata                                                            engine-default  boolean  static   true    DBPARAMETER  innodb_stats_sample_pages                                                           engine-default  integer  dynamic  true   5.1.49 DBPARAMETER  innodb_strict_mode                                                                  engine-default  boolean  dynamic  true   5.1.49 DBPARAMETER  innodb_support_xa                                                                   engine-default  boolean  dynamic  true    DBPARAMETER  innodb_sync_spin_loops                                                              engine-default  integer  dynamic  true    DBPARAMETER  innodb_table_locks                                                                  engine-default  boolean  dynamic  true    DBPARAMETER  innodb_thread_concurrency                                                           engine-default  integer  dynamic  true    DBPARAMETER  innodb_thread_sleep_delay                                                           engine-default  integer  dynamic  true    DBPARAMETER  innodb_use_legacy_cardinality_algorithm                                             engine-default  boolean  dynamic  false   DBPARAMETER  innodb_use_sys_malloc                                                               engine-default  boolean  static   true   5.1.49 DBPARAMETER  innodb_write_io_threads                                                             engine-default  integer  static   true   5.1.49 DBPARAMETER  interactive_timeout                                                                 engine-default  integer  dynamic  true    DBPARAMETER  join_buffer_size                                                                    engine-default  integer  dynamic  true    DBPARAMETER  keep_files_on_create                                                                engine-default  boolean  dynamic  true    DBPARAMETER  key_buffer_size                          16777216                                   system          integer  dynamic  true    DBPARAMETER  key_cache_age_threshold                                                             engine-default  integer  dynamic  true    DBPARAMETER  key_cache_block_size                                                                engine-default  integer  dynamic  true    DBPARAMETER  key_cache_division_limit                                                            engine-default  integer  dynamic  true    DBPARAMETER  language                                 \/rdsdbbin\/mysql\/share\/mysql\/english\/       system          string   static   false   DBPARAMETER  lc_time_names                                                                       engine-default  string   dynamic  true    DBPARAMETER  local_infile                             1                                          system          boolean  dynamic  true    DBPARAMETER  log-bin                                  \/rdsdbdata\/log\/binlog\/mysql-bin-changelog  system          string   static   false   DBPARAMETER  log_bin_trust_function_creators                                                     engine-default  boolean  dynamic  true    DBPARAMETER  log_error                                \/rdsdbdata\/log\/error\/mysql-error.log       system          string   static   false   DBPARAMETER  log_output                               TABLE                                      system          string   dynamic  false   DBPARAMETER  log_queries_not_using_indexes                                                       engine-default  boolean  dynamic  true    DBPARAMETER  log_slave_updates                                                                   engine-default  boolean  static   true    DBPARAMETER  log_warnings                                                                                                                                                                                                                                                                                                         engine-default  integer  dynamic  true    DBPARAMETER  long_query_time                                                                                                                                                                                                                                                                                                      engine-default  integer  dynamic  true    DBPARAMETER  low_priority_updates                                                                                                                                                                                                                                                                                                 engine-default  boolean  dynamic  true    DBPARAMETER  lower_case_table_names                                                                                                                                                                                                                                                                                               engine-default  integer  static   true    DBPARAMETER  max_allowed_packet                                                                                                                                                                                                                                                                                                   engine-default  integer  dynamic  true    DBPARAMETER  max_binlog_cache_size                                                                                                                                                                                                                                                                                                engine-default  integer  dynamic  true    DBPARAMETER  max_binlog_size                      134217728                                                                                                                                                                                                                                                                       system          integer  dynamic  false   DBPARAMETER  max_connect_errors                                                                                                                                                                                                                                                                                                   engine-default  integer  dynamic  true    DBPARAMETER  max_connections                      {DBInstanceClassMemory\/12582880}                                                                                                                                                                                                                                                system          integer  dynamic  true    DBPARAMETER  max_delayed_threads                                                                                                                                                                                                                                                                                                  engine-default  integer  dynamic  true    DBPARAMETER  max_error_count                                                                                                                                                                                                                                                                                                      engine-default  integer  dynamic  true    DBPARAMETER  max_heap_table_size                                                                                                                                                                                                                                                                                                  engine-default  integer  dynamic  true    DBPARAMETER  max_insert_delayed_threads                                                                                                                                                                                                                                                                                           engine-default  integer  dynamic  true    DBPARAMETER  max_join_size                                                                                                                                                                                                                                                                                                        engine-default  integer  dynamic  true    DBPARAMETER  max_length_for_sort_data                                                                                                                                                                                                                                                                                             engine-default  integer  dynamic  true    DBPARAMETER  max_prepared_stmt_count                                                                                                                                                                                                                                                                                              engine-default  integer  dynamic  true    DBPARAMETER  max_seeks_for_key                                                                                                                                                                                                                                                                                                    engine-default  integer  dynamic  true    DBPARAMETER  max_sort_length                                                                                                                                                                                                                                                                                                      engine-default  integer  dynamic  true    DBPARAMETER  max_sp_recursion_depth                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  max_tmp_tables                                                                                                                                                                                                                                                                                                       engine-default  integer  dynamic  true    DBPARAMETER  max_user_connections                                                                                                                                                                                                                                                                                                 engine-default  integer  dynamic  true    DBPARAMETER  max_write_lock_count                                                                                                                                                                                                                                                                                                 engine-default  integer  dynamic  true    DBPARAMETER  min_examined_row_limit                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  myisam_data_pointer_size                                                                                                                                                                                                                                                                                             engine-default  integer  dynamic  true    DBPARAMETER  myisam_max_sort_file_size                                                                                                                                                                                                                                                                                            engine-default  integer  dynamic  true    DBPARAMETER  myisam_sort_buffer_size                                                                                                                                                                                                                                                                                              engine-default  integer  dynamic  true    DBPARAMETER  myisam_stats_method                                                                                                                                                                                                                                                                                                  engine-default  string   dynamic  true    DBPARAMETER  myisam_use_mmap                                                                                                                                                                                                                                                                                                      engine-default  boolean  dynamic  true    DBPARAMETER  net_buffer_length                                                                                                                                                                                                                                                                                                    engine-default  integer  dynamic  true    DBPARAMETER  net_read_timeout                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  net_retry_count                                                                                                                                                                                                                                                                                                      engine-default  integer  dynamic  true    DBPARAMETER  net_write_timeout                                                                                                                                                                                                                                                                                                    engine-default  integer  dynamic  true    DBPARAMETER  old-style-user-limits                                                                                                                                                                                                                                                                                                engine-default  boolean  static   true    DBPARAMETER  old_passwords                                                                                                                                                                                                                                                                                                        engine-default  boolean  dynamic  true    DBPARAMETER  optimizer_prune_level                                                                                                                                                                                                                                                                                                engine-default  boolean  dynamic  true    DBPARAMETER  optimizer_search_depth                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  optimizer_switch                                                                                                                                                                                                                                                                                                     engine-default  string   dynamic  true    DBPARAMETER  pid_file                             \/rdsdbdata\/log\/mysql-{EndPointPort}.pid                                                                                                                                                                                                                                         system          string   static   false   DBPARAMETER  plugin-load                          innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so  system          string   static   false  5.1.49 DBPARAMETER  plugin_dir                           \/rdsdbbin\/mysql\/lib\/mysql\/plugin                                                                                                                                                                                                                                                system          string   static   false   DBPARAMETER  port                                 {EndPointPort}                                                                                                                                                                                                                                                                  system          integer  static   false   DBPARAMETER  preload_buffer_size                                                                                                                                                                                                                                                                                                  engine-default  integer  dynamic  true    DBPARAMETER  profiling_history_size                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  query_alloc_block_size                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  query_cache_limit                                                                                                                                                                                                                                                                                                    engine-default  integer  dynamic  true    DBPARAMETER  query_cache_min_res_unit                                                                                                                                                                                                                                                                                             engine-default  integer  dynamic  true    DBPARAMETER  query_cache_size                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  query_cache_type                                                                                                                                                                                                                                                                                                     engine-default  integer  static   true    DBPARAMETER  query_cache_wlock_invalidate                                                                                                                                                                                                                                                                                         engine-default  boolean  dynamic  true    DBPARAMETER  query_prealloc_size                                                                                                                                                                                                                                                                                                  engine-default  integer  dynamic  true    DBPARAMETER  range_alloc_block_size                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  read_buffer_size                     262144                                                                                                                                                                                                                                                                          system          integer  dynamic  true    DBPARAMETER  read_only                            {TrueIfReplica}                                                                                                                                                                                                                                                                 engine-default  boolean  dynamic  true   5.1.50 DBPARAMETER  read_rnd_buffer_size                 524288                                                                                                                                                                                                                                                                          system          integer  dynamic  true    DBPARAMETER  relay-log                            \/rdsdbdata\/log\/relaylog\/relaylog                                                                                                                                                                                                                                                system          string   static   false  5.1.50 DBPARAMETER  safe-user-create                                                                                                                                                                                                                                                                                                     engine-default  boolean  static   true    DBPARAMETER  secure_auth                                                                                                                                                                                                                                                                                                          engine-default  boolean  dynamic  true    DBPARAMETER  secure_file_priv                     \/tmp                                                                                                                                                                                                                                                                            system          string   static   false   DBPARAMETER  server_id                            {ServerId}                                                                                                                                                                                                                                                                      system          integer  dynamic  false  5.1.50 DBPARAMETER  skip-character-set-client-handshake                                                                                                                                                                                                                                                                                  engine-default  boolean  static   true    DBPARAMETER  skip_external_locking                                                                                                                                                                                                                                                                                                engine-default  boolean  static   false   DBPARAMETER  skip_name_resolve                                                                                                                                                                                                                                                                                                    engine-default  boolean  static   true   5.1.57 DBPARAMETER  skip_show_database                                                                                                                                                                                                                                                                                                   engine-default  boolean  static   false   DBPARAMETER  slow_launch_time                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  slow_query_log                                                                                                                                                                                                                                                                                                       engine-default  boolean  dynamic  true    DBPARAMETER  socket                               \/tmp\/mysql.sock                                                                                                                                                                                                                                                                 system          string   static   false   DBPARAMETER  sort_buffer_size                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  sql_mode                                                                                                                                                                                                                                                                                                             engine-default  string   dynamic  true    DBPARAMETER  sql_select_limit                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  sync_binlog                                                                                                                                                                                                                                                                                                          engine-default  integer  dynamic  true    DBPARAMETER  sync_frm                                                                                                                                                                                                                                                                                                             engine-default  boolean  dynamic  true    DBPARAMETER  sysdate-is-now                                                                                                                                                                                                                                                                                                       engine-default  boolean  static   true    DBPARAMETER  table_definition_cache                                                                                                                                                                                                                                                                                               engine-default  integer  dynamic  true    DBPARAMETER  table_open_cache                                                                                                                                                                                                                                                                                                     engine-default  integer  dynamic  true    DBPARAMETER  temp-pool                                                                                                                                                                                                                                                                                                            engine-default  boolean  static   true    DBPARAMETER  thread_cache_size                                                                                                                                                                                                                                                                                                    engine-default  integer  dynamic  true    DBPARAMETER  thread_stack                         196608                                                                                                                                                                                                                                                                          engine-default  integer  static   true    DBPARAMETER  timed_mutexes                                                                                                                                                                                                                                                                                                        engine-default  boolean  dynamic  true    DBPARAMETER  tmp_table_size                                                                                                                                                                                                                                                                                                       engine-default  integer  dynamic  true    DBPARAMETER  tmpdir                               \/rdsdbdata\/tmp                                                                                                                                                                                                                                                                  system          string   static   false   DBPARAMETER  transaction_alloc_block_size                                                                                                                                                                                                                                                                                         engine-default  integer  dynamic  true    DBPARAMETER  transaction_prealloc_size                                                                                                                                                                                                                                                                                            engine-default  integer  dynamic  true    DBPARAMETER  tx_isolation                                                                                                                                                                                                                                                                                                         engine-default  string   dynamic  true    DBPARAMETER  updatable_views_with_limit                                                                                                                                                                                                                                                                                           engine-default  boolean  dynamic  true    DBPARAMETER  wait_timeout                                                                                                                                                                                                                                                                                                         engine-default  integer  dynamic  true  <\/pre>\n
  <\/div>\n<\/div>\n
  \u0421\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u0433\u043e\u0432\u043e\u0440\u044f, \u043f\u043e \u044d\u0442\u0438 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043c\u043e\u0436\u043d\u043e \u043c\u0435\u043d\u044f\u0442\u044c, \u0442\u0435\u043c \u0441\u0430\u043c\u044b\u043c \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u044f \u0438 \u043f\u043e\u0434\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u044f \u043a\u043e\u043d\u0444\u0438\u0433 \u0432\u0430\u0448\u0435\u0439 \u0411\u0414. <\/p>\n
  \u041f\u0435\u0440\u0435\u0439\u0434\u0451\u043c \u043a \u043f\u0440\u0438\u043c\u0435\u0440\u0443 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u044b:<\/p>\n
  1. \u0421\u043e\u0437\u0434\u0451\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0443 extended-mysql<\/b>  <\/p>\n
$ rds-create-db-parameter-group extended-mysql -f mysql5.1 -d "allows to store functions" <\/code><\/pre>\n
  2. \u041c\u0435\u043d\u044f\u0435\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 log_bin_trust_function_creators<\/b>  <\/p>\n
$ rds-modify-db-parameter-group extended-mysql --parameters="name=log_bin_trust_function_creators, value=on, method=immediate\u201d <\/code><\/pre>\n
  \u0412\u043e\u0442 \u0438 \u0432\u0441\u0451. \u042d\u0442\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0430 \u0434\u0430\u0441\u0442 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0431\u0443\u0434\u0443\u0442 \u0445\u0440\u0430\u043d\u0438\u0442\u044c\u0441\u044f \u0432 RDS.<\/p>\n
  3. \u0412\u0435\u043d\u0435\u0441\u0451\u043c \u0441\u0435\u0440\u0432\u0435\u0440 \u0432 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0443<\/b>  <\/p>\n
$  rds-modify-db-instance myrdsserver --db-parameter-group-name=extended-mysql  <\/code><\/pre>\n
  4. \u041f\u0435\u0440\u0435\u0433\u0440\u0443\u0437\u0438\u043c \u0441\u0435\u0440\u0432\u0435\u0440, \u0447\u0442\u043e\u0431\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u043b\u0438\u0441\u044c<\/b>  <\/p>\n
$ rds-reboot-db-instance  myrdsserver <\/code><\/pre>\n
  \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435 \u043b\u0438 \u0432\u044b \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u043b\u044f RDS? \u0421 \u043a\u0430\u043a\u0438\u043c\u0438 \u0433\u0440\u0430\u0431\u043b\u044f\u043c\u0438 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u043b\u0438\u0441\u044c \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u043d\u0438\u043c\u0438? \u041e\u0447\u0435\u043d\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u0443\u0441\u043b\u044b\u0448\u0430\u0442\u044c \u0447\u0442\u043e-\u0442\u043e \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0435!    \t   \t<\/p>\n
<\/div>\n<\/p><\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  http:\/\/habrahabr.ru\/company\/epam_systems\/blog\/162169\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
   \t\u041f\u0440\u0438\u0432\u0435\u0442! \"image\"<\/p>\n
  \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0430\u0445 AWS RDS<\/a>. \u041a\u0430\u043a \u0432\u044b \u0437\u043d\u0430\u0435\u0442\u0435, RDS \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u0430\u043c \u043f\u0440\u043e\u0441\u0442\u0443\u044e \u0442\u043e\u0447\u043a\u0443 \u0432\u0445\u043e\u0434\u0430 \u0432 \u0411\u0414. \u041d\u0438 \u043a \u0434\u0438\u0441\u043a\u0443, \u043d\u0438 \u0432 \u0441\u0430\u043c\u0443 \u041e\u0421 \u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u043c \u0411\u0414 \u0443 \u043d\u0430\u0441 \u043d\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f\u0430. \u0422\u0430\u043a \u0436\u0435 \u043c\u044b \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u044b \u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u043d\u0435\u043a\u043e\u0435\u0433\u043e \u0441\u0443\u043f\u0435\u0440\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f, \u043d\u043e \u044d\u0442\u043e \u043d\u0435 root \u0432\u0441\u0451 \u0440\u0430\u0432\u043d\u043e. <\/p>\n
  RDS Parameter Groups \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u0443\u0436\u043d\u0443\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044e \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u043e\u043a\u0430\u0436\u0443 \u043a\u0430\u043a \u0440\u0430\u0437\u0440\u0435\u0448\u0438\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440 \u0432 RDS \u043f\u043e\u0434 MySQL. \u041f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0434\u0435\u0444\u043e\u043b\u0442\u043d\u0430\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0440\u0443\u043f\u043f\u0430. \u0412 \u043d\u0435\u0439 \u0436\u0435 \u043c\u043e\u0436\u043d\u043e \u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432:  <\/p>\n
$ rds-describe-db-parameters default.mysql5.1 <\/code><\/pre>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-162169","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/162169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=162169"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/162169\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}