# How to Set best performance parameters **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [December 30, 2011, 5:23am UTC](https://forums.percona.com/t/how-to-set-best-performance-parameters/1729 "2011-12-30T05:23:51Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![michaelk](https://avatars.discourse-cdn.com/v4/letter/m/ccd318/32.png) [@michaelk](https://forums.percona.com/u/michaelk)\ **Post date:** [December 30, 2011, 5:23am UTC](https://forums.percona.com/t/how-to-set-best-performance-parameters/1729/1 "2011-12-30T05:23:51Z")
Please help me to configure MYSQL server over below details. 1. 30 tables- 15 InnoDB / 15 MyISAM 2. 2 important InnoDB tables handles more than 1.5 million records in each table per month. data types are mostly strings and integers. these two tables will join with serveral other table to provide more than 40 reports to the management daily not only that all the transactions are done on these two tables daily. 3. more than 80 users handle transactions daily. 4. 2008 Windows Server / 8 GB Ram / 40 GB in C and 500 GB in D drive to hadle all images and other billing docs. How to set InnoDB parameters and MyISAM parameters to suit the best performance and traffic . ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [December 30, 2011, 12:59pm UTC](https://forums.percona.com/t/how-to-set-best-performance-parameters/1729/2 "2011-12-30T12:59:04Z")
There is lots of documentation available. For which parameters are you in doubt? ---
**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\ **Post date:** [January 16, 2012, 2:52pm UTC](https://forums.percona.com/t/how-to-set-best-performance-parameters/1729/3 "2012-01-16T14:52:04Z")
Try [URL][MySQL Tools and Management Software to Perform System Tasks by Percona](http://tools.percona.com/%5B/URL%5D)