mysql/data showing critical

[gauravrana]

Dear Team,

one of our cisco vsom server showing error message "filesystem /mysql/data is critical" and if i check the usage of /mysql/data it shows 92% occupied. Can anyone help in this regards.

[Scott Olsen]

Something is clearly chewing up a large chunk of disk capacity in this filesystem.  If you can get to the CLI, you should be able to manually hunt down what's occupying it.  

There may be a more elegant way, but I usually run something like;

du -BM --max-depth=1

within a starting directory to find out in which subdirectory is the majority of the data.  If a process has somehow begun failing, there is usually a largely disproportionate amount of space being chewed up in an isolated location, and this can at least give you an idea as to what else may be happening.

[gauravrana]

I have checked by the given command and below is the output. Can you please  let me know which files I can delete to free the space?

[root@cctvbud data]# du -BM --max-depth=1
39764M  ./vsms
1239M   ./cdaf
1M      ./lost+found
2863M   ./vsom
43865M  .
[root@cctvbud data]#

[Scott Olsen]

You'll need to dig and research further.  I'd take a look in the /vsms folder, which seems excessively large.

If the data and log files for VSMS are responsible for taking that much space, you'll need to engage Cisco TAC as I can't really speculate on why a VSMS database would end up such a size.  Perhaps there are event history retention settings which could be tightened to deflate it some (if there's nothing technically wrong with its operation)... but I'm not 100%.

[gauravrana]

Also I have observed that /MySQL/data /vsms/UMS consumed 39 GB of data size. Can you please tell how I can prune that?