Hello S! > I am sending this mail in order to get things straight > about table corruption which I am experiencing with > 4.0(as well as previous versions). > > 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, > AHA29160N SCSI controller
OK, so this is a possibly a 'fairly' new box, meaning it hasn't been in service for years with no other problems? > 4) Corruption is a tossup. The import always works. > However, when I run the queries sometimes they all run > fine, while other times I get an error 127 > on the table it is working on. > myisamchk NEVER manages a complete recovery of all > records(typically 25% of the records). This makes it > 5)Before writing a bug report(the problem may be that > this is erratic and even on my PC corruption is not > consistent, e.g. I may import a file and get > corruption, or I may import another file without > corruption) and hence reproducibility may be > problematic., I would appreciiate someone setting me > then ulimit -a limit says 8192 > but when I open a window as a regular user, and do > ulimit -a limit it is still 1024. Rebooting (By 'window' do you mean an X-window? If yes, try shutting off xfs and doing things in a plain text terminal. Not a fix, just a bandaid, but it lightens the system load.) In any case my real suggestion is that I was having wacky unrepeatable system errors that that your descriptions remind me of, and memtest86 http://www.teresaudio.com/memtest86/ found bad RAM that -*NO*- other memory tester could confirm. Changed one DIMM and it purrs like a kitten. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] --------------------------------------------------------------------- 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
