Hi All,

I was looking at my server the over the weekend and realised how little of my memory resources were being used. My server has 1GB of ram, of which Windows is only reporting that around 256MB is actually in use. MySQL uses the most, but still from an out of the box install only uses about 18MB.

As I have so much RAM resource free, I was wondering if there were any changes to the MySQL variables that I could make to increase the performance of the MySQL server? Ideally I would've thought you want to keep IO usage to an absolute minimum (only writes for DB updates, and reads for data caching), and if possible use as much memory for caching and the like to maximising performance.

Am I right in thinking MySQL tuning will bring noticeable performance gains to Xoops? If so, what variables should be changed, and a roughly changed to what?