Hi Dan, O.K just making sure ;-)
How big is the table ? Does it contain any indexes ? Could you remove the indexes, alter the table and than add the indexes again ? I read over and over that the Kernel 2.4.18 has lots of BUGS, but I am not sure if this applies to your case. If you look in the archive you should find a message from heikki Thuri stating something like this. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 13:42、Dan さんは書きました: > Ya plenty of freespace, 27 gigs, that one has got me before though. > Thanks! > Dan > > Nils Valentin wrote: > > 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]
