Sorry guys, I forgot to post to the list as well.. -----Original Message----- From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 6:56 PM To: Marvin Wright Subject: RE: InnoDB Deletes / Swap Problem
Marvin, Does the job run locally on this machine with MySQL?.. If so.. How is your job run? Is it a bash script, pure SQL, PHP, or..? Maybe your script is consuming the additional memory? Just a thought,.. Regards, Lachlan -----Original Message----- From: Marvin Wright [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 6:22 PM To: [EMAIL PROTECTED] Subject: InnoDB Deletes / Swap Problem 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]