Hi,
We have just recently moved 1 of our InnoDB cache servers to a new much
bigger machine, 4 CPU, 8GB Ram and masses amount of disk space available
from a SAN. The OS is Redhat AS 3 with kernel 2.4. MySQL is the only
application on this machine and its the latest stable release of 4.0.x.
Throughout the day most of the queries are inserts and selects and the
machine runs no problem with the mysql sitting at about 1.6Gb in memory.
At night we run an expiry job where we clean our expired records from the
cache, there are a few million records removed. The job runs for about 4/5
hours but for some reason the machine starts to use swapspace. I dont
understand why the machine would use it. The MySQL process never goes above
2GB RAM in memory so where does all the other memory on the machine
disappear to.
Right now with the job finished these are the stats of the memory.
total used free shared buffers cached
Mem: 7998296 7978396 19900 0 158204 5913696
-/+ buffers/cache: 1906496 6091800
Swap: 4192912 1696296 2496616
There is 6GB sitting free in buffer and 1.6GB used of swap. As I understand
(correct me if I'm wrong), Linux should free memory from these buffers when
needed by something else. Why should the machine be using swap at all if
there is plently of memory elsewhere that can be used ??
Any help on this would be great.
Marvin Wright
Flights Developer
Lastminute.com
[EMAIL PROTECTED]
+44 (0) 207 802 4543
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
