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,