# Percona Configuration Wizard

**URL:** <https://forums.percona.com/t/percona-configuration-wizard/3964>\
**Category:** Other MySQL® Questions\
**Created:** [December 24, 2014, 1:07am UTC](https://forums.percona.com/t/percona-configuration-wizard/3964 "2014-12-24T01:07:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsclmumbai](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@rsclmumbai](https://forums.percona.com/u/rsclmumbai)\
**Post date:** [December 24, 2014, 1:07am UTC](https://forums.percona.com/t/percona-configuration-wizard/3964/1 "2014-12-24T01:07:11Z")

</div>

Hi,

OS: CentOS7  
DB: MarianDB  
Storage: InnoDB

I’ve used Percona Configuration Wizard to create my.cnf

I found the following optimization parameters on a few forums, but these are not there in optimization parameters create by Percona Configuration Wizard.

max\_user\_connections = 60  
max\_allowed\_packet = 1M  
max\_connect\_errors = 999999  
table\_cache = 1200 ## max user connections x number of JOINs your heaviest SQL query contains

Trying to understand why the above parameters were ignored.

Advice or pointers are appreciated.

Thanks!

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [December 24, 2014, 12:18pm UTC](https://forums.percona.com/t/percona-configuration-wizard/3964/2 "2014-12-24T12:18:08Z")

</div>

Hi rsclmumbai;

Are you asking why those specific values were not recommended by the Percona Configuration Wizard? If so, see below:

max\_user\_connections = This defaults to zero, meaning unlimited. This is a good setting to have in your config, just make sure it’s high enough to allow for all the connections you need for a specific account.

max\_allowed\_packet = This defaults to 1M, so there is no need to include it unless you want to set it to something other than the default.

max\_connect\_errors = This defaults to 10. If all is going well, connections should not be getting errors. Increasing this to a high value is more of a security risk and simply hides underlying problems that may be causing connections issues.

table\_cache = This was renamed to table\_open\_cache, so it might be in your config already as the new name.

-Scott