Hi Dan, Just a guess though, but you are sure you have PLENTY of harddisk space laying around ?
If not that would perfectly explain the behaviour. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 08:19、Dan Edwards さんは書きました: > Hi about 2 months ago I had trouble with alter table on large tables > blocking all database activity and started a thread on this list called > "alter table blocks other tables!" > > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]