MySQL Lists: mysql: "copying to tmp table" performance

List:	General Discussion	« Previous Message Next Message »
From:	Ilya Obshadko	Date:	June 18 1999 1:28pm
Subject:	"copying to tmp table" performance
View as plain text

I found that most time-consuming operation on complicated queries is
"copying to tmp table". How can I increase its speed? tmp_table_size is 4M
now (was 1M originally), but it doesn't help.

#-- Ilya Obshadko [IDO-RIPN] -------------------------------#
#-- email: ilya@stripped, ilya24@stripped -----------------#
#-- ICQ UIN: 10704338 --------------------------------------#

Thread
• "copying to tmp table" performance	Ilya Obshadko	18 Jun
• "copying to tmp table" performance	Jani Tolonen	19 Jun