[CentOS] OT: MySQL Help

[Mike Kercher]

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