You are referring to fragmentation. In this case I'm pretty sure it's
just a matter of updating the indexes so that MySQL makes the correct
assumptions about the distribution of data. MySQL assumes data values
have an equal distribution in a database, updating the indexes will
force MySQL to u
when i reimport i usually drop all the indexes first anyway as it takes
forever i have found that a repair table quick usually helps after
reindexing too
-Original Message-
From: Adam Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 8:09 AM
To: 'MySQL'
Subject: reindexing
Jeff,
- Original Message -
From: "Jeff Mathis" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, August 07, 2003 9:01 PM
Subject: Re: reindexing
> what is the command to update InnoDB table indexes?
if you mean update index cardinality statis
what is the command to update InnoDB table indexes?
jeff
Brent Baisley wrote:
>
> You are referring to fragmentation. In this case I'm pretty sure it's
> just a matter of updating the indexes so that MySQL makes the correct
> assumptions about the distribution of data. MySQL assumes data values
I was under the impression that InnoDB tables took care of this for you.
You only need to be concerned if you add/delete repeatedly from anywhere
but the end rows of the table.
I'd like to know if I'm wrong about this.
Adam Nelson wrote:
>
> I just did a major insert of new data and now all my
On 30-Jul-2001 shawn reed wrote:
> i've tried simply re-creating the index as you suggested ... no luck.
>
> here's a brief summary of my situation: i developed an application on one
> server, after it was developed and ready to go live we started to move it
> to another server. after moving it
i've tried simply re-creating the index as you suggested ... no luck.
here's a brief summary of my situation: i developed an application on one
server, after it was developed and ready to go live we started to move it
to another server. after moving it i noticed my search function wasn't
working
What about issueing first drop index, then add index? Should do
the job. Or repair table. What does check table or myisamchk say?
shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15:
> hi all,
> i apologize for the utterly newbie-ish question, but i've yet to find an
> answer to it after havi