MySQL server tuning?

[parkers]

Hi,

I run MySQL version 3.23.41 with RedHat v7.2 ... lately I noticed that our server with 768MB is running constantly at between 95% - 98% memory usage ... my question is, are there any generic tuning tips I can apply to reduce this ... e.g. can I direct MySQL to use disk area instead of main memory.

Although I do not notice the actual database applications running slowly, other applications do not appear to be running as quickly or as stable as previously.

Any hints or tips appreciated.

Thanks,
SP

 

[steez977]

hi, is it just the momory or also the CPU load you noticed an increase in? ...

 

[parkers]

Memory usage only ... CPU load is fairly insignificant.

 

[SM777]

If you mean that the server is showing 97% memory usage then thats normal - don't worry about it.

Unused ram is wasted ram. All Linux is doing is using your free ram as buffer or caching.

Even if you add another gig you'll find that you'll still have 9x% used.

What you need to look at is if your swap file is being accessed constantly and if it is increasing in size.

As for optimizing MySQL. I'm still trying to find a good guide myself.

One thing you can do is to look at the sample my-large.cnf, my-small.cnf files and adjust to your settings.