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.

Locate the target deployment

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.

Navigate 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.

Initiate an SSH session

Log in via SSH

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.

Redirect to update billing info

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.

Check the setting parameters

Change the setting parameters

Input the command “vim mysqld.cnf” to go to the editing interface.

Edit the setting parameters

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.

Save the edits

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.

Make the changes effective

Copyright © 2021 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 05/05/2023

results matching ""

    No results matching ""