Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I used mysql as part of a project and found it to be a very practical tool.

I have a question about mysql in regards to how it creates temporary table types TMD in /var/lib/mysql/. This partition takes as much memory as the original table!

I do not know what mechanism creates a table automatically, but I'd like this feature to be disabled, or at least configure mysql to put the temporary tables in /tmp, not /var/lib/mysql.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.