I would run the DB on a RAMDisk
http://www.ibiblio.org/mdw/linuxfocus/English/November1999/article124.html
Anyone else?
Martin
- Original Message -
From: Kayra Otaner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:56 PM
Subject: MySQL 4.0.13 Memory problem
In the last episode (Aug 20), Kayra Otaner said:
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.
I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
same MySQL version.
Recently our master database
Keep in mind that Linux will allocate nearly all of its free RAM to the
buffer cache as the kernel opens and reads files to increase filesystem
performance (cat /proc/meminfo and look at the buffers row) So, lack
of free RAM may not mean what you think it means.
As for the too many