At 05:36 PM 4/7/2011, Daevid Vincent wrote:
I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it doesn't
do diagrams (with wires between tables and all that glory). Am I wrong? Is
that feature there and I just never noticed it?
David,
SqlYog Ultimate has a schema designer. Ta
Whoa! I never realized Toad did that. Man that is one robust program. I'm
half minded to switch away from 'the Yog'... especially for FREE! Yeah, and
it does do the sticky wires!! It only guessed some of them, but at least
it's something. It seems to be missing an "auto arrange" kind of feature so
I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it doesn't
do diagrams (with wires between tables and all that glory). Am I wrong? Is
that feature there and I just never noticed it?
> -Original Message-
> From: mos [mailto:mo...@fastmail.fm]
> Sent: Thursday, April 07, 2011
At 02:17 PM 4/7/2011, Daevid Vincent wrote:
Does anyone have any suggestions on this? I've written to SQL Maestro twice
and they've not replied either.
Take a look at SqlYog from www.webyog.com. I use their community version
but their paid version has a schema designer. They are responsive to
Toad for MySQL can do the diagramming piece...but, it looks and feels like
you might have some of the same frustrations with it as well. But, another
tool worth exploring nonetheless.
On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent wrote:
> Does anyone have any suggestions on this? I've written
Does anyone have any suggestions on this? I've written to SQL Maestro twice
and they've not replied either.
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Friday, April 01, 2011 4:27 PM
To: mysql@lists.mysql.com
Subject: Any table visualization tools with wires connecting the actual
col
By the way, the weird-looking title is in Japanese (the database/table/field
are UTF-8).
Some of you might be able to read that.
Is it possible that this is upsetting the ANALYSE procedure?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Fa
>-Original Message-
>From: petya [mailto:pe...@petya.org.hu]
>Sent: Wednesday, April 06, 2011 3:55 PM
>To: John G. Heim
>Cc: mysql@lists.mysql.com
>Subject: Re: efficient use of varchar?
>
>Hi,
>
>There is difference between varchar(63) and varchar(38). Instead of
>selecting MAX(LENGTH()) y
We are currently evaluating the merge engine. Right now we create and
preload several index caches.
But what is the best way to approach this with a merged table? Do I
create a single index cache and assign all of the shards to it?
Or do I create a separate index cache for each shard?
I didn
We've been experimenting with the merge engine.
But suppose that instead of using the MERGE engine I instead modified my
code to UNION ALL the shards.
Would I get worse performance? In other words, besides the convenience,
does the MERGE engine have specific performance optimizations that mak
Hi,
On 04/07/2011 08:06 AM, petya wrote:
Hi,
You can always create any table from procedures. However, it seems to
me that flexviews can solve all of your problems, take a look at it.
It will provide you incrementally refreshable materialized views.
How do you create a table from a proced
On 04/06/2011 09:13 PM, Sándor Halász wrote:
I have a temporary table which is a smaller table generated from a rather big
one. The full table is too big to make real gimmicks on it, so I do need the
temp table. Later I do several queries on the temp table.
So my initial setup and needs are:
12 matches
Mail list logo
