Monitoring Queries

Killing Long-Running Queries

The script web/perl/query/monitor_bioq.pl will kill BioQ queries that have run beyond a certain duration.  When this happens the user will received a "timeout" message in their web browser. 

Setup

In the Subversion directory web/perl/query (such as https://svn.saclab.net/bioq/trunk/main/web/perl/query/)

  • Copy template_monitor_bioq.sh to monitor_bioq.sh and edit as necessary
    • Set the server_name variable to target only certain servers, such as when testing the kill script
  • Option 1
    • Set continuous=1 and run this script in the background
  • Option 2
    • Set continuous=0 and run the script as a linux cron job every few minutes