Disk utilization and storage increases after Spectrum 10.3 upgrade

Products

• Spectrum

Issue/Introduction

After upgrading to Spectrum 10.3 it is noticed that disk space is being taken up quickly and utilization is higher.

Environment

Release: All Supported Releases
Component: SPCCSS - SpectroSERVER Core

Cause

This is due to the ibtmp1 file size increasing in size quickly.

Resolution

With 10.3.1 this will be included out of the box, however on 10.3 the follow steps are required to restrict the size of the ibtmp1 file.

1. Shutdown the MySQL Service.

Reference knowledge article 76397 "How to start and stop the Spectrum SS process on Linux from command line"

2. Navigate into $SPECROOT/mysql/ directory.
3. Open my-spectrum.cnf file in a text editor.
4. Scroll to the bottom of the file and add this line:

innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:10G

5. Save the file.
6. Restart MySQL Service (See above KB link)

This will now effectively reduce the overall size and impact of the ibtmp1 file to 10GB.