The following contains steps that customers can enact to help performance issues like excess memory or CPU or crashes.
These changes should be made at a time when there are no active CPM jobs, DR copy or S3 copy jobs are running.
1. Please stop and
start the CPM instance when no backups or DR/S3 copy jobs are active. This is done because the virtual hardware is refreshed and can help correct virtual hardware issues.
Note: A reboot of the CPM instance does not refresh the virtual hardware as does the stop and start.
2. There are some MySQL configuration changes that can change the way logging takes place and increasing the write buffer,
- A.Connect to the
CPM instance using ssh and the login cpmuser and the instances private key.
- B. sudo su -
- C. Please edit the file /etc/mysql/mysql.cnf using a text editor like nano or vim and add the following lines below any text in the file and then save the file.
Add at the end of
the file:
[mysqld]
innodb_read_io_threads=4
innodb_write_io_threads=8
#To stress the double write buffer
innodb_log_file_size
= 32M #Small log files, more page flush
innodb_log_files_in_group=2
innodb_file_per_table=1
innodb_log_buffer_size=8M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
max_allowed_packet=128M
- D. For these changes to take effect you must recycle the MySQL process, so please run the command.
- sudo systemctl
restart mysql
- E. Then verify that the
service is active by typing:
- sudo systemctl
status mysql
3. If you are facing memory issues you can create a swap file on the CPM instance. Swap is a space on a disk that is used when the amount of physical RAM memory is full. (This is like a paging file on the Windows platform,). When running CPM on an Ubuntu AWS instance a swap partition is not configured by default, and the only option is to create a swap file.
4. Performance issues can be caused by the cpmdata policy getting corrupted. The following steps show how you can "recreate" the cpmdata policy. When doing this please make sure that the application-consistent backup option is disabled.