List:General Discussion« Previous MessageNext Message »
From:Martin Jespersen Date:August 22 2006 10:48pm
Subject:Re: How to utilize 16 logical CPUs
View as plain text  
Your mysql db is only using 496Mb of ram? i have a server with 1GB ram 
where mysql uses more mem than yours does - you should probably tune 
your server system variables a bit to utilize your memory better.

Christian Hammers wrote:
> On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis wrote:
>> One other quick ? -- Are you using a 64 bit (x86_64/EMT64) or 32-bit?  If 
>> you're still in 32-bit mode the extra memory over 4Gb can actually slow the 
>> system down since it has to page between memory zones.
> 
> It was choosen to run on i386 i.e. 32-bit mode for compatibility to Java
> and other servers in the farm.
> 
> But as you can see not even the 3GB border is touched:
> 
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
>  5076 mysql     15   0 1434m 496m 4992 S 99.9  6.1  54931:46 mysqld            
> 
> But despite the 99% CPU, vmstat thinks the system is idle.
> 
> procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
>  r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id wa
>  1  0      0 2959212 139684 3831556    0    0     1     0    1     1  6 3 88  3
>  0  0      0 2959584 139684 3830516    0    0     0     0 4785     0  7 4 89  0
>  1  0      0 2959212 139692 3831548    0    0     0   100 3453     0  7 4 89  0
>  6  0      0 2957104 139700 3830760    0    0     8     0 3696     0  7 5 87  0
>  2  0      0 2958592 139700 3831020    0    0    32     0 4230     0  7 5 88  0
>  1  0      0 2958220 139712 3830748    0    0     0   596 3904     0  8 5 87  0
> 
> 
> bye,
> 
> -christian-
> 
Thread
How to utilize 16 logical CPUsChristian Hammers22 Aug
  • Re: How to utilize 16 logical CPUsMiles Teg22 Aug
  • Re: How to utilize 16 logical CPUsDan Buettner22 Aug
    • Re: How to utilize 16 logical CPUsChristian Hammers22 Aug
      • Re: How to utilize 16 logical CPUsDan Buettner22 Aug
        • Re: How to utilize 16 logical CPUsChristian Hammers22 Aug
Re: How to utilize 16 logical CPUsChristian Hammers22 Aug
  • Re: How to utilize 16 logical CPUsMartin Jespersen23 Aug