Disk utilization and storage increases after 10.3 upgrade

Document ID : KB000118616
Last Modified Date : 29/10/2018
Show Technical Document Details
Issue:
After upgrading to 10.3 it is noticed that disk space is being taken up quickly and utilization is higher.
 
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.
https://comm.support.ca.com/kb/how-to-start-and-stop-the-spectrum-in-linux/kb000076397

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.