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-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]