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
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
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
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.
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
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
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:
>
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
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
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
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
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.
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
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
14 matches
Mail list logo
