更改mysql的tmp文件夹 [英] Changing the tmp folder of mysql

问题描述

我们的Mysql查询使用临时表，该临时表在该过程中创建临时文件.当前，文件已写入/tmp. mysql写入的temp文件夹的路径到底该如何更改?

Our Mysql queries use temporary tables which creates temporary files in the process. Currently the files are written to /tmp. How exactly can the path of the temp folder to which mysql writes to be changed?

推荐答案

您应编辑my.cnf

You should edit your my.cnf

tmpdir = /whatewer/you/want

然后重启mysql

P.S.不要忘记为mysql用户授予/whatewer/you/want的写权限

P.S. Don't forget give write permissions to /whatewer/you/want for mysql user

这篇关于更改mysql的tmp文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！