Thank you a lot. The first indexing process finished after about 13
hours, so I think the problem is solved now.
I set the myisam_sort_bufffer_size to 10GB.
For the query I will adjust it to your version.
Am 20.06.2012 23:32, schrieb Rick James:
SELECT ruid1, ruid2, overlap FROM l4_link WHERE
On 20/06/2012 11:45, Christian Koetteritzsch wrote:
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
Hiya
I am unable to help. But
At 02:04 AM 6/21/2012, you wrote:
Thank you a lot. The first indexing process finished after about 13
hours, so I think the problem is solved now.
I set the myisam_sort_bufffer_size to 10GB.
The "first indexing process"???
You should have created all of your indexes with one Alter statement.
Can you PLEASE note in your listing when a product is Microsloth-only?
While you're at it, can you PLEASE note it prominently on your website? I
looked through your product description and saw no specific requirements beyond
what databases were supported. It wasn't until I tried to download it t
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
I don't know if new members usually introduce themselves here...
...but if not, why not?
I was very active on the SQL Server news group a few years back but this MYSQL
stuff is new to me.
Seems I'll be muddling around for at least a little while so I might have a few
questions in the near future
Welcome Raymond, hope you enjoy your stay :)
On Thu, Jun 21, 2012 at 8:47 PM, Raymond D'Anjou <
radan...@osullivan-quebec.qc.ca> wrote:
> I don't know if new members usually introduce themselves here...
> ...but if not, why not?
>
> I was very active on the SQL Server news group a few years back
Possibly worse than that, since it will rebuild the 'first' index again.
> -Original Message-
> From: mos [mailto:mo...@fastmail.fm]
> Sent: Thursday, June 21, 2012 7:51 AM
> To: mysql@lists.mysql.com
> Subject: Re: Indexing about 40 Billion Entries
>
> At 02:04 AM 6/21/2012, you wrote:
>
Hello there
I'm trying to figure out an elegant way with Mysql 5.5.25 to log changes
via a before change trigger to a table including the column name of the
field that changed...
How can I dynamically enumerate the field names and populate the field log
into the t1_log test table ... Would a curso
To endow CREATE VIEW with COMMENT would be splendid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2012/06/20 14:32 -0700, Rick James
(
SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid1=xxx
UNION
SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid2=xxx
) ORDER BY overlap DESC;
Make it UNION ALL or UNION DISTINCT depending on whether xxx can be in both
fields of one row.
2012/06/21 17:06 -0500, Gael Martinez
I'm getting that done today thru a large static trigger script and I would
like something more dynamic...
For that it is needful to look up the table in INFORMATION_SCHEMA.COLUMNS, and,
yes, you can look up the field names--but then what wil
The parens are for making sure the parsing works correctly. Probably either
one works fine. Suggest you do
EXPLAIN EXTENDED ...;
SHOW WARNINGS;
I suspect that the output from each will be identical, and have more parens.
The main need for parens is to avoid associating the ORDER BY with jus
Thanks Rick for your reply,
Here i am asking about logic to perpare query or whole query itself.
--Anupam
From: Rick James
To: Anupam Karmarkar ; "mysql@lists.mysql.com"
Sent: Wednesday, 20 June 2012 10:52 PM
Subject: RE: Need Query Help
http://dev.mysql
14 matches
Mail list logo