[CentOS] OT: MySQL Help
Thomas E Dukes
edukes at alltel.net
Wed May 10 04:05:13 UTC 2006
> -----Original Message-----
> From: centos-bounces at centos.org
> [mailto:centos-bounces at centos.org] On Behalf Of Mike Kercher
> Sent: Tuesday, May 09, 2006 11:17 PM
> To: CentOS mailing list
> Subject: RE: [CentOS] OT: MySQL Help
> centos-bounces at centos.org <> scribbled on Tuesday, May 09,
> 2006 8:57 PM:
> >> -----Original Message-----
> >> From: centos-bounces at centos.org
> >> [mailto:centos-bounces at centos.org] On Behalf Of Alan Sparks
> >> Sent: Tuesday, May 09, 2006 9:37 PM
> >> To: CentOS mailing list
> >> Subject: Re: [CentOS] 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.
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?
> CentOS mailing list
> CentOS at centos.org
More information about the CentOS