----Original Message---- From: centos-bounces@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@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@centos.org <> scribbled on Tuesday, May 09, 2006 8:57 :: PM: :: :::: -----Original Message----- :::: From: centos-bounces@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
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@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@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@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@centos.org <> scribbled on Tuesday, May 09, 2006 8:57 :: PM: :: :::: -----Original Message----- :::: From: centos-bounces@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
Hello Mike,
Thanks!!! I'll give that a try.
Eddie
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
I'd like to know more about the original problem you're having since creating an index file. Would you post more detail on this? Otherwise, everything else is just guessing.
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Mark Richards Sent: Thursday, May 11, 2006 7:48 AM To: CentOS mailing list Subject: Re: [CentOS] OT: MySQL Help
I'd like to know more about the original problem you're having since creating an index file. Would you post more detail on this? Otherwise, everything else is just guessing.
Hello Mark,
I found the problem. It wasn't the index I added. I made a change to another file I had forgotten about and had a typo in it.
Thanks for your response. I should have posted back that the problem is solved.
Sorry for any inconveinece.
Eddie
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Mark Richards -
Mike Kercher -
Thomas E Dukes