tuning-primer.sh是一個mysql的腳本
官網(wǎng): https://launchpad.net/mysql-tuning-primer/
百度搜索的文檔不是從這個網(wǎng)站下載的，具體的不清楚，小松感覺這個網(wǎng)站比較靠譜，右邊綠色的按鈕下載
或者用wget下載

<pre class="prettyprint linenums prettyprinted" style="padding: 8px; font: 400 12px/20px "courier new"; color: rgb(248, 248, 212); border-radius: 0px; display: block; margin: 20px 0px; word-break: break-all; overflow-wrap: break-word; white-space: pre-wrap; background: rgb(39, 40, 34); border: 1px solid rgb(39, 40, 34); overflow: hidden; box-shadow: rgb(57, 56, 46) 40px 0px 0px inset, rgb(70, 71, 65) 41px 0px 0px inset; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">

1. wget https://launchpad.net/mysql-tuning-primer/trunk/1.6-r1/+download/tuning-primer.sh

</pre>

將tuning-primer.sh拷貝到my.cnf同級目錄，我的目錄在my.cnf在/etc目錄下

<pre class="prettyprint linenums prettyprinted" style="padding: 8px; font: 400 12px/20px "courier new"; color: rgb(248, 248, 212); border-radius: 0px; display: block; margin: 20px 0px; word-break: break-all; overflow-wrap: break-word; white-space: pre-wrap; background: rgb(39, 40, 34); border: 1px solid rgb(39, 40, 34); overflow: hidden; box-shadow: rgb(57, 56, 46) 40px 0px 0px inset, rgb(70, 71, 65) 41px 0px 0px inset; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">

1. cp tuning-primer.sh /etc

2. chmod +x tuning-primer.sh

3. cd /etc

4. ./tuning-primer.sh

</pre>

執(zhí)行出現(xiàn)如下錯誤

<pre class="prettyprint linenums prettyprinted" style="padding: 8px; font: 400 12px/20px "courier new"; color: rgb(248, 248, 212); border-radius: 0px; display: block; margin: 20px 0px; word-break: break-all; overflow-wrap: break-word; white-space: pre-wrap; background: rgb(39, 40, 34); border: 1px solid rgb(39, 40, 34); overflow: hidden; box-shadow: rgb(57, 56, 46) 40px 0px 0px inset, rgb(70, 71, 65) 41px 0px 0px inset; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">

1. Using login values from ~/.my.cnf

2. • INITIAL LOGIN ATTEMPT FAILED -

3. Testing for stored webmin passwords:

4. None Found

5. Could not auto detect login info!

6. Found potential sockets: /tmp/mysql.sock

7. Using: /tmp/mysql.sock

8. Would you like to provide a different socket?: [y/N] n

9. Do you have your login handy ? [y/N] : y

10. User: root

11. Password: 123456

12. Would you like me to create a ~/.my.cnf file for you? [y/N] : n

13. • FINAL LOGIN ATTEMPT FAILED -

14. Unable to log into socket: /tmp/mysql.sock

</pre>

問題是
mysqladmin 命令根本就沒有，需要帶上路徑，修改一下腳本，
224行

<pre class="prettyprint linenums prettyprinted" style="padding: 8px; font: 400 12px/20px "courier new"; color: rgb(248, 248, 212); border-radius: 0px; display: block; margin: 20px 0px; word-break: break-all; overflow-wrap: break-word; white-space: pre-wrap; background: rgb(39, 40, 34); border: 1px solid rgb(39, 40, 34); overflow: hidden; box-shadow: rgb(57, 56, 46) 40px 0px 0px inset, rgb(70, 71, 65) 41px 0px 0px inset; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">

1. mysqladmin="mysqladmin -S (cat /etc/psa/.psa.shadow)"
2. 修改成
3. mysqladmin="/usr/local/mysql/bin/mysqladmin -S (cat /etc/psa/.psa.shadow)"

</pre>

227行

<pre class="prettyprint linenums prettyprinted" style="padding: 8px; font: 400 12px/20px "courier new"; color: rgb(248, 248, 212); border-radius: 0px; display: block; margin: 20px 0px; word-break: break-all; overflow-wrap: break-word; white-space: pre-wrap; background: rgb(39, 40, 34); border: 1px solid rgb(39, 40, 34); overflow: hidden; box-shadow: rgb(57, 56, 46) 40px 0px 0px inset, rgb(70, 71, 65) 41px 0px 0px inset; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">

1. mysqladmin="/usr/local/mysql/bin/mysqladmin"
2. 修改成
3. mysqladmin="mysqladmin"

</pre>

在執(zhí)行tuning-primer.sh腳本的時候就沒有問題了

生成的報告會有建議，根據(jù)自己的實際情況來修改

下面是我報告的截圖，報告很長,可仔細看一下

[圖片上傳失敗...(image-d30b52-1573309202929)]