Processor usage vs memory

I noticed that I am having a ton of processor usage on my db server. I
played with optimization a little bit according to the MySQL user
manual, but I admittadly don't really know what I am doing. My question
is this: I have pretty high processor usage, but I have a full half gig
of free memory at any given point (and mysql-nt usees far less than 100
megs of memory even at full processor load). How do I move the load
more to memory and less to processor?

On a side note, MySQL Administrator says I am only using about 10 megs
of key buffer, even when I set that value to much higher. The hit rate
is almost constantly 100% on the key buffer. I don't really know what
the hit rate means, but it seems like there should be more key buffer
memory being used. I also allocated a ton of memory for the query
cache, and that seems to have helped a lot. Any further tips would be
very, very appreciated.

Thanks!
Corey


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Processor usage vs memory

Greetings,

On Tue, 7 Dec 2004 13:42:02 -0600, Corey Tisdale wrote:
> I noticed that I am having a ton of processor usage on my db server. I
> played with optimization a little bit according to the MySQL user
> manual, but I admittadly don't really know what I am doing. My question
> is this: I have pretty high processor usage, but I have a full half gig
> of free memory at any given point (and mysql-nt usees far less than 100
> megs of memory even at full processor load). How do I move the load
> more to memory and less to processor?


What kind of tables do you use? I disabled support for all table types
not in use on my system, left only innodb and myisam, that helped. I
also have a lot of memory (RAM) so I locked mysql at the memory,
avoiding the swap file use for the server (HD usage is always a slower
resource).

> On a side note, MySQL Administrator says I am only using about 10 megs
> of key buffer, even when I set that value to much higher. The hit rate
> is almost constantly 100% on the key buffer. I don't really know what
> the hit rate means, but it seems like there should be more key buffer
> memory being used. I also allocated a ton of memory for the query
> cache, and that seems to have helped a lot. Any further tips would be
> very, very appreciated.

I believe the hit rate is the ammount of times the search was able to
find the information on the key buffer, instead of a full table scan
(correct me if I'm wrong) but that is a good thing and should not use
more memory, as the key index are pretty small compared to the tables.

Are you using the correct MySQL daemon (nt, max, opt) ? Try searching
for the right one. There were changes in the names from a version to
other, and mysqld-max and opt are the recommended, I believe, look at
the manual before choosing. Be careful, slow-logs and binary logs
consumes lots of resources (all kind of logs does) I turned mine off
after the test period.

Hope that helps,

> Thanks!
> Corey

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Processor usage vs memory

I used the variable "memlock", at the MySQL config file (my.ini or
my.cnf), this way:

[mysqld]
memlock

:) Hope that helps.

On Fri, 10 Dec 2004 13:50:58 -0500, matt_lists
wrote:
>
> >What kind of tables do you use? I disabled support for all table types
> >not in use on my system, left only innodb and myisam, that helped. I
> >also have a lot of memory (RAM) so I locked mysql at the memory,
> >avoiding the swap file use for the server (HD usage is always a slower
> >resource).
> >
> >
> >
> How did you do this?
>
> I cant get it to stay in memory, it always swaps everything as soon as
> the program starts
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org