筆者英語不好，又沒人翻譯，只好自己動手，希望大家多提意見，我好及時修改，以免誤導他人。本文僅供參考，筆者對使用者產生的任何后果，概不負責。?? 轉載請注明出處！

正文：

The MySQL distribution comes with a rather comprehensive set of generic tests that have been bundled together so you can run them as a group and examine the results. The tests will do little to help you figure out whether a configuration change will speed up your application. But they're very helpful when used as a high-level benchmark, meaning they provide a good overall indication of how well one server performs relative to another.

MySQL分發包捆綁了一套相當全面的系統基準測試工具，這樣你就可以單獨運行他們并檢查測試結果。每次測試的結果對于確定一個配置更改是否會加快您的應用程序幫助不大。但作為一個高層次的基準，他們非常有幫助，這意味著他們提供一個良好的整體性能指示，一臺服務器性能相對于另一臺的整體表現。

You can also run the tests individually if you'd like compare a subset of the results from several servers. If you're mainly interested in UPDATE speed, run one of the UPDATE-intensive tests a few times on each server.

如果你想比較幾臺服務器的性能，可以單獨測試每臺服務器，然后比較測試結果。如果你主要想測試更新速度，每臺服務器上多做幾次更新更密集的測試。

The benchmark suite can be used to test non-MySQL servers as well. According to the README, PostgreSQL, Solid, and mSQL have been tested. This may be helpful if you're trying to choose between MySQL and PostgreSQL. All the benchmark code is relatively generic Perl using the DBI and Benchmark modules. If needed, you can add support for nearly any database server that has a DBI driver (Oracle, Sybase, Informix, DB2, etc.). If you do so, be sure to look at the bench-init.pl for any global options you may need to add or change.

基準套件，也可以用來測試非MySQL服務器。根據自述文件，PostgreSQL，Solid，mSQL的已經過測試。這個測試會對你選擇MySQL或PostgreSQL哪種做為數據庫有所幫助。所有基準的代碼是用相對通用的Perl語言編寫,使用了DBI和基準模塊。如果需要，您可以添加具有DBI驅動程序(ORACLE，SYBASE，Informix和DB2等)幾乎所有的數據庫服務器的支持。如果您這樣做，一定要檢查bench-init.pl文件，尋找任何您可能需要添加或更改的全局選項。

By running the benchmarks against several different servers, you'll get an idea of how much faster one server is than another. The tests are largely CPU-bound, but there are portions of the test that demand a lot of disk I/O (for short times). You'll likely find that the 2.4-GHz CPU doesn't necessarily make MySQL run twice as fast as the 1.2-GHz CPU.

通過對幾個不同的服務器上運行基準測試，你會想要知道一臺服務器比另一種是快多少。測試數據主要是針對CPU的，但也有部分的測試，需求大量的磁盤I / O交換(很短的時間)。您可能會發現，MySQL在2.4 - GHz CPU上的運行速度不一定能達到在1.2 GHz的CPU的運行速度的兩倍。

The benchmark suite will not help you test the benefits of multi-CPU machines because the benchmark process is completely serialized. It executes one query after another, so MySQL will not benefit from the addition of a second CPU. To test that, you'll need to use MySQL super-smack or a home-grown solution. Both are covered in the following sections.

基準套件不能幫助您測試多核CPU的機器，因為基準測試的過程完全序列化。它執行了一個又一個的查詢，所以MySQL不會從第二個CPU中受益。為了測試多核CPU的性能，你需要使用MySQL super-smack或一個手動設計的解決方案。下面的章節將會講到這些。

To run the tests, use the run-all-tests script located in the sql-bench directory. Be sure to read the README in that directory. It provides a complete list of the command-line options you can use.

運行測試，使用位于sql-bench目錄下的run-all-tests測試腳本。請務必閱讀該目錄中的自述。它提供了一個可以使用的命令行選項的完整列表。

總結

以上是生活随笔為你收集整理的mysql基准性能测试标准_mysql性能测试与优化——（一），基准测试套件的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。