Re: definition of Created_tmp_files in show status

2006-12-14 Thread Kevin Fries
@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 INFILE operations. If files

Re: definition of Created_tmp_files in show status

2006-12-14 Thread Visolve DB Team
Thanks ViSolve DB Team. - Original Message - From: Kevin Fries [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, December 14, 2006 9:20 PM Subject: Re: definition of Created_tmp_files in show status Thanks for that. Is the only reason

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

Re: definition of Created_tmp_files in show status

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