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:19Dan Edwards :
Hi about 2 months ago I had trouble with alter table on large tables
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
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