asdas wrote:
> It could be a known issue, but thought it's a well known & well used
> feature so, asking you all.
>
> I am trying to create an index with the following command -
>
> create index an_idx on atable (acol desc, bcol, ccol)
>
> Then when I do a -
>
> show index from atable
>
> It show
asdas wrote:
I am trying to create an index with the following command -
create index an_idx on atable
(acol desc, bcol, ccol)
/
select pk, acol, bcol, ccol from atable
doesn't show the result in descending order of acol, instead it's in ascending
order of acol.
Is there a simple t
At 19:50 +0200 7/22/03, PaT! wrote:
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
-+
Hi!
On Feb 27, Sebastian Stan wrote:
> OK. but what about this :
> (AND i don't have a fulltext field !)
>
> Here's my table:
>
> (lac CHAR (3),
> ano CHAR (7),
> bno CHAR (18),
> cty CHAR (4),
> dat CHAR (8),
> tim CHAR (6),
> dur CHAR (8),
> ccu CH
OK. but what about this :
(AND i don't have a fulltext field !)
Here's my table:
(lac CHAR (3),
ano CHAR (7),
bno CHAR (18),
cty CHAR (4),
dat CHAR (8),
tim CHAR (6),
dur CHAR (8),
ccu CHAR (8),
loc CHAR (20),
ccl CHAR (12),
isdn CHAR
Sergei Golubchik wrote:
Which decision, putting all the indexes in one file, or rebuilding all
indexes whenever you ALTER TABLE or add an index? If the latter, I
agree with you. Modifying unrelated indexes or columns should not
force a rebuild of every index.
Of course not.
And it won't e
Hi!
On Feb 16, david wrote:
>
> Hi
>
> I have one table with 12 million records. I'm trying to create an index
> on one of the fields and it's taking hours ( over 6 so far)! Am I doing
> something wrong?
>
> The command I issued was
> create index title on article ( title);
>
> The table
Hi!
On Feb 16, Dan Nelson wrote:
> In the last episode (Feb 16), Michael T. Babcock said:
> > > At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
> > > > Well, MySql stores all its index information in one index file,
> > > > so when you add another index it has to rebuild the WHOLE file.
> > > > :
In the last episode (Feb 16), Michael T. Babcock said:
> > At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
> > > Well, MySql stores all its index information in one index file,
> > > so when you add another index it has to rebuild the WHOLE file.
> > > :)
>
> Anyone on the MySQL team feel like ex
At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
Well, MySql stores all its index information in one index file, so
when you
add another index it has to rebuild the WHOLE file. :)
Anyone on the MySQL team feel like explaining that design decision,
besides historical reasons? I doubt its any
nt: Sunday, February 16, 2003 6:13 PM
Subject: Re: CREATE INDEX is sooo slow! any ideas?
> Yes it is but why would that slow down index creation on the other field.
> The full text index is just for the body field.
>
> Thanks
>
> At 05:58 PM 2/16/2003 -0500, Peter Grigor wrote:
&
"david" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 6:13 PM
Subject: Re: CREATE INDEX is sooo slow! any ideas?
> Yes it is but why would that slow down index creation on the other field.
&
Yes it is but why would that slow down index creation on the other field.
The full text index is just for the body field.
Thanks
At 05:58 PM 2/16/2003 -0500, Peter Grigor wrote:
That body column wouldn't happen to be a fulltext index, would it? :)
If so, 'ave another coffee.
Peter
<^_^>
--
I meant buy the whole chain, its going to take a few cups
Jerry
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 11:11 PM
Subject: Re: CREATE
nday, February 16, 2003 6:00 PM
Subject: Re: CREATE INDEX is sooo slow! any ideas?
> Another coffee ?
>
> I'd buy Starbucks .
>
> Jerry
>
> - Original Message -
> From: "Peter Grigor" <[EMAIL PROTECTED]>
> To: <[EMAIL PROT
Another coffee ?
I'd buy Starbucks .
Jerry
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "david" <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 10:58 PM
Subject: Re: CREATE INDEX is
That body column wouldn't happen to be a fulltext index, would it? :)
If so, 'ave another coffee.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Thanks to everyone who replied - much appreciated.
Ok here is how it went :
1 Creating index first and loading table :saved 1 minute overall
2 Increasing key_buffer -> 100M :no difference
3 increasing myisam_max_sort_file_size-> 1000M and
myisam_sort_buffer_size->10
David White writes:
> I have a problem with some data disappearing after a CREATE INDEX
> statement. Here's the sequence of events:
>
> 1. I have the tables MASTER_ACCOUNT, MASTER_EMAIL, MASTER_GROUP,
> MASTER_INDIVIDUAL, TMP_PHONE_DAY, TMP_PHONE_FAX, and TMP_PHONE_NIGHT.
> All of these are pop
19 matches
Mail list logo
