Changing MySQL configuration Parameters via SSH
This article lists all the default configurations for MySQL on our platform and describes how you can change those configurations. If you need further information, please contact us via tickets.
MySQL Default Configurations：
|key_buffer_size = 128M||max_allowed_packet = 512M||thread_stack = 256K|
|thread_cache_size = 8||read_buffer_size = 16M||join_buffer_size = 16M|
|read_rnd_buffer_size = 32M||event_scheduler = 1||max_connections = 1000|
|table_open_cache = 5000||query_cache_type = 1||query_cache_limit = 2M|
|query_cache_size = 64M||thread_cache_size = 300||max_binlog_size = 100M|
|default_storage_engine = InnoDB||innodb_buffer_pool_instances = 2||innodb_buffer_pool_size = 2G|
|innodb_file_per_table = 1||innodb_flush_log_at_trx_commit = 0||innodb_flush_method = O_DIRECT|
|innodb_log_buffer_size = 16M||innodb_log_file_size = 512M||innodb_stats_on_metadata = 0|
|innodb_temp_data_file_path = ibtmp1:64M:autoextend:max:20G||innodb_thread_concurrency = 0||innodb_read_io_threads = 64|
|innodb_write_io_threads = 64||innodb_autoextend_increment = 64|
Change MySQL Configuration Parameters：
We will show you how to change the configurations via Shell / SSH feature in the Control Panel.
Note: For security reasons, only the accounts have passed our verification will be granted permission to the Shell / SSH service. If you would like to enable it, please update your billing information. Our staff will finish verifying your information within 2 hours.
1. Locate the target deployment
Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.
2. Navigate to the “Shell / SSH” page
Click the "Manage" button on the Home page or the My Applications page to go to the Shell / SSH page.
3. Change the setting parameters
Note: Before you actually make changes to setting parameters, please make sure you have a backup file of your database. This will give you peace of mind if mistakes are made during the change and your service is down.
Connect to the instance via SSH
Click the “Connect” icon on the Shell / SSH page to launch the command-line interface.
For security reasons, only the accounts have passed our verification will be granted permission to the Shell / SSH service. If you would like to enable it, please update your billing information. Our staff will finish verifying your information within 2 hours.
Check the setting parameters
Enter the command “
cd config/” to change to the “/cloudclusters/config” directory, followed by the command “
ls” to check the files under the directory. You can see the configuration file for MySQL: mysqld.cnf.
Change the setting parameters
Input the command “
vim mysqld.cnf” to go to the editing interface.
Now press the “a” key on your keyboard so you can start changing configurations. After the editing, hit the “Esc” key, followed by entering the “:wq” to save the changes.
Make the changes effective
Click “Reboot” on the Shell / SSH page to make the changes effective. Once you start the reboot process, the status will be changed to “Startup”. It may take 1-2 minutes to complete the reboot process. When it’s finished, the status will be changed back to “Running”, and you can repeat the steps as said above to check the configuration file.