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. Pawel24 February 2012 at 13:02

    Do you have any benchmarks?

    ReplyDelete
  2. Jonathan Levin24 February 2012 at 13:16

    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
  3. Céd24 February 2012 at 14:08

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

    ReplyDelete
  4. Jonathan Levin8 March 2012 at 13:52

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

    ReplyDelete