<div>
A program accesses virtual memory when there is not enough &quot;Real&quot; memory. &nbsp;I would add another GB. &nbsp;i think you will see a great improvement.
</div>


A program accesses virtual memory when there is not enough "Real" memory.  I would add another GB.  i think you will see a great improvement.

<div>
I have 2Gb of RAM in my XServe, when I see the Free RAM showing up as real low, I run the periodic scripts - and that always helps - as it frees up memory being used to keep big log files open. So try that.<br />
<br />
Open Terminal and type this in:<br />
<br />
periodic daily weekly monthly<br />
<br />
then hit Return.<br />
<br />
It'll take a little while to run, but it should help.
</div>


I have 2Gb of RAM in my XServe, when I see the Free RAM showing up as real low, I run the periodic scripts - and that always helps - as it frees up memory being used to keep big log files open. So try that.

Open Terminal and type this in:

periodic daily weekly monthly

then hit Return.

It'll take a little while to run, but it should help.

<div>
<div class="content wysiwyg-content">
Our MySQL has been running slow as of late. &nbsp;We're running the default version that comes with OS X Server 10.3.9. &nbsp;We have about 30 clients submitting a query about every second (total).<br />
<br />
When I look at the Activity Monitor I see that mysqld is using 8 Megs of Real Memory and 500 to 600 Megs of Vritual memory. &nbsp;Does this mean that most of MySQL's memory is on the hard disk and performing slowly? &nbsp;Should it be listed in Real memory? &nbsp;I see that the activity monitor says I only have 14megs of system memory free.<br />
<br />
The server has 1 Gb of memory, and is running as a busy file server, domain manager and MySQL server. &nbsp;Would adding memory make a difference to Mysql?<br />
<br />
Thanks in advance,<br />
<br />
masterwoodsman
</div>
</div>


Our MySQL has been running slow as of late.  We're running the default version that comes with OS X Server 10.3.9.  We have about 30 clients submitting a query about every second (total).

When I look at the Activity Monitor I see that mysqld is using 8 Megs of Real Memory and 500 to 600 Megs of Vritual memory.  Does this mean that most of MySQL's memory is on the hard disk and performing slowly?  Should it be listed in Real memory?  I see that the activity monitor says I only have 14megs of system memory free.

The server has 1 Gb of memory, and is running as a busy file server, domain manager and MySQL server.  Would adding memory make a difference to Mysql?

Thanks in advance,

masterwoodsman

Mysql using lots of Virtual Memory

Apple's early computers ran on a variety of operating systems, including a Pascal version and one based on CP/M, before releasing its ProDOS with the advent of its 16-bit computer. With the release of the Lisa, which had its own OS, Apple and computing entered the graphical age; it was followed by the Macintosh, which offered a series of "System" operating systems. Other Mac operating systems included PowerPC until Apple acquired NeXT and folded it into the Mac OS. Current operating systems for Apple devices are Mac OS-X and iOS.