Performance Issue for select query

[amar singh chawan]

DearAll,

Currently I am working on mysql 5.6.19 version and I have observed most of the time for single query also taking more time to get the records.

We have around 30 tables in database and it's in amazon RDS. each table max of 50k to 1 lack records and my instance have db.r3Xlarge class and 500 GB storage with IOPS 2000.

But When I just select a table like select * from TBL it's taking around 2-3 min and I have cross checked the variables like query cache,buffer etc but no use.

Please share your knowledge.

Greatly appriate.

Thanks,
Amar