On Tue, 9 Apr 2002 13:17:59 +0800
Alvin Chen <[EMAIL PROTECTED]> wrote:
> hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
> linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
>PIII 800.
> But for some reason queries take too many time.
>
> During the long query, I did a "mysqladmin proc" to see what was going on.
> Under the column "State" I saw the value "copying to tmp table" which
> lasted a good 6 seconds. So I'm thinking that the copying to tmp table is
> slowing down the query - but I don't know why.
please compare after you do this query :
"set SQL_BIG_TABLES = 0"
or
"set SQL_BIG_TABLES = 1"
also try this ...
"set SQL_BUFFER_RESULT = 1"
--
Let's call it an accidental feature.
-- Larry Wall
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
