I have just tried the same on a SLES 11.1p1 system running 5.1.54-community-log with the same 3.2TB dataset, runs just fine.
mysql> use test Database changed mysql> create temporary table t1 (id int); Query OK, 0 rows affected (0.06 sec)
mysql> alter table t1 engine=myisam; Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0
I have just tried the same on a SLES 11.1p1 system running 5.1.54- community- log with the same 3.2TB dataset, runs just fine.
mysql> use test
Database changed
mysql> create temporary table t1 (id int);
Query OK, 0 rows affected (0.06 sec)
mysql> alter table t1 engine=myisam;
Query OK, 0 rows affected (0.10 sec)
Records: 0 Duplicates: 0 Warnings: 0