Re: definition of Created_tmp_files in "show status"

2006-12-14 Thread Visolve DB Team
table_size Thanks ViSolve DB Team. - Original Message - From: "Kevin Fries" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: Sent: Thursday, December 14, 2006 9:20 PM Subject: Re: definition of Created_tmp_files in "show status"

Re: definition of Created_tmp_files in "show status"

2006-12-14 Thread Kevin Fries
PROTECTED]>; mysql@lists.mysql.com Sent: Wednesday, December 13, 2006 9:26:52 PM Subject: Re: definition of Created_tmp_files in "show status" 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

Re: definition of Created_tmp_files in "show status"

2006-12-13 Thread Visolve DB Team
ve DB Team Original Message - From: "Kevin Fries" <[EMAIL PROTECTED]> To: 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 t

definition of Created_tmp_files in "show status"

2006-12-13 Thread Kevin Fries
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