I’m currently running mysql 5 on a server with 6GB of RAM and dual Xeon processors and I wish to take full advantage of the box’s horse power.
Right now mysql runs fairly slow and it only occupies about 1GB of the total 6GB memory. I wish to increase its utilization so that some queries run faster (in memory).
Can someone suggest what changes I can make to have mysql utilize more server resources?
(a lot of the queries are Join queries)
I currently have the following lines in my.cfg file:
Anything I can tweak better?