Automated optimizer for MySQL InnoDB configurations
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+'https://github.com/Scraps23/innodb_optimize.git'
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
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.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for innodb_optimize-0.2.1-py3-none-any.whl