Not the answer you need?
Register and ask your own question!

Percona Configuration Wizard

rsclmumbairsclmumbai EntrantInactive User Role Beginner
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!

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.