获取帮助

启动调优程序之前,可以通过如下命令获取帮助信息:

  1. gs_xtuner --help

输出帮助信息结果如下:

  1. usage: gs_xtuner [-h] [--db-name DB_NAME] [--db-user DB_USER] [--port PORT]
  2. [--host HOST] [--host-user HOST_USER]
  3. [--host-ssh-port HOST_SSH_PORT] [-f DB_CONFIG_FILE]
  4. [-x TUNER_CONFIG_FILE] [-v]
  5. {train,tune,recommend}
  6. X-Tuner: a self-tuning tool integrated by openGauss.
  7. positional arguments:
  8. {train,tune,recommend}
  9. Train a reinforcement learning model or tune database
  10. by model. And also can recommend best_knobs according
  11. to your workload.
  12. optional arguments:
  13. -h, --help show this help message and exit
  14. -f DB_CONFIG_FILE, --db-config-file DB_CONFIG_FILE
  15. You can pass a path of configuration file otherwise
  16. you should enter database information by command
  17. arguments manually. Please see the template file
  18. share/server.json.template.
  19. -x TUNER_CONFIG_FILE, --tuner-config-file TUNER_CONFIG_FILE
  20. This is the path of the core configuration file of the
  21. X-Tuner. You can specify the path of the new
  22. configuration file. The default path is xtuner.conf.
  23. You can modify the configuration file to control the
  24. tuning process.
  25. -v, --version show program's version number and exit
  26. Database Connection Information:
  27. --db-name DB_NAME The name of database where your workload running on.
  28. --db-user DB_USER Use this user to login your database. Note that the
  29. user must have sufficient permissions.
  30. --port PORT Use this port to connect with the database.
  31. --host HOST The IP address of your database installation host.
  32. --host-user HOST_USER
  33. The login user of your database installation host.
  34. --host-ssh-port HOST_SSH_PORT
  35. The SSH port of your database installation host.