Olaf,
That's a very broad question depending upon your exact requirements
to be honest. So long as you've considered file size limitations and
you've opted for a decent RAID system there's not too much more to worry
about, try and buy the fastest disks possible obviously i.e. 15,000 RPM
one
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http:/
om: "Olaf Stein" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, December 29, 2006 4:14 AM
> Subject: Max size and row numbers
>
>
>> Hey everyone
>>
>> I have more of a general question regarding your experience with large
>> tables.
>>
&
. myisampack usually compresses a table by at
least 50%, so you can have, in effect, much bigger tables.
Thanks
Visolve DB Team
- Original Message -
From: "Olaf Stein" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 29, 2006 4:14 AM
Subject: Max size and row numbers
Hey everyone
I have more of a general question regarding your experience with large
tables.
I currently have a table (MyISAM, 6 columns, lots of reading access, some
writing) with about 70.000.000 records, using 2.5GB of diskspace. I am
running MySQL 5.0.* on a RedHat Enterprise AS 4 system (2 CP
Chris W wrote:
Is there an easy way to add row numbers to the result of a select
statement?
With a user variable:
SET @i = 0;
SELECT @i:= @i + 1 AS 'Row', ...
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Is there an easy way to add row numbers to the result of a select
statement?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing
[EMAIL PROTECTED] wrote:
Chris <[EMAIL PROTECTED]> wrote on 05/10/2005 12:20:57 PM:
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
Chris <[EMAIL PROTECTED]> wrote on 05/10/2005 12:20:57 PM:
> Harald Fuchs wrote:
>
> >In article <[EMAIL PROTECTED]>,
> >[EMAIL PROTECTED] writes:
> >
> >
> >
> >>hi,
> >>your need is:
> >>select * from temp LIMIT 3,4;
> >>-- 3 because you have to take the fourth and 4 because dist=3+1
> >>
> >
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the
rows in some undefined order. If
'll probably end up putting the results of my query into a temp
table, complete with row numbers, then run my query for that. Or maybe a
derived table.
Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here, off the top of my head are situations in mysql where you can trust
that the data is ordered in some fasion.
1. Using an order by clause on a query.
2. Using a group by the data will come out in ascending order of the
column that was grouped on.
3. alter table order by has been performed and
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
>> CREATE TEMPORARY TABLE tbl1 (
>> id INT UNSIGNED NOT NULL,
>> val INT UNSIGNED,
>> PRIMARY KEY (id),
>> UNIQUE KEY (val)
>> );
>>
>> INSERT INTO tbl1 (id, val) VALUES (1, 1);
>> INSERT INTO tbl1 (id, val) VALUES (2, 2);
>> INSERT INTO t
news <[EMAIL PROTECTED]> wrote on 10/05/2005 15:13:49:
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] writes:
>
> > Hi,
> > Have you forgotten what's a primary key ?
>
> > Using order by will sort data, and if it's already sorted, it willbe
sorted
> > again. Time, memory and maybe disk i
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> Hi,
> Have you forgotten what's a primary key ?
> Using order by will sort data, and if it's already sorted, it will be sorted
> again. Time, memory and maybe disk io.
If MySQL really does that, I'd consider this a bug.
> Using the mar
ge -
> From: "Marco Neves" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, May 10, 2005 7:14 AM
> Subject: Re: SELECT Row Numbers?
>
>
> > oix ppl,
> >
> > now I have a question.
> >
> > I thougth that when you make a SELECT without an OR
, not something
that is guaranteed to happen.
Rhino
- Original Message -
From: "Marco Neves" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 10, 2005 7:14 AM
Subject: Re: SELECT Row Numbers?
> oix ppl,
>
> now I have a question.
>
> I thougth that when you ma
oix ppl,
now I have a question.
I thougth that when you make a SELECT without an ORDER BY, the rows
were
returned in natural order, that would be some specific order (insertion
order, presence in file, I don't know, but the order would be always the
same).
Is this unc
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> hi,
> your need is:
> select * from temp LIMIT 3,4;
> -- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the
rows in some undefined order. If you use "LIMIT 3,
Selon Chris <[EMAIL PROTECTED]>:
> I'm looking for a row numbering in a select statement. Something I can
> use to determine in whivh row values are returned in a query.
>
> I found this insanely old list post:
>
> http://lists.mysql.com/mysql/337
>
> That appears to be what I want, but an examin
I'm looking for a row numbering in a select statement. Something I can
use to determine in whivh row values are returned in a query.
I found this insanely old list post:
http://lists.mysql.com/mysql/337
That appears to be what I want, but an examination of the changelogs for
MySQL 3.23 didn't g
ão Borsoi Soares <[EMAIL PROTECTED]> wrote on 11/23/2004 06:30:26
AM:
> No body has answered my question so far. Does that mean there is no way
> to retrieve current row numbers in a query or no way to retrieve results
> jumping steps?
>
> I would appreciate any help.
>
João Borsoi Soares <[EMAIL PROTECTED]> wrote on 23/11/2004
12:34:01:
> First thanks for the answer Alec. But I think you didn't understood my
> problem. Maybe nobody replied because of that. Let me try again.
>
> Suppose I make a select which returns 100 ordered rows. I only want to
> read rows
>
> João Borsoi Soares <[EMAIL PROTECTED]> wrote on 23/11/2004
> 11:30:26:
>
> > No body has answered my question so far. Does that mean there is no way
> > to retrieve current row numbers in a query or no way to retrieve results
> > jumping steps?
> >
our table. You could do this by something like
SELECT FROM ORDER BY rand() LIMIT ;
João Borsoi Soares <[EMAIL PROTECTED]> wrote on 23/11/2004
11:30:26:
> No body has answered my question so far. Does that mean there is no way
> to retrieve current row numbers in a query or no w
No body has answered my question so far. Does that mean there is no way
to retrieve current row numbers in a query or no way to retrieve results
jumping steps?
I would appreciate any help.
Thanks,
Joao.
-Mensagem encaminhada-
> From: João Borsoi Soares <[EMAIL PROTECTED]>
>
ping rows, like "STEP N" where "N"
could be the number of items in each group. Is there anything in mysql
that can give me that? I also thought if I could have the row numbers in
the query result, I could solve it with a simple condition like, "WHERE
rowNum % N = 0".
Any
Jens Porup wrote:
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at row: 36763
Ho
just as:
$myquery = "select * from sometable";
$myresult = mysql_query($myquery, $mysql_link);
$rows = $mysql_fetch_array($myresult)
$count = 1;
while ($rows)
{
print(" $count$rows[0]$rows[1]...
$count++;
}
I would do the same thing in perl, C++, or Java.
Curtis
On Sun, 16 Feb 2003, Micha
Luc Foisy wrote:
I didn't say it had nothing to do with the data, I said it had nothing to do with the data in the database.
I'm making the assumption as a DBA that _all_ the data relevant is in
the database; so the comment I made was equivalent to the above.
As I said, sure I could make ext
On Fri, Feb 14, 2003 at 01:04:00PM -0500, Luc Foisy wrote:
> I didn't say it had nothing to do with the data, I said it had
> nothing to do with the data in the database. The data in the
> recordset returned from the database referenced by row is important.
[...]
> 1. There are a lot of function
>
> On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> > >That means no field exists or should exist in the
> database. I only want to
> > >generate at query time.
> > >I can't use an autoincrement field since that wont work
> very well with
> > >results that are returned out of
On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> >That means no field exists or should exist in the database. I only want to
> >generate at query time.
> >I can't use an autoincrement field since that wont work very well with
> >results that are returned out of order and maybe not
At 12:31 PM 2/13/03 , Luc Foisy wrote:
> > I still don't understand do you mean the "actual" row
> number or just a
> > display number.
> > > There is no relevant data or use to this number.
> > > It is the row number of the returned result set, purely
> > > for display.
That means no field exis
I thought of a new feature... XSLT's "position()"-like functionality
in the new releases of MySQL.
position(), in XSLT, returns position of the node in the document tree.
In MySQL it would return position of the record in the returned result set
(from SELECT query):
Example:
SELECT POSIT
On 13 Feb 2003, at 15:31, Luc Foisy wrote:
> Using variables is the best response to my question. I just dislike
> using them cause they are ugly to work with because of the session
> persistance and because I have to issue multiple queries to do the
> job.
Using variables seems to be the way to
> > I still don't understand do you mean the "actual" row
> number or just a
> > display number.
> > > There is no relevant data or use to this number.
> > > It is the row number of the returned result set, purely
> > > for display.
That means no field exists or should exist in the database. I
Auto-inc column would be the obvious answer, but that's and intrusive
answer.
Jerry
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Luc Foisy" <[EMAIL PROTECTED]>
Cc: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursda
or
regardless of the order the resultset appears.
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 1:48 PM
To: Luc Foisy
Subject: Re: Row numbers
Have to have one in the row and select that along with the
query, if your
going to use it f
TECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 2:09 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: AW: Row numbers
I stated to implement something like Oracle's ROWNUM ...
but noone's listening ... therefore I build an UDF ...
> -Ursprüngliche Nachricht-
>
I still don't understand do you mean the "actual" row number or just a
display number.
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:59 PM
Subject
I stated to implement something like Oracle's ROWNUM ...
but noone's listening ... therefore I build an UDF ...
> -Ursprüngliche Nachricht-
> Von: Luc Foisy [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 13. Februar 2003 20:00
> An: MYSQL-List (E-mail)
>
.
> -Original Message-
> From: Jerry [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 1:48 PM
> To: Luc Foisy
> Subject: Re: Row numbers
>
>
> Have to have one in the row and select that along with the
> query, if your
> going to use it for some
: Is there a way to get a row number returned with any select query?
Row number is not available for some queries (ex.DELETE FROM table_name)
for efficiency. You can disable it with a dummy WHERE clause:
DELETE FROM table_name WHERE 1 > 0;
It will be slower, but you'll get the desire
Is there a way to get a row number returned with any select query?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
46 matches
Mail list logo
