OS Manuals

/usr/bin/mysqlctl

Autoscaling components for Kubernetes

From vitess-21 21.0.6-r4 (enterprise-packages), captured 2026-11-08 by running mysqlctl --help (exit 0). permalink

`mysqlctl` is a command-line client used for managing `mysqld` instances.

It is responsible for bootstrapping tasks such as generating a configuration file for `mysqld` and initializing the instance and its data directory.
The `mysqld_safe` watchdog is utilized when present.
This helps ensure that `mysqld` is automatically restarted after failures.

Usage:
  mysqlctl [command]

Available Commands:
  completion    Generate the autocompletion script for the specified shell
  help          Help about any command
  init          Initializes the directory structure and starts mysqld.
  init_config   Initializes the directory structure, creates my.cnf file, but does not start mysqld.
  position      Compute operations on replication positions
  reinit_config Reinitializes my.cnf file with new server_id.
  shutdown      Shuts down mysqld, without removing any files.
  start         Starts mysqld on an already 'init'-ed directory.
  teardown      Shuts mysqld down and removes the directory.

Flags:
      --alsologtostderr                                             log to standard error as well as files
      --app_idle_timeout duration                                   Idle timeout for app connections (default 1m0s)
      --app_pool_size int                                           Size of the connection pool for app connections (default 40)
      --catch-sigpipe                                               catch and ignore SIGPIPE on stdout and stderr if specified
      --config-file string                                          Full path of the config file (with extension) to use. If set, --config-path, --config-type, and --config-name are ignored.
      --config-file-not-found-handling ConfigFileNotFoundHandling   Behavior when a config file is not found. (Options: error, exit, ignore, warn) (default warn)
      --config-name string                                          Name of the config file (without extension) to search for. (default "vtconfig")
      --config-path strings                                         Paths to search for config files in. (default [/tmp])
      --config-persistence-min-interval duration                    minimum interval between persisting dynamic config changes back to disk (if no change has occurred, nothing is done). (default 1s)
      --config-type string                                          Config file type (omit to infer config type from file extension).
      --db-credentials-file string                                  db credentials file; send SIGHUP to reload this file
      --db-credentials-server string                                db credentials server type ('file' - file implementation; 'vault' - HashiCorp Vault implementation) (default "file")
      --db-credentials-vault-addr string                            URL to Vault server
      --db-credentials-vault-path string                            Vault path to credentials JSON blob, e.g.: secret/data/prod/dbcreds
      --db-credentials-vault-role-mountpoint string                 Vault AppRole mountpoint; can also be passed using VAULT_MOUNTPOINT environment variable (default "approle")
      --db-credentials-vault-role-secretidfile string               Path to file containing Vault AppRole secret_id; can also be passed using VAULT_SECRETID environment variable
      --db-credentials-vault-roleid string                          Vault AppRole id; can also be passed using VAULT_ROLEID environment variable
      --db-credentials-vault-timeout duration                       Timeout for vault API operations (default 10s)
      --db-credentials-vault-tls-ca string                          Path to CA PEM for validating Vault server certificate
      --db-credentials-vault-tokenfile string                       Path to file containing Vault auth token; token can also be passed using VAULT_TOKEN environment variable
      --db-credentials-vault-ttl duration                           How long to cache DB credentials from the Vault server (default 30m0s)
      --db_charset string                                           Character set/collation used for this tablet. Make sure to configure this to a charset/collation supported by the lowest MySQL version in your environment. (default "utf8mb4")
      --db_conn_query_info                                          enable parsing and processing of QUERY_OK info fields
      --db_connect_timeout_ms int                                   connection timeout to mysqld in milliseconds (0 for no timeout)
      --db_dba_password string                                      db dba password
      --db_dba_use_ssl                                              Set this flag to false to make the dba connection to not use ssl (default true)
      --db_dba_user string                                          db dba user userKey (default "vt_dba")
      --db_flags uint                                               Flag values as defined by MySQL.
      --db_flavor string                                            Flavor overrid. Valid value is FilePos.
      --db_host string                                              The host name for the tcp connection.
      --db_port int                                                 tcp port
      --db_server_name string                                       server name of the DB we are connecting to.
      --db_socket string                                            The unix socket to connect on. If this is specified, host and port will not be used.
      --db_ssl_ca string                                            connection ssl ca
      --db_ssl_ca_path string                                       connection ssl ca path
      --db_ssl_cert string                                          connection ssl certificate
      --db_ssl_key string                                           connection ssl key
      --db_ssl_mode SslMode                                         SSL mode to connect with. One of disabled, preferred, required, verify_ca & verify_identity.
      --db_tls_min_version string                                   Configures the minimal TLS version negotiated when SSL is enabled. Defaults to TLSv1.2. Options: TLSv1.0, TLSv1.1, TLSv1.2, TLSv1.3.
      --dba_idle_timeout duration                                   Idle timeout for dba connections (default 1m0s)
      --dba_pool_size int                                           Size of the connection pool for dba connections (default 20)
  -h, --help                                                        help for mysqlctl
      --keep_logs duration                                          keep logs for this long (using ctime) (zero to keep forever)
      --keep_logs_by_mtime duration                                 keep logs for this long (using mtime) (zero to keep forever)
      --lameduck-period duration                                    keep running at least this long after SIGTERM before stopping (default 50ms)
      --log_backtrace_at traceLocations                             when logging hits line file:N, emit a stack trace
      --log_dir string                                              If non-empty, write log files in this directory
      --log_err_stacks                                              log stack traces for errors
      --log_rotate_max_size uint                                    size in bytes at which logs are rotated (glog.MaxSize) (default 1887436800)
      --logtostderr                                                 log to standard error instead of files
      --max-stack-size int                                          configure the maximum stack size in bytes (default 67108864)
      --mysql_port int                                              MySQL port. (default 3306)
      --mysql_server_version string                                 MySQL server version to advertise. (default "8.0.30-Vitess")
      --mysql_socket string                                         Path to the mysqld socket file.
      --mysqlctl_client_protocol string                             the protocol to use to talk to the mysqlctl server (default "grpc")
      --mysqlctl_mycnf_template string                              template file to use for generating the my.cnf file during server init
      --mysqlctl_socket string                                      socket file to use for remote mysqlctl actions (empty for local actions)
      --onclose_timeout duration                                    wait no more than this for OnClose handlers before stopping (default 10s)
      --onterm_timeout duration                                     wait no more than this for OnTermSync handlers before stopping (default 10s)
      --pid_file string                                             If set, the process will write its pid to the named file, and delete it on graceful shutdown.
      --pool_hostname_resolve_interval duration                     if set force an update to all hostnames and reconnect if changed, defaults to 0 (disabled)
      --pprof strings                                               enable profiling
      --pprof-http                                                  enable pprof http endpoints
      --purge_logs_interval duration                                how often try to remove old logs (default 1h0m0s)
      --replication_connect_retry duration                          how long to wait in between replica reconnect attempts. Only precise to the second. (default 10s)
      --security_policy string                                      the name of a registered security policy to use for controlling access to URLs - empty means allow all for anyone (built-in policies: deny-all, read-only)
      --service_map strings                                         comma separated list of services to enable (or disable if prefixed with '-') Example: grpc-queryservice
      --socket_file string                                          Local unix socket file to listen on
      --stderrthreshold severityFlag                                logs at or above this threshold go to stderr (default 1)
      --table-refresh-interval int                                  interval in milliseconds to refresh tables in status page with refreshRequired class
      --tablet_dir string                                           The directory within the vtdataroot to store vttablet/mysql files. Defaults to being generated by the tablet uid.
      --tablet_uid uint32                                           Tablet UID. (default 41983)
      --v Level                                                     log level for V logs
  -v, --version                                                     print binary version
      --vmodule vModuleFlag                                         comma-separated list of pattern=N settings for file-filtered logging

Use "mysqlctl [command] --help" for more information about a command.
Options (75)
OptionDescriptionSource
--alsologtostderrlog to standard error as well as fileshelp
--app_idle_timeout durationIdle timeout for app connections (default 1m0s)help
--app_pool_size intSize of the connection pool for app connections (default 40)help
--catch-sigpipecatch and ignore SIGPIPE on stdout and stderr if specifiedhelp
--config-file stringFull path of the config file (with extension) to use.help
--config-file-not-found-handling ConfigFileNotFoundHandlingBehavior when a config file is not found.help
--config-name stringName of the config file (without extension) to search for.help
--config-path stringsPaths to search for config files in.help
--config-persistence-min-interval durationminimum interval between persisting dynamic config changes back to disk (if no change has occurred, nothing is done).help
--config-type stringConfig file type (omit to infer config type from file extension).help
--db-credentials-file stringdb credentials file;help
--db-credentials-server stringdb credentials server type ('file' - file implementation;help
--db-credentials-vault-addr stringURL to Vault serverhelp
--db-credentials-vault-path stringVault path to credentials JSON blob, e.g.: secret/data/prod/dbcredshelp
--db-credentials-vault-role-mountpoint stringVault AppRole mountpoint;help
--db-credentials-vault-role-secretidfile stringPath to file containing Vault AppRole secret_id;help
--db-credentials-vault-roleid stringVault AppRole id;help
--db-credentials-vault-timeout durationTimeout for vault API operations (default 10s)help
--db-credentials-vault-tls-ca stringPath to CA PEM for validating Vault server certificatehelp
--db-credentials-vault-tokenfile stringPath to file containing Vault auth token;help
--db-credentials-vault-ttl durationHow long to cache DB credentials from the Vault server (default 30m0s)help
--db_charset stringCharacter set/collation used for this tablet.help
--db_conn_query_infoenable parsing and processing of QUERY_OK info fieldshelp
--db_connect_timeout_ms intconnection timeout to mysqld in milliseconds (0 for no timeout)help
--db_dba_password stringdb dba passwordhelp
--db_dba_use_sslSet this flag to false to make the dba connection to not use ssl (default true)help
--db_dba_user stringdb dba user userKey (default "vt_dba")help
--db_flags uintFlag values as defined by MySQL.help
--db_flavor stringFlavor overrid.help
--db_host stringThe host name for the tcp connection.help
--db_port inttcp porthelp
--db_server_name stringserver name of the DB we are connecting to.help
--db_socket stringThe unix socket to connect on.help
--db_ssl_ca stringconnection ssl cahelp
--db_ssl_ca_path stringconnection ssl ca pathhelp
--db_ssl_cert stringconnection ssl certificatehelp
--db_ssl_key stringconnection ssl keyhelp
--db_ssl_mode SslModeSSL mode to connect with.help
--db_tls_min_version stringConfigures the minimal TLS version negotiated when SSL is enabled.help
--dba_idle_timeout durationIdle timeout for dba connections (default 1m0s)help
--dba_pool_size intSize of the connection pool for dba connections (default 20)help
-h, --helphelp for mysqlctlhelp
--keep_logs durationkeep logs for this long (using ctime) (zero to keep forever)help
--keep_logs_by_mtime durationkeep logs for this long (using mtime) (zero to keep forever)help
--lameduck-period durationkeep running at least this long after SIGTERM before stopping (default 50ms)help
--log_backtrace_at traceLocationswhen logging hits line file:N, emit a stack tracehelp
--log_dir stringIf non-empty, write log files in this directoryhelp
--log_err_stackslog stack traces for errorshelp
--log_rotate_max_size uintsize in bytes at which logs are rotated (glog.MaxSize) (default 1887436800)help
--logtostderrlog to standard error instead of fileshelp
--max-stack-size intconfigure the maximum stack size in bytes (default 67108864)help
--mysql_port intMySQL port.help
--mysql_server_version stringMySQL server version to advertise.help
--mysql_socket stringPath to the mysqld socket file.help
--mysqlctl_client_protocol stringthe protocol to use to talk to the mysqlctl server (default "grpc")help
--mysqlctl_mycnf_template stringtemplate file to use for generating the my.cnf file during server inithelp
--mysqlctl_socket stringsocket file to use for remote mysqlctl actions (empty for local actions)help
--onclose_timeout durationwait no more than this for OnClose handlers before stopping (default 10s)help
--onterm_timeout durationwait no more than this for OnTermSync handlers before stopping (default 10s)help
--pid_file stringIf set, the process will write its pid to the named file, and delete it on graceful shutdown.help
--pool_hostname_resolve_interval durationif set force an update to all hostnames and reconnect if changed, defaults to 0 (disabled)help
--pprof stringsenable profilinghelp
--pprof-httpenable pprof http endpointshelp
--purge_logs_interval durationhow often try to remove old logs (default 1h0m0s)help
--replication_connect_retry durationhow long to wait in between replica reconnect attempts.help
--security_policy stringthe name of a registered security policy to use for controlling access to URLs - empty means allow all for anyone (built-in policies: deny-all, read-only)help
--service_map stringscomma separated list of services to enable (or disable if prefixed with '-') Example: grpc-queryservicehelp
--socket_file stringLocal unix socket file to listen onhelp
--stderrthreshold severityFlaglogs at or above this threshold go to stderr (default 1)help
--table-refresh-interval intinterval in milliseconds to refresh tables in status page with refreshRequired classhelp
--tablet_dir stringThe directory within the vtdataroot to store vttablet/mysql files.help
--tablet_uid uint32Tablet UID.help
--v Levellog level for V logshelp
-v, --versionprint binary versionhelp
--vmodule vModuleFlagcomma-separated list of pattern=N settings for file-filtered logginghelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.