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 t
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.mysq
Use fulltext indexes (http://www.mysql.com/doc/F/u/Fulltext_Search.html).
Queries with LIKE '%...%' will always be slow because they can't use
indexes, and you're doing SIX of them, of course it'll take a while. Only
drawback of fulltext indexes is (AFAIK) you can't match against fields in
separat
Hi to all of you!
The following query takes more than half an our to execute. I don't think
that is normal. Most time takes "copying to tmp table".
SELECT DISTINCT
Formular.titel AS formularTitel,
Formular.id AS formularId,
Anbieter.id AS anbieterId,
Anbieter.anbieterName AS anbieterName
FROM
Fo
I was under the impression that things end up in a tmp table if the query requires
sorting which is when you have either ORDER BY or GROUP BY or DISTINCT
Is that true of false?
regards,
thalis
On Tue, 24 Apr 2001, Seung-woo Nam wrote:
> I don't think you can avoid having those temporary table
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
ut 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
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
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 takes up
to 5 minute
