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

Could I put it in a different way? 1- What kind of cron jobs related to SQL server should run, and when? 2- What scripts should run cron jobs related to check/repair problems with MySQL tables? 3- Is there any scripts should run cron jobs on Zebra? YAZ? 4- If the word index confused the issues, I meant "indexes related to records database) Not to server database. Is there cron jobs for compacting keyword index? check for broken seach index.? etc., ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Said Shafik Library Systems Manager Drexel University Libraries Philadelphia, PA 19104-2875 Phone: 215.895.1832 Fax: 215.895.2070 http://library.drexel.edu Facebook: http://apps.facebook.com/drexellibraries/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Date: Thu, 30 Oct 2008 10:54:40 -0600> From: Gary.Harris@state.nm.us> To: koha@lists.katipo.co.nz> Subject: Re: [Koha] Cron Jobs> > 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. > > > > _______________________________________________> Koha mailing list> Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha

When your life is on the go—take your life with you. http://clk.atdmt.com/MRT/go/115298558/direct/01/