Hi,
A replication slave needs some of its temporary files to survive a machine
restart so that it can replicate temporary tables or LOAD DATA INFILE
operations. If files in the temporary file directory are lost when the
server restarts, replication fails. MySQL creates temporary files as hidden
files.
"tmp_table_size" variable will determine the size of the temporary table.
But if it exceeds, then server automatically converts it to disk-based
tables.
The server variables,
Created_tmp_tables -The number of in-memory temporary tables created
automatically by the server while executing statements.
Created_tmp_disk_tables -The number of temporary tables on disk created
automatically by the server while executing statements.
Created_tmp_files - How many temporary files mysqld has created.
were used to determine the temporary files status.
Thanks
ViSolve DB Team
---- Original Message -----
From: "Kevin Fries" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, December 14, 2006 12:57 AM
Subject: definition of Created_tmp_files in "show status"
According to the mysql reference manual, the definition of this field is:
"How many temporary files mysqld has created. "
Can someone elaborate on this? What causes mysql to create a temporary
file? I see something indicating it may be associated with replication. In
our environment (which has replication) we see counts for this variable in
the tens of thousands.
Thanks in advance,
Kevin
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]