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:
Do you have any benchmarks?
I think you are referring to error log output.
If you are looking for benchmarks, there has been many many on planet mysql recently.
Do you have this problem with libaio installed and asynchronous I/O ?
Yes, I believe the problem was using the native AIO with tmpfs.
Post a Comment