Mysql Database SQL优化工具：SQLAdvisor-Oracle&Mysql DBA-51CTO博客
# rpm -ivh epel-release-6-8.noarch.rpm# rpm -ivh percona-release-0.1-4.noarch.rpm
# yum install -y cmake libaio-devel libffi-devel glib2 glib2-devel
# yum install -y Percona-Server-shared-55
# git clone https://github.com/Meituan-Dianping/SQLAdvisor.git
Initialized empty Git repository in /root/SQLAdvisor/.git/
remote: Counting objects: 1460, done.
remote: Total 1460 (delta 0), reused 0 (delta 0), pack-reused 1460
Receiving objects: 100% (1460/1460), 19.92 MiB | 109 KiB/s, done.
Resolving deltas: 100% (368/368), done.
# cd SQLAdvisor
# cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser ./
# make && make install
# cd sqladvisor
# cmake -DCMAKE_BUILD_TYPE=debug ./
# make
# cp sqladvisor /usr/bin
# sqladvisor --help
Usage:
sqladvisor sqladvisor
SQL Advisor Summary
Help Options:
-?, --help Show help options
Application Options:
-f, --defaults-file sqls file
-u, --username username
-p, --password password
-P, --port port
-h, --host host
-d, --dbname database name
-q, --sqls sqls
-v, --verbose 1:output logs 0:output nothing
页:
[1]