Also depends on your data access pattern as well.
If you can take advantage of clustering my primary key for your
selects, then InnoDB could do it for you.
My suggestion would be to write some queries based on projected
workload, build 2 tables with lots and lots of data, and do some
isolated testi
I've already downloaded the 64 bit build of MySQL to have ready for a
64 bit machine I have coming.
But the only available download for Workbench binaries is 32 bit.
So I have a few questions:
(1) will the 32 bit Workbench work with 64 bit MySQL under Windows XP (64 bit)?
(2) if I need to compi
Yes, that's the trick. Thank Rudy and Gavin.
Best,
Jia
On Mon, Apr 5, 2010 at 2:13 PM, Gavin Towey wrote:
> Union does a distinct on all results. UNION ALL will avoid that.
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: chen.1...@gmail.com [mailto:chen.1...@gmail.com] On Beha
Union does a distinct on all results. UNION ALL will avoid that.
Regards,
Gavin Towey
-Original Message-
From: chen.1...@gmail.com [mailto:chen.1...@gmail.com] On Behalf Of chen jia
Sent: Monday, April 05, 2010 11:07 AM
To: mysql@lists.mysql.com
Subject: Slow Union Statement
Hi there,
On 04/05/2010 02:06 PM, chen jia wrote:
> Hi there,
>
> I run simple statement like this:
>
> create table c
> select * from a
> union
> select * from b;
>
> where table a has 90,402,534 rows, and table b has 33,358,725 rows.
> Both tables have the same three variables.
>
> It's taken a long ti
Hi there,
I run simple statement like this:
create table c
select * from a
union
select * from b;
where table a has 90,402,534 rows, and table b has 33,358,725 rows.
Both tables have the same three variables.
It's taken a long time, more than half an hour now. How do I make it faster?
Best,
Ji
From: Gavin Towey
InnoDB should be your default for all tables, unless you have
specific requirements that need myisam. One specific example of an
appropriate task for myisam is where you need very high insert
throughput, and you're not doing any updates/deletes concurrently.
A couple o
I have the following two tables
CREATE TABLE `cfg_tags` (
`cluster` varbinary(128) NOT NULL,
`tag` varbinary(128) NOT NULL,
`user` varchar(40) NOT NULL,
PRIMARY KEY (`cluster`,`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
CREATE TABLE `cfg_cluster_info` (
`cluster` varbinary(128) NOT
