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
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 google all signs seem to point to a lack
of disk space to be able to store the query results.
Howeve
-
> 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 freein
Hi,
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?
Best Regards,
--
Jarek
-
Before posting, please check:
http
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.
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.
Kit
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: Erro
1,a.f2,a.f3,b.f1,b.f2
> from table_a as a,table_b as b
> where a.f1=b.f1
> and a.f1='xxx'
> group by b.f2
>
> if f2.b if mediumtext I will got error 28 but when change type to varchar
> it OK but I realy need mediumtext type how to solve this problem
>
For a err
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
Hello, mysql,
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 table_a as a,table_b as b
where a.f1=b.f1
and a.f1='xxx'
17 matches
Mail list logo
