Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

 
discard

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

Browse other questions tagged or ask your own question.