MySQL tmpdir on ramdisk without data loss?

Hello,

is it possible to store mysql tmpdir in RAM without worries of data loss/inconsistency?

Here is tutorial on how to do it: http://www.systemadminihater.com/linux/the-best-wordpress-performance-tip-ever/

But it do not mentions how to prevent any issues caused by cases server crash leaving some mysql data in memory (which gets wipped on crash/power interuption)?

Any ideas if i need to worry and if so, what solution to apply while having tmpdir in /dev/shm ?

thank you

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.