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.