When i alter a table, for instance, change a field from char to varchar, any user doing a select operation on that table has to wait for the alter table operation to succeed. Some tables contain 100s of millions of records and the alter table operation can take an hour or more.

How can i permit select operations to succeed by reading the old table while MySQL is creating the new version ?