perfSONAR User Q&A and Other Discussion

[Andrew Lake <>]

Hi,

You can clear out all but the last 30 days of OWAMP data with the command 
below:

sudo /opt/perfsonar_ps/perfsonarbuoy_ma/bin/clean_pSB_db.pl --dbtype=owamp 
--maxdays=30 \
--owmesh-dir=/opt/perfsonar_ps/perfsonarbuoy_ma/etc/ --no-save-dumps

Change --maxdays=30 to delete more or less data. OWAMP data is inherently 
large as its storing multiple rows each minute of each test. 3.3 toolkit's 
should be deleting data older than 30 days automatically so if you are 
running the toolkit make sure you have the latest version. 

Thanks,
Andy


On Sep 11, 2014, at 4:32 PM, Raphael Dourado 
<>
 wrote:

> Hi!
> 
> One of my pS-PT servers is crashing because the MySQL OWAMP tables are 
> occupying the whole disk. 
> 
> Please find attached a file with the contents of the /var/lib/mysql/owamp 
> directory, sorted by size. Note that some files are larger than 1GB.
> 
> Does anyone know what could be causing this problem?
> 
> Best,
> 
> Raphael Augusto Dourado.
> http://www.cin.ufpe.br/~rasd2/
> <owamp-tables.txt>