A Ademi New Pleskian Mar 23, 2015 #1 Hello, i want to move mysql tmpdir to /ramdisk but when i am setting it, mysql errors: tmpdir is read only variable. How can i fix it?
Hello, i want to move mysql tmpdir to /ramdisk but when i am setting it, mysql errors: tmpdir is read only variable. How can i fix it?
IgorG Plesk addicted! Plesk Certified Professional Mar 23, 2015 #2 Not sure how it is related to Plesk but make sure that /ramdisk is mounted as not read-only. Have you tried setup it with mysql> set global tmpdir = '/ramdisk'; Any output?
Not sure how it is related to Plesk but make sure that /ramdisk is mounted as not read-only. Have you tried setup it with mysql> set global tmpdir = '/ramdisk'; Any output?
A Ademi New Pleskian Mar 23, 2015 #3 yes, i've tried it. set global tmpdir = '/ramdisk'; ERROR 1238 (HY000): Variable 'tmpdir' is a read only variable Click to expand... /ramdisk is not read only. it have 777 permission.
yes, i've tried it. set global tmpdir = '/ramdisk'; ERROR 1238 (HY000): Variable 'tmpdir' is a read only variable Click to expand... /ramdisk is not read only. it have 777 permission.
IgorG Plesk addicted! Plesk Certified Professional Mar 23, 2015 #4 Maybe related to this MySQL bug? http://bugs.mysql.com/bug.php?id=53119
Facebook
Twitter
