> -----Original Message-----
> From: centos-bounces@xxxxxxxxxx
> [mailto:centos-bounces@xxxxxxxxxx] On Behalf Of Mike Kercher
> Sent: Wednesday, May 10, 2006 12:27 AM
> To: CentOS mailing list
> Subject: RE: OT: MySQL Help
>
> ----Original Message----
> From: centos-bounces@xxxxxxxxxx
> [mailto:centos-bounces@xxxxxxxxxx] On Behalf Of Thomas E
> Dukes Sent: Tuesday, May 09, 2006 11:05 PM
> To: 'CentOS mailing list'
> Subject: RE: OT: MySQL Help
>
> :: -----Original Message-----
> :: From: centos-bounces@xxxxxxxxxx
> :: [mailto:centos-bounces@xxxxxxxxxx] On Behalf Of Mike Kercher
> :: Sent: Tuesday, May 09, 2006 11:17 PM
> :: To: CentOS mailing list
> :: Subject: RE: OT: MySQL Help
> ::
> :: 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
> :
> : 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
>
> In your /etc/my.cnf under the [mysqld] section, add these lines:
>
> query-cache-type = 1
> query-cache-size = 20M
>
> You can adjust the cache size based on your system.
>
> Save your changes and restart mysqld and test.
>
> Mike
Hello Mike,
Thanks!!! I'll give that a try.
Eddie
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>
