I tried to resolve the problems by upgrading to mysql 4.0.14, putting the database that I needed absolute best performance on a fast scsi drive all by itself.
Then twice this week I needed to add a column to a large table (about a million records). The tables reside on the main system ide drive. For the first few minutes of the alter table everything was fine. I watched the file sizes of the temporary MYD and MYI files grow to about the size of the originals. Then a few minutes later tragedy, the whole machine all but locked up. commands typed on open shell sessions freeze and after typing in my username/password to start another linux session that session froze, never got a prompt. After several minutes of waiting I had to hit the reset button on the server. After it booted backup everything was fine, the table I was altering had the new column, the alter table actually finished! Like I said this happend twice!
This is a RedHat 8 machine, kernel 2.4.18-14, Athlon XP 1700+, 1 gig ram. mysql was installed from mysql-standard-4.0.14-pc-linux-i686.tar.gz.tar
I have successfully executed alter tables on smaller tables without problems. Also I accidently ran one of the alter tables on the slave database before running it on the master, it completed fine. It is Redhat9, kernel 2.4.20-8, P4 2.4, 1 gig ram. Mysql 4.0.12
What could possibly be causeing this? What to do to fix it? Is it a hardware problem? Kernel problem? I guess I should just put together a new machine and hope it doesn't happen to it. But thought I would post in case it helps anyone else.
Thanks! Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
