Sample Header Ad - 728x90

WAMP server performance tuning for MySQL

7 votes
2 answers
15748 views
We have a Drupal site with nearly 2000 pages running on [WAMP server](http://www.wampserver.com/en/) . The pages also contain images, and flash videos embedded into them. So, they are taking some time to load under normal settings. Nearly 200-300 users are expected to use the system concurrently (the number is expected to grow later). The dev server (on our company intranet) has 16 GB RAM, and runs Windows7 - 64 bit OS. I can see that in wamp/bin/mysql/mysql5.5.16/ has files 1. my.ini 2. my-huge.ini 3. my-innodb-heavy-4G.ini I had a look into both of them, and I am not sure what is the purpose of each one of them and which one is used by my the WAMP server currently. Also, I needed to know the difference in using my-huge.ini and my-innodb-heavy-4G.ini. I have also configured Apache SOLR for indexing the search (I don't know if this is relevant). P.S : Drupal stores pages (along with the link to images and videos) into the database and images and other media are stored in folder under the site root.
Asked by Ajit S (187 rep)
May 31, 2012, 07:48 AM
Last activity: Dec 29, 2020, 01:41 AM