title: MySQL measure full table scan time
body: <p>I have a 5TB table. All I want to know is how much time it takes to do a full table scan. I don't care about the data getting returned. I tried to run <code>select * from mytable;</code> but for some reason the client got killed. Not sure if it is caused by some sort of timeout or too much data to handle. Is there a reliable way to get the time consumption of the query? Not sure if this is gonna help but my table schema looks like this: <code>create table datatable (a integer, name varchar(200), class varchar(200), reason varchar(200));</code> </p>