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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw