• Leigh Stoller's avatar
    Initial checkpoint of a script that will check the stats tables · 8ab3e170
    Leigh Stoller authored
    nightly, and make repairs for the common things I see happening.  The
    current version repairs most of the errors that have crept in since
    the Epoch, and then rebuilds the summary stats table (user_stats,
    group_stats, project_stats). My intent is to add a "daily_stats" table
    as well since scanning the testbed_stats and experiment_resources
    table to generate range data is getting pretty slow as more records
    enter the system. We can also use a daily_stats table to generate
    graphs on the fly as Jay requested a few weeks ago.
    
    Not done yet, hope to return to it later this week.
    8ab3e170
checkstats.in 15.9 KB