MySQL Forums
Forum List  »  Quality Assurance

places where MySQL store the temporary files
Posted by: venita melchior
Date: February 26, 2011 02:22AM

MySQL uses the value of TMPDIR environment variables to store temporary files as the path name. If you do not set TMPDIR, MySQL uses the system default values, it is usually "/ tmp" or "/ usr / tmp". If the temporary file directory that contains your file system is too small, you should edit safe_mysqld to set TMPDIR to point you have enough space for a file system! You can also use the mysqld the - tmpdir option to set temporary directory project.
MySQL to "hidden files" to create all the temporary files. This ensures that if mysqld is terminated, the temporary file will be deleted. Disadvantage of using hidden files is that you will not see a big temporary file to fill a temporary file directory where the file system.
When sorting (ORDER BY or GROUP BY) when, MySQL normally uses one or two temporary files. Maximum disk space requirements are:
(The length of storage stuff + sizeof (database pointer))
* Number of rows that match
* 2

sizeof (database pointer) is usually 4, but really big in the future may increase the table.
For some SELECT queries, MySQL also creates temporary SQL tables. Those who can not be implied and there is "SQL_ *" format name.
ALTER TABLE, and OPTIMIZE TABLE in the original database table in the same directory create a temporary table.

dsound.dll / fix rundll @ http://www.fixpcdll.com/



Edited 1 time(s). Last edit at 02/26/2011 02:22AM by venita melchior.

Options: ReplyQuote


Subject
Views
Written By
Posted
places where MySQL store the temporary files
3576
February 26, 2011 02:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.