> -----Original Message-----
> From: centos-bounces@xxxxxxxxxx
> [mailto:centos-bounces@xxxxxxxxxx] On Behalf Of Mike Kercher
> Sent: Tuesday, May 09, 2006 11:17 PM
> To: CentOS mailing list
> Subject: RE: OT: MySQL Help
>
> centos-bounces@xxxxxxxxxx <> scribbled on Tuesday, May 09,
> 2006 8:57 PM:
>
> >> -----Original Message-----
> >> From: centos-bounces@xxxxxxxxxx
> >> [mailto:centos-bounces@xxxxxxxxxx] On Behalf Of Alan Sparks
> >> Sent: Tuesday, May 09, 2006 9:37 PM
> >> To: CentOS mailing list
> >> Subject: Re: OT: MySQL Help
> >>
> >> Thomas E Dukes wrote:
> >>> I ran the following against a table:
> >>>
> >>> ALTER TABLE `products` ADD INDEX `idx_products_model` (
> >>> `products_model` );
> >>>
> >>>
> >>> Can this index be removed? If so, how?
> >>>
> >>
> >> Maybe
> >> DROP INDEX `idx_products_model`
> >> or
> >> ALTER TABLE `products` DROP INDEX `idx_products_model`
> >
> > Thanks for the help. Wasn't sure if 'DROP' was what I
> needed to use.
> > I'm not that MySQL savy. I was following a suggestion to
> speed up a
> > process.
> > The problems I'm having aren't in the same table and I was was just
> > trying to cover any changes since the problems began.
> >
> > I ran mysqlcheck on the database and got an OK on all tables.
> > Must be something else.
> >
> > Thanks!!
> >
> >
> >>
> >> --
> >> Alan Sparks, UNIX/Linux Systems Integration and Administration
>
> Are you running mysql-4.x? If so, you might consider using
> the caching features of 4.x+ It has helped some of my mysql
> intensive sites quite a bit.
>
> Mike
Hello Mike,
Yes, I'm still running 4.1.12-3 I was hoping to speed things up by adding
the index to that table.
I'm not too mysql savy as I said before. How do I set up the caching?
Thanks
>
>
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>
