How Stable Is MySQl

["Mr.Y.SHIVAKANT" <karnatic@xxxxxxx>]

-----Original Message-----
From: jodie <jodie@xxxxxxxxxxxxx>
To: mysql@xxxxxxxxxxxxxxx <mysql@xxxxxxxxxxxxxxx>
Date: Friday, January 05, 2001 10:57 AM
Subject: help - table keeps getting corrupted


>I have a table which keeps getting corrupted, and it is the only one which
>is affected  (and we have quite a few - all which are accessed and updated
>regularly). I am using stock 3.23.29a-gamma (tarball) on a rh 6.2 linux
>system and myisam tables.
>
>The table in question is used for our mail system (Qmail patched to
>authenticate/deliver through mysql), and is becoming corrupted quite often
>now.  Can anyone provide me with any hints on determining where/when the
>corruption is occuring, or if there are any known similar side affects.
>
>Here is the table:
>
>CREATE TABLE virtual (
> id int unsigned auto_increment primary key,
> user_id int unsigned default 0 not null,
> username varchar(64) default '' not null,
> ext varchar(128) default '' not null,
> virtual_username varchar(32) default '' not null,
> cost int unsigned default 0,
> pri tinyint unsigned default 0,
> flag int unsigned default 0,
> KEY virtual_username (virtual_username)
>);
>
>Regards,
>
>Jodie
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php"; before
>posting. To request this thread, e-mail mysql-thread60729@xxxxxxxxxxxxxxx
>
>To unsubscribe, send a message to:
>    <mysql-unsubscribe-karnatic=eth.net@xxxxxxxxxxxxxxx>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
>    http://lists.mysql.com/php/unsubscribe.php
>it is heard to have 555000 record 55mb that's not good enough i am talking
of storing tera bytes of information  onit.
YOURS SINCERELY
Shivakanth


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60853@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php