86 lines
2.6 KiB
Plaintext
86 lines
2.6 KiB
Plaintext
# ----------------------------------------------------
|
|
# ---
|
|
# - Parameter Settings for Script 'optimize_mysql_tables.sh'
|
|
# ---
|
|
# ----------------------------------------------------
|
|
|
|
|
|
# - MySQL / MariaDB / Percona credentials
|
|
|
|
# - basename_mysql_daemon
|
|
# -
|
|
# - (Base)Name of the MySQL Daemon
|
|
# -
|
|
# - Example
|
|
# - basename_mysql_daemon=mysqld
|
|
# - basename_mysql_daemon=mariadbd
|
|
# -
|
|
# - Defaults to
|
|
# - basename_mysql_daemon=mysqld
|
|
# -
|
|
#basename_mysql_daemon=mysqld
|
|
|
|
# - mysql_credential_args
|
|
# -
|
|
# - Giving password on command line is insecure an sind mysql 5.5
|
|
# - you will get a warning doing so.
|
|
# -
|
|
# - Reading username/password fro file ist also possible, using MySQL/MariaDB
|
|
# - commandline parameter '--defaults-file'.
|
|
# -
|
|
# - Since Version 5.6, that method is considered as insecure.
|
|
# - To avoid giving the password on command line, we use an
|
|
# - encrypted option file
|
|
# -
|
|
# - Create (encrypted) option file:
|
|
# - $ mysql_config_editor set --login-path=local --socket=/var/run/mysqld/mysqld.sock --user=backup --password
|
|
# - $ Password:
|
|
# -
|
|
# - Use of option file:
|
|
# - $ mysql --login-path=local ...
|
|
# -
|
|
# - Example
|
|
# - mysql_credential_args="--login-path=local"
|
|
# - mysql_credential_args="--defaults-file=/etc/mysql/debian.cnf" (Debian default)
|
|
# - mysql_credential_args="--defaults-file=/usr/local/mysql/sys-maint.cnf"
|
|
# -
|
|
# - # MariaDB 10.4.x
|
|
# - mysql_credential_args="-u root -S /tmp/mysql.sock"
|
|
# -
|
|
# - Defaults to mysql_credential_args="--login-path=local"
|
|
# -
|
|
#mysql_credential_args="--login-path=local"
|
|
|
|
|
|
# - mysql_credential_args_arr
|
|
# -
|
|
# - If multiple MySQL / MariaDB / Percona Installations are present, for each installation,
|
|
# - you can give its own credentials.
|
|
# -
|
|
# - Note:
|
|
# - If this parameter ist present, the parameter 'mysql_credential_args' will be ignored.
|
|
# -
|
|
# - Examples:
|
|
# - mysql_credential_args_arr=("MariaDB 10.2.13:--defaults-file=/etc/mysql/debian.cnf "5.7:--login-path=local")
|
|
# - msql_credential_args_arr=("5.6:--login-path=local-5.6" "5.7:--login-path=local")
|
|
# - mysql_credential_args_arr=(
|
|
# - "5.7:--login-path=local"
|
|
# - "5.6:--login-path=mysql-5.6"
|
|
# - "8.0:--login-path=mysql-8.0"
|
|
# - "MariaDB 10.3:--defaults-file=/usr/local/mariadb-10.3.12/sys-maint.cnf"
|
|
# - "MariaDB 10.4:-u root -S /tmp/mariadb-10.4.6.sock"
|
|
# - )
|
|
# -
|
|
# - Note:
|
|
# - the first value (before the colon ':') is only used for logging output and has no
|
|
# - further relevance .
|
|
# -
|
|
#mysql_credential_args_arr=""
|
|
|
|
|
|
# - log_file - only available for optimize_tables script
|
|
# -
|
|
# - Defaults to "/var/log/${script_name%%.*}.log"
|
|
# -
|
|
#log_file="/var/log/optimize_mysql_tables.log"
|