I'm getting a "Temporary Write Failure" error message and I'm confident that I need to change the size of my temporary directory.
Here is my my.cnf file:
# Disabling symbolic-links is recommended to prevent assorted security risks
I'm going by the insight published on this page: http://www.lophost.com/tutorials/how-to-change-or-move-mysql-tmp-directory/
and I want to be sure I do this right the first time.
First off, I don't see the tmp directory listed, so I want to make sure I'm in the right place.
Secondly, I don't see the current status of the current temporary directory. I would like to test those waters and see what kind of space I'm looking at before I make any adjustments just so I can make intelligent comparisons.
I know I've got 3TB worth of space on my server, so I've got room. But how do I dictate the size of my tmp directory? How can I determine where it is currently?