188 reputation
4
bio website
location New York, NY
age 27
visits member for 2 years, 11 months
seen Mar 27 '12 at 19:33

May
27
awarded  Self-Learner
May
23
awarded  Teacher
May
23
answered I am using the MEMORY storage engine but MySQL still writes to my disk…Why?
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.
May
23
awarded  Scholar
May
23
accepted I am using the MEMORY storage engine but MySQL still writes to my disk…Why?
May
22
awarded  Student
May
22
asked I am using the MEMORY storage engine but MySQL still writes to my disk…Why?