I want to test two different disks, one of them is HDD and another is SSD.
I use exactly the same information and app for both servers. They are exactly the same, just one of them is SSD and another is HARD.
When I run a simple script that inserts 1,000,000 rows into the database they take a similar time to run. Sometimes HARD is faster!
I want to know does MySQL's MyISAM use any caching, so I can get the same time to insert or I have same disk?
If they use cache before insert how can I disable that to test disk speed?