From: Dan Nelson
Date: February 7 2008 8:04pm
Subject: Re: very strange slow plain select
List-Archive: http://lists.mysql.com/mysql/211252
Message-Id: <20080207200403.GA85696@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

In the last episode (Feb 07), dvd@stripped said:
> I just stumbled on this hard to explain problem. Below
> 
> select * from BigTable      (BigTable has 5 million rows)
> 
> takes forever to even print out the first row. as you could see from
> the sql, it is supposed to print out some rows right away regardless
> of server config in my.cnf.   What is interesting is the following
> sql
> 
> select * from BigTable limit 1000 
> 
> return the rows immediately as expected.

You want the --quick option.  From the mysql manpage:

       o  --quick, -q

          Do not cache each query result, print each row as it is
          received.  This may slow down the server if the output is
          suspended. With this option, mysql does not use the history
          file.

-- 
	Dan Nelson
	dnelson@stripped