I'm experiencing data corruption with the latest version of MySQL: ares% mysql -V mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
Compiled with: ares% gcc --version 2.95.4 I'm running MySQL as: /usr/local/libexec/mysqld --datadir=/home/mysql -O key_buffer_size=160M -O record_buffer=8M --log-slow-queries -O max_connections=500 -O wait_timeout=3600 --memlock After a single run of mysqld, with a normal shutdown (using mysqladmin shutdown), myisamchk returns table errors on a table that was clean before server startup: ares# myisamchk -r hosts - recovering (with sort) MyISAM-table 'hosts.MYI' Data records: 723198 - Fixing index 1 Found wrong stored record at 357315468 Found block with too small length at 357317132; Skipped Found link that points at 949761822580875360 (outside data file) at 357317428 Found link that points at 4402937561443737713 (outside data file) at 357318064 myisamchk: warning: Duplicate key for record at 33045928 against record at 10929792 myisamchk: warning: Duplicate key for record at 395117248 against record at 313463120 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 Data records: 723195 myisamchk: warning: 2 records have been removed Sometimes this corruption causes mysqld to lose track of the fields in the 'hosts' table, returning messages about it being a fieldless table. Anyone have any ideas what I can do to fix this? -- ORBZ --------------------------------------------------------------------- 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
