Hi,
thanks for the hint, I was testing the settings for the
myisam_sort_buffer_size so I totally forgot it.
But I have another three of these databases to do, so next time I do it
with one ALTER statement
Christian
Am 21.06.2012 16:50, schrieb mos:
At 02:04 AM 6/21/2012, you wrote:
Thank yo
where PARTITION shines. (I have not seen such [yet] in your application.)
-Original Message-
From: Christian Koetteritzsch [mailto:ckoetteritz...@e-humanities.net]
Sent: Wednesday, June 20, 2012 1:42 PM
To: Rick James
Cc: Ananda Kumar; mysql@lists.mysql.com
Subject: Re: Indexing about 40
sorry I forget the ORDER BY in the SELECT statement so the correct
SELECT statement is:
SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid1=xxx OR ruid2=xxx
ORDER BY overlap DESC
Am 20.06.2012 22:42, schrieb Christian Koetteritzsch:
Thanks for the information. It is no problem if it takes
in common.
I hope the informations I gave you are helpful. If you have more
questions than you can ask them.
Kind regards
Christian
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Wednesday, June 20, 2012 4:37 AM
To: Christian Koetteritzsch
Cc:mysql@lists.mysql.
Hi guys,
As the title says I'm trying to index 40 billion entries with two
indexes on a server with 16 cores and 128GB RAM. The table is the one
below and it is a myisam table. The *.myd file is about 640GB
DROP TABLE IF EXISTS `l4_link`;
CREATE TABLE `l4_link` (
`ruid1` int NOT NULL,
`r
