Automated optimizer for MySQL InnoDB configurations
Project description
innodb-optimize is a package for automatically calucalating optimized InnoDB configurations, and generating an updated my.cnf file with those values.
Installation
# PyPi Installation
pip install innodb-optimize
# GitHub Installation
pip install git+'https://github.com/Scraps23/innodb_optimize.git'Usage
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.
innodb-optimizeStandard Commit Loop
innodb-optimize --commit
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.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Hashes for innodb_optimize-0.2.1-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 6e940d0306fd07cbc93441832527dfaefca2db1f9150562ff69ddbeb0b0e594f |
|
| MD5 | af92e1bd4aafbf1e2aa35aa70fbaccd1 |
|
| BLAKE2b-256 | 14d1c03bb8643eb5d6779d245a68e222fcbf917d05f0ca533d78705a96a8c72e |
