[Koha] Cron Jobs

[Harris, Gary, DCA]

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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Galen Charlton
Sent: Thursday, October 30, 2008 7:48 AM
To: said shafik
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Cron Jobs

Hi,

On Thu, Oct 30, 2008 at 9:35 AM, said shafik <saidshafik at 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 at liblime.com
p: 1-888-564-2457 x709
skype: gmcharlt
_______________________________________________
Koha mailing list
Koha at 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.