Recently, one of the folks from Astaro said that that was what a database maintenance run looks like, so I checked the System log:
2009:07:30-18:40:01 post /usr/sbin/cron[25683]: (root) CMD ( /usr/local/bin/reportcontrol.sh)
2009:07:30-18:40:01 post /usr/sbin/cron[25685]: (root) CMD (/usr/local/bin/adbs-maintenance.plx)
2009:07:30-18:40:01 post adbs-maintenance[25685]: starting ADBS maintenance run
2009:07:30-18:40:01 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'accounting_archive' column name: 'flow_start_day' threshold_day: '733438')
2009:07:30-18:40:05 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / accounting_archive
2009:07:30-18:40:05 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'pfilter_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:08 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / pfilter_archive
2009:07:30-18:40:08 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'auth' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:08 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / auth
2009:07:30-18:40:08 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'imp2p_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:08 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / imp2p_archive
2009:07:30-18:40:08 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'ips_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:08 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / ips_archive
2009:07:30-18:40:08 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'mailsec_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:11 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / mailsec_archive
2009:07:30-18:40:11 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'websec_au_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:11 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / websec_au_archive
2009:07:30-18:40:11 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'websec_aud_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:11 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / websec_aud_archive
2009:07:30-18:40:11 post adbs-maintenance[25685]: Operating on database: 'reporting' (table name: 'websec_bud_archive' column name: 'dayabs' threshold_day: '733438')
2009:07:30-18:40:11 post adbs-maintenance[25685]: finished ADBS maintenance on reporting / websec_bud_archive
2009:07:30-18:40:11 post adbs-maintenance[25685]: cleaning anonymizing mappings
2009:07:30-18:40:59 post adbs-maintenance[25685]: finished ADBS maintenace run
-1- I thought these were supposed to occur at 2AM, so why is my 7.404 Astaro running it at 6:40 and 18:40?
-2- Why didn't the 6:40 run cause everything swappable to be moved out to the swap file? And, why did the 18:40 run only begin to cause swapping on Tuesday (7/28) after weeks without so doing? This indicates to me that some space in the swap is not being released and/or swapped back in when the database maintenance is finished.
Cheers - Bob
This thread was automatically locked due to age.
