[CentOS] OT: MySQL Help

Wed May 10 11:38:23 UTC 2006
Thomas E Dukes <edukes at alltel.net>

 

> -----Original Message-----
> From: centos-bounces at centos.org 
> [mailto:centos-bounces at centos.org] On Behalf Of Mike Kercher
> Sent: Wednesday, May 10, 2006 12:27 AM
> To: CentOS mailing list
> Subject: RE: [CentOS] OT: MySQL Help
> 
> ----Original Message----
> From: centos-bounces at centos.org 
> [mailto:centos-bounces at centos.org] On Behalf Of Thomas E 
> Dukes Sent: Tuesday, May 09, 2006 11:05 PM
> To: 'CentOS mailing list'
> Subject: RE: [CentOS] OT: MySQL Help
> 
> :: -----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
> 
> 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 at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>