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.
---------------------------------------------------------------------
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
