Hello.
>Apart from this
> brightmail.din_top_spam
> warning : 1 clients is using or hasn't closed the table properly
> status :
After what command have you got the warning? CHECK TABLE shouldn't
produce it:
http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html
"If mysqld is running, you must force it to flush any table
modifications that are still buffered in memory by using FLUSH TABLES.
You should then ensure that no one is using the tables while you are
running myisamchk. The easiest way to avoid this problem is to use
CHECK TABLE instead of myisamchk to check tables."
Seena Blace <sqlserverdb@stripped> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 27 lines --]
>
> Hi,
>
> Here is what I see.
> mysql> check table report_1;
>
> +---------------------------+-------+----------+------------------------------------+
> | Table | Op | Msg_type | Msg_text
> |
>
> +---------------------------+-------+----------+------------------------------------+
> | mailtest.report_1 | check | error | record delete-link-chain corrupted |
> | mailtest.report_1 | check | error | Corrupt |
>
> +---------------------------+-------+----------+------------------------------------+
> 2 rows in set (0.02 sec)
>
> Does repair table report_1 command fix?
> or anything we need to do extra?
>
> Apart from this
> brightmail.din_top_spam
> warning : 1 clients is using or hasn't closed the table properly
> status : OK
> How to close such kind of table?
> thanks
>
>
>
> ---------------------------------
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
