Rodolfo Sikora writes:
> This table is getting corrupted all the time (twice a week).
>
> We have only SELECTS and INSERTS with little updates. (we have 140.000 registers
>growing faster to 1000000 :))
>
> CREATE TABLE conta (
> idConta int(8) unsigned NOT NULL auto_increment,
> idDominio int(6) unsigned DEFAULT '0' NOT NULL,
> conta varchar(30) DEFAULT '' NOT NULL,
> senha varchar(32) DEFAULT '' NOT NULL,
> usermount varchar(100) DEFAULT '' NOT NULL,
> userlock int(1) DEFAULT '0' NOT NULL,
> senha2 varchar(255) DEFAULT '' NOT NULL,
> PRIMARY KEY (idConta),
> UNIQUE idDominio (idDominio,conta)
> );
>
> The worst is tha we have another table with 1.000.000
>inserts/updates/deletes/selects and this table never get corrupted.
>
> What should I do to prevent corruptions. (every day I run an optimize, check
>table... etc..)
>
> I'm running mysql under a NetServer LC2000 (HP) with RAID 5 and 1GB RAM, PIII
>667/600.
>
> Shoudl I use -O key_buffer and/or table_cache.
>
> What really does FLUSH TABLES? it's ok do it once a day?
>
>
> By the way I got this interesting message in my slave log:
>
> 010207 12:47:42 Error reading packet from server: Contratulations! You have hit the
>magic number and can win sweepstakes if you report the bug (0)
>
> Best regards.
>
>
HI!
The above error message looks like you have hit a very hard error in
network protocol.
It could be a cause for table corruption, although we would prefer to
see a full repeatable test case .
But for the start, you could check that you have no errors in your LAN
network functioning.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php