Skip to main content

Automated optimizer for MySQL InnoDB configurations

Project description

Pypi MIT licensed GitHub Release Date

innodb-optimize is a package for automatically calucalating optimized InnoDB configurations, and generating an updated my.cnf file with those values.


# PyPi Installation
pip install innodb-optimize
# GitHub Installation
pip install git+''


Basic Output

The following command will output the generated configuration to STDOUT. This is useful when using this tool in other scripts, such as automating system deployments.


Standard Commit Loop

The --commit flag should be included for an interactive run. The user is first asked whether the configuration should be saved; there is an option to print the generated config to console.
If the configuration is read, the user is prompted for the same question.
If the configuration is saved, the user is prompted to restart MySQL; there is an option to schedule the restart using bash’s at program.
innodb-optimize --commit
Standard Loop

Standard Loop

Available Arguments

  • file: Where the MySQL configuration file is located. Defaults to /etc/mysql/my.cnf.

  • percent: Determines what percentage of the total memory will be devoted to InnoDB engine usage. Defaults to 75%.

  • memory: Allows the user to override the total memory amount (i.e. a fixed amount is already pre-allocated which is not easily accounted for in percentages). Only allows for kilobyte unit.

  • commit: Is required to start the loop which will commit the changes. Without it, the program only outputs the config to standard out to allow for piping/redirecting the output as needed.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

innodb_optimize-0.2.1-py3.8.egg (5.1 kB view hashes)

Uploaded 3 8

innodb_optimize-0.2.1-py3-none-any.whl (5.9 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page