我正在pipe理MySQL服务器进行testing，我想知道是否可以利用机器上的4GB RAM来提高MySQL的性能，而不需要做任何代码修改。
使用MySQLTuner （高性能MySQL优化脚本）。
# wget http://mysqltuner.pl/mysqltuner.pl --2011-01-31 06:49:46-- http://mysqltuner.pl/mysqltuner.pl Resolving mysqltuner.pl... 174.143.142.58 Connecting to mysqltuner.pl|174.143.142.58|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 39054 (38K) [text/plain] Saving to: `mysqltuner.pl' 100%[==============================================================================================================================>] 39,054 54.6K/s in 0.7s 2011-01-31 06:49:49 (54.6 KB/s) - `mysqltuner.pl' saved [39054/39054] # perl mysqltuner.pl >> MySQLTuner 1.0.1 - Major Hayden <[email protected]> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: wget mysqltuner.pl并用perl mysqltuner.pl运行它。 这是海登less校写的build议数据库优化。