<div>
mwvisa1,<br />
Sorry for the delayed response.<br />
&nbsp;<br />
I have followed the guidelines in the links that you provided, but my server still never reports higher than 20% usage of available memory. I wonder what parameter should I modify to increase this number.<br />
<br />
Thank you for your help!
</div>


mwvisa1,
Sorry for the delayed response.
 
I have followed the guidelines in the links that you provided, but my server still never reports higher than 20% usage of available memory. I wonder what parameter should I modify to increase this number.

Thank you for your help!

<div>
What is your new my.ini file look like? Please upload as an attachment.
</div>


What is your new my.ini file look like? Please upload as an attachment.

<div>
I have resolved the issue. Your original suggestion was very helpful. Thank you!
</div>


I have resolved the issue. Your original suggestion was very helpful. Thank you!

<div>
<div class="content wysiwyg-content">
I have installed the latest version of the MySQL Server on a 64bit windows 7 pc with 8GB of RAM. I have subsequently updated the RAM to 16GB.<br />
<br />
I am currently testing a significant dataset stored in about 10 tables, with about 100GB worth of data. The tables are configured to use InnoDB.<br />
<br />
The queries involve many nested SELECT, JOIN and GROUP BY clauses. No inserts. No updates. <br />
<br />
Questions:<br />
1. how can I utilize all 16GB of RAM to improve the query performance?<br />
2. will the performance increase if I switch to another MySQL Engine (other than InnoDB)?<br />
<br />
Thank you, experts!
</div>
</div>


I have installed the latest version of the MySQL Server on a 64bit windows 7 pc with 8GB of RAM. I have subsequently updated the RAM to 16GB.

I am currently testing a significant dataset stored in about 10 tables, with about 100GB worth of data. The tables are configured to use InnoDB.

The queries involve many nested SELECT, JOIN and GROUP BY clauses. No inserts. No updates. 

Questions:
1. how can I utilize all 16GB of RAM to improve the query performance?
2. will the performance increase if I switch to another MySQL Engine (other than InnoDB)?

Thank you, experts!

MySQL RAM Memory Configuration

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.