If I'm getting copying to temp table often on some big queries, I
usually increase tmp_table_size, but for innodb, is that variable used
or is it innodb_buffer_pool_size?
-
Before posting, please check:
http://www.mysql.com
On Tue, Jan 07, 2003 at 10:41:07AM -0500, Adam Nelson wrote:
If I'm getting copying to temp table often on some big queries, I
usually increase tmp_table_size, but for innodb, is that variable
used or is it innodb_buffer_pool_size?
I'm 63% sure it's still tmp_table_size.
--
Jeremy D. Zawodny
Scott wrote:
I am running into a problem here with a general query that is essential
to the vitality of a website that I run. The problem is that every time
this query is executed, it is being copied to a temporary table on the
hard disk, causing an extreme slowdown. In some instances it
the ORDER BY clause.
Scott
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Gerald Clark
Sent: Tuesday, April 24, 2001 10:33 PM
To: Scott
Cc: [EMAIL PROTECTED]
Subject: Re: Query Copying to Temp Table
Scott wrote:
I am running into a problem here
I don't think you can avoid having those temporary tables in executing
any kind of SELECT queries since the retrieved information should be
stored somewhere (whether you have ORDER BY or not). I would suggest
that if you have a large database, you should considering putting the
temporary space on