OT: MySQL Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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



[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux