Re: count number of reads/writes on table for optimisation purposes

[Rick James]

Not for a specific table.
SHOW GLOBAL STATUS LIKE 'Com%';
gives you a variety of statement counts. Do the SHOW before and after running some code, then take the diffs.

The slowlog gives you hints of what is taking the longest.

But none of this will necessarily have any bearing on which Engine. Would you like to show us the SHOW CREATE TABLE and some queries, especially SELECTs. With that, we might point out some relevant advantages/disadvantages of the Engines.