Hmmm. This sentence seems to contradict the idea of an integrated system: "While there are undoubtedly best practices somebody could write up or point to for monitoring the health of the MySQL DB used by a Koha installation, that seems to me to be part of general MySQL administration, not something that Koha itself needs cronjobs for." There are many things in Koha that could be picked apart and deemed separate administrative functions. I do agree that the OS is a separate beast, but the underlying DB is crucial to the functionality of the apps that run on top of it (yes, so is the OS). It's all about the data. I am not a coder or a database expert, this is only my $.02 worth as a years long user of integrated library system software, and I think Koha is good software. Gary L. Harris New Mexico State Library -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Galen Charlton Sent: Thursday, October 30, 2008 7:48 AM To: said shafik Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Cron Jobs Hi, On Thu, Oct 30, 2008 at 9:35 AM, said shafik <saidshafik@hotmail.com> wrote:
Yes, should there scripts for:
DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked. DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
I'm confused - DBCC is part of SQL Server, not MySQL. While there are undoubtedly best practices somebody could write up or point to for monitoring the health of the MySQL DB used by a Koha installation, that seems to me to be part of general MySQL administration, not something that Koha itself needs cronjobs for. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ______________________________________________________________________ This inbound email has been scanned by the MessageLabs Email Security System. ______________________________________________________________________ Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.