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