Morning Jorg, Thanks for the reply.
> The "limit" clause restricts the data returned, but not the data examined.
> You ask the server to examine a certain set of rows ("where ..."),
> sort it ("order by ..."),
> and then to return a limited number of these rows ("limit ...").
>
> As the data only
Hi Heston, all!
Heston James - Cold Beans wrote:
> [[...]]
>
> One thing which is puzzling me at the moment is why its producing such large
> record sets from my query. Even when limiting the query to 700 records it
> still exceeds this 8Mb limit.
>
> The query is quite basic and is only return
al Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: 21 October 2008 16:49
To: Heston James - Cold Beans
Cc: mysql@lists.mysql.com
Subject: Re: Error Code 28
On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans <
[EMAIL PROTECTED]> wrote:
> Afternoon all,
>
>
&
;
> Would you really expect a record set from this query to be so large? Is
> there any way to make it smaller and more efficient?
>
> Cheers Rob,
>
> Heston
>
> -Original Message-
> From: Rob Wultsch [mailto:[EMAIL PROTECTED]
> Sent: 21 October 2008 16:49
>
o:[EMAIL PROTECTED]
Sent: 21 October 2008 16:49
To: Heston James - Cold Beans
Cc: mysql@lists.mysql.com
Subject: Re: Error Code 28
On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans <
[EMAIL PROTECTED]> wrote:
> Afternoon all,
>
>
>
> I have a SELECT query which is
On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans <
[EMAIL PROTECTED]> wrote:
> Afternoon all,
>
>
>
> I have a SELECT query which is returning the following error:
>
>
>
> (InternalError) (3, "Error writing file '/tmp/MYqlGnfn' (Errcode: 28)")
>
>
>
> After doing a little searching on go
-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 9:46 AM
> To: Ed Kraft
> Subject: Re: Error Code 28?
>
>
> Hi Ed,
>
> hmm, what does "perror 28" say ?
>
> If I guess right than it shoud say " no space left on device
nal Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 9:46 AM
> To: Ed Kraft
> Subject: Re: Error Code 28?
>
>
> Hi Ed,
>
> hmm, what does "perror 28" say ?
>
> If I guess right than it shoud say " no space l
> What will happen on Error code 28: No space left on device? Will
mysql
> crash down?... Will there be posibility of reading data from tables?
I saw this error on one of my servers not too long ago. MySQL keeps
running but seemingly refuses to do SELECTs on any tables. Upon freeing
some spac
Kittiphum,
Monday, May 13, 2002, 8:52:38 AM, you wrote:
KW> Thanks after got your mail that
>>perror 28
>>Error code 28: No space left on device
KW> I try to check my disk spack it have 2 GB space left so it may not cause by this
problem .And I found that with MySQL 4.0.1 it error but not e
Hi, Georg Richter,
Thanks after got your mail that
>perror 28
>Error code 28: No space left on device
I try to check my disk spack it have 2 GB space left so it may not cause by this
problem .And I found that with MySQL 4.0.1 it error but not error in 3.23.49a
thank again.
Kittiphum Wora
Hi Rahul Torvi, and MySQL user group
>you can use perror 28 to see what does that error code mean
>
>Rahul T
>
>-Original Message-
>From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
>Sent: Monday, May 13, 2002 10:50 AM
>To: [EMAIL PROTECTED]
>Subject: Error code 28
>
>
>Hello, mysql,
>
On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote:
Hi,
>
> In select field list if they have some field that field type is text or
> blob and if I use group by some filed MySQL will generate "Got error 28
> from table handler" the query like this
>
> select a.f1,a.f2,a.f3,b.f1,b.f2
> from
you can use perror 28 to see what does that error code mean
Rahul T
-Original Message-
From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: Error code 28
Hello, mysql,
In select field list if they have some field that f
14 matches
Mail list logo
