Ottertune调优工具介绍

ottertune是数据库参数调优的一个工具，完全开源的，可以帮助开发人员，以及DBA调整相关参数，使得数据库性能达到更优。

ottertune是C/S架构，安装好server端和client端后，server端接受来自client端的优化任务，使用ML模型推荐新的配置到client端，

client端收集关系型数据库的相关信息，并发送优化任务到server端，接受从server端发送过来的新配置。安装在数据库端。

复制一段官方原理介绍，中文见后面链接

OtterTune is comprised of two components:(1) client-side controller and (2) server-side tuning manager

The controller connects to the target DBMS, collects its knob/metric data, transforms the collected information into the universal JSON schema. The tuning manager stores the information in the data repository and schedules a new task with the job scheduler to compute the next configuration for the target DBMS to try. The driver (1) sends the information to the tuning manager, (2) gets a token from the tuning manager, (3) uses this token to check status of the tuning job, and (4) gets the recommended configuration when the job finishes. The driver then installs the new configuration and restarts the target DBMS.

 

 

安装过程见https://github.com/cmu-db/ottertune/wiki/Linux-Quick-Setup

原理见https://mp.weixin.qq.com/s/y8VIieK0LO37SjRRyPhtrw