Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=key_buffer_size, value=16777216, method=immediate"
Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=myisam_sort_buffer_size, value=8388608, method=immediate"
Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=innodb_buffer_pool_size, value=402653184, method=pending-reboot" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=max_connections, value=24, method=immediate"ĭEFAULTS-except max_allowed_packet. Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=key_buffer_size, value=8388608, method=immediate" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=myisam_sort_buffer_size, value=1048576, method=immediate"
Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=innodb_buffer_pool_size, value=134217728, method=pending-reboot" # the following parameter must be 'pending-reboot' Rds-reboot-db-instance "my-database-param-groups" # Reboot is also possible from the Amazon RDS Console # You can assigin DB PARAMETER GROUP FROM AMAZON RDS CONSOLE # Note, collation_database is not a valid setting Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=collation_connection, value=utf8_unicode_ci, method=immediate" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=character_set_database, value=utf8, method=immediate" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=collation_server, value=utf8_unicode_ci, method=immediate" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=character_set_server, value=utf8, method=immediate" # rds-modify-db-parameter-group "my-database-param-group" -parameters "name=innodb_log_file_size, value=67108864, method=pending-reboot" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=innodb_buffer_pool_size, value=268435456, method=pending-reboot" Rds-modify-db-parameter-group "my-database-param-group" -parameters "name=max_allowed_packet, value=67108864, method=immediate" # Show current status of database instances (rebooting, active, etc.) SET AWS_CREDENTIAL_FILE="C:\RDSCli\aws-credential-file.txt" SET JAVA_HOME="C:\Program Files\Java\jre6" # Double-click this batch file to open a pre-prepared command prompt # Add the following lines to a batch file called setup-rds-environment.bat # Check the version of Java (must be at least 1.6 for RDSCLI 1.12+) # You can create a DB PARAMETER GROUP FROM AMAZON RDS CONSOLE # Change the MySQL database character set to UTF-8ĪLTER DATABASE my_database DEFAULT CHARACTER SET utf8 # Change the MySQL database collation to UTF-8ĪLTER DATABASE my_database DEFAULT COLLATE utf8_unicode_ci | character_sets_dir | /usr/local/share/mysql/charsets/ | # Show current character set variable settings | collation_connection | utf8_unicode_ci | # Show current collation variable settings The utf8_general_ci collation takes shortcuts and does not sort exactly right in certain languages, and its only benefit is a tiny performance increase. It provides correct sorting in all languages. In general, utf8_unicode_ci should always be used.
utf8_unicode_ci vs utf8_general_ci collation
MYSQL CREATE DATABASE UTF8 GENERAL CI HOW TO
There are also notes on how to set the dfeault collation and characters set to UTF-8 on Amazon RDS MySQL database instances. These are notes for how to set UTF-8 (UTF8) collation and character set in MySQL database server. § Home > Index > Web Development Set MySQL character set and collation to UTF-8 (RDS)
0 kommentar(er)
