> -----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. > > 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 at centos.org > http://lists.centos.org/mailman/listinfo/centos >