----Original Message----
From: centos-bounces(a)centos.org [mailto:centos-bounces@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(a)centos.org
:: [mailto:centos-bounces@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(a)centos.org <> scribbled on Tuesday, May 09, 2006 8:57
:: PM:
::
:::: -----Original Message-----
:::: From: centos-bounces(a)centos.org
:::: [mailto:centos-bounces@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