MySql 服務 CPU LOADING 突然衝高？

剛剛例行公事的，打開瀏覽器都順便帶起學校網站，順便看看情況，沒想到出現：

 

連結XX資料庫有問題，沒有下列資料庫...XXX....

 

Oh ！ Man，不會網站又掛掉了吧， 趕快連回主機，進主機後一看，CPU LOADING超高.....心想，不會被砍站吧？

先把 MYSQL SERVICE 關掉， 查一下LOG，暫時沒發現異狀。突然想到這個網站：

http://www.day32.com/MySQL/

 

來測試一下，目前MySQL設定是否OK。

MySQL Performance Tuning Primer Script

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." 
to produce sane recomendations for tuning server variables. 
It is compatable with all versions of MySQL 3.23 and higher (including 5.1).

Currently it handles recomendations for the following:

Slow Query Log

Max Connections

Worker Threads

Key Buffer

Query Cache

Sort Buffer

Joins

Temp Tables

Table (Open & Definition) Cache

Table Locking

Table Scans (read_buffer)

Innodb Status

Recent Changes

下載到主機後，執行他後，很快就跑出一些訊息，

 

Warning: Server has not been running for at least 48hrs. It may not be safe to use these recommendations

 

恩~~好吧!!!等過幾天跑久一點，再來試看看好了