Reputation
208
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 7
Newest
 Yearling
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
May
23
comment I am using the MEMORY storage engine but MySQL still writes to my disk…Why?
Thanks for your tips! The "file handle to the .frm" is exactly what the problem was. The write I/O was a result of repeated "DROP TABLE/CREATE TABLE" statements. I replaced those with "TRUNCATE TABLE" and the problem is gone.