[CentOS] OT: MySQL Help

Wed May 10 04:27:21 UTC 2006
Mike Kercher <mike at vesol.com>

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