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-optimize
Standard Commit Loop
innodb-optimize --commit
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
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.1.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a0dfd3086f420fe98ebdde1cd6ebfffc65d62afc49b2334db01f92fe33309922 |
|
MD5 | 171a5bdbdcbc5bd16a12659f4bb95e1b |
|
BLAKE2b-256 | df54e9d142dff6251bfb5a217b45d2b9e5faad897ecbe209e04397e057e3cf74 |