> -----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 >