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 returning
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 exist in some
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 returning the following error
,
Heston
-Original 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
: 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 returning the following error:
(InternalError) (3
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.
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 google all signs
: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 or
something
like this. This is only the partition where the data files are on. The
other
partitions are not of interest for this.
Could
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 or
something
like this. This is only the partition where the data files are on. The
other
partitions are not of interest for this.
Could you let me know which MySQL
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
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 space
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 error
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'
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
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 error description use perror
perror 28
Error code 28: No space left on device
So
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,
In select
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
17 matches
Mail list logo