Disk space on SpectroSERVER filling up fast

Products

• Spectrum
• Network Observability

Issue/Introduction

Disk space on the SpectroSERVER filling up fast.

When checking the Spectrum directory, we found the following:

-rw-r----- 1 user group 23G Aug  6 04:31 ./opt2/user/mysql/data/#innodb_temp/temp_15.ibt
-rw-r----- 1 user group 23G Aug  6 00:11 ./opt2/user/mysql/data/#innodb_temp/temp_3.ibt
-rw-r----- 1 user group 23G Aug  6 02:27 ./opt2/user/mysql/data/#innodb_temp/temp_8.ibt
-rw-r----- 1 user group 23G Aug  6 02:14 ./opt2/user/mysql/data/#innodb_temp/temp_5.ibt
-rw-r----- 1 user group 23G Aug  6 05:25 ./opt2/user/mysql/data/#innodb_temp/temp_20.ibt
-rw-r----- 1 user group 23G Aug  6 03:04 ./opt2/user/mysql/data/#innodb_temp/temp_14.ibt
-rw-r----- 1 user group 23G Aug  6 00:50 ./opt2/user/mysql/data/#innodb_temp/temp_9.ibt

Running top showed mysql taking up 100% CPU.

Environment

Release : Any:
Component: mysql

Resolution

Restart mysql to shutdown any queries and clear temp space.

To stop mysql:

- Log into the system as the user that owns the Spectrum install

- cd to the $SPECROOT/bin directory

- Find the process id of mysql

- Enter the following command where <PID> is the mysql process id:

./cmdC localhost 2 <PID>

- Verify mysql has stopped

- Verify the space is freed in the $SPECROOT/mysql/data/#innodb_temp directory

To start mysql:

- Log into the system as the user that owns the Spectrum install

- cd to the $SPECROOT/bin directory

- Enter the following command:

./launchinstdbapp localhost MYSQL y MYSQL.OUT

- Verify mysql is running

- Check the space in the $SPECROOT/mysql/data/#innodb_temp directory