rocesslist;) to the DataBase.
Good luck,
Gelu
- Original Message -
From: Peter Romianowski <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 2:08 PM
Subject: check, analyze and optimize table
> Hi,
>
> I am writing a maintenance-deamon w
> Yes you are right
> We lock tables to run this but only when we have problems.
> One more thing I would do is run 'show processlist' and mail it to my self
> to see how thing are going.
> Simon
> PS have you tried mytop?
No, I did not try mytop, but I'll give it a try now :)
Another quest
fault options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
-Original Message-
From: Peter Romianowski [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2002 12:08
To: [EMAIL PROT
Hi,
I am writing a maintenance-deamon which is executing
CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at
night.
If CHECK TABLE fails for at least one table, then the
rest will be skipped.
The question is if the order of the statements is ok
this way. A second question would be, if I should
