Processor at 99.9%, memory at 5%. Configuration help?
I bought a new server, which has over 300 queries a second, searching through tables of around 30,000 entries. There are a few updates, but very few inserts.
Anyways, my website takes about 20 seconds to respond since mysql is bogging it all down. The thing is, my 1.5 gigs of memory are hardly used at all.
My mysql installation has the default configuration.
What options can I change so that more memory is used, and less processor? (How big can certain caches be, what will help my server run quicker?)
Thanks a lot
Subject
Views
Written By
Posted
Processor at 99.9%, memory at 5%. Configuration help?
5566
February 05, 2009 11:15PM
3820
February 06, 2009 12:13AM
2691
February 07, 2009 10:04PM
2468
February 07, 2009 11:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.