22 Feb 2012

Tmpfs with IO_Direct

bad idea..

tmpdir..
..on tmpfs

upgrade..
..to 5.5

default engine..
..innodb

create..
..temp tables statements

optimizing my.cnf...
..io_direct sounds good..

tmpfs..
..and io_direct
do not..
..play well together

..lucky...
..just slave..
..had backup

4 comments:

  1. I think you are referring to error log output.

    If you are looking for benchmarks, there has been many many on planet mysql recently.

    ReplyDelete
  2. Do you have this problem with libaio installed and asynchronous I/O ?

    ReplyDelete
  3. Yes, I believe the problem was using the native AIO with tmpfs.

    ReplyDelete