perfSONAR User Q&A and Other Discussion

[Raphael Dourado <>]

Thanks Andrew!

Best,

Raphael Augusto Dourado.

http://www.cin.ufpe.br/~rasd2/

On Fri, Sep 12, 2014 at 10:28 AM, Andrew Lake <> wrote:

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>