Engine cannot be altered to S3 from MyISAM for a 110Gb table.

> CREATE TABLE BigTable (id int, b int, PRIMARY KEY (id)) engine=MyISAM

> insert into BigTable select seq,-seq from seq_1_to_99

> insert into BigTable select seq,-seq from seq_100_to_2000000000

Query OK, 1999999901 rows affected (1 hour 28 min 2.370 sec)

Records: 1999999901  Duplicates: 0  Warnings: 0

> select count(*) from BigTable;

| count(*)   |

+------------+

| 2000000000 |

ALTER TABLE BigTable engine=s3;

Stage: 1 of 2 'Copy to tmp table'   98.7% of stage done

Stage: 2 of 2 'Repair by sorting'    100% of stage done

> use test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A