tailieunhanh - Pro MySQL experts voice in open source phần 4

Tham khảo tài liệu 'pro mysql experts voice in open source phần 4', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 6 BENCHMARKING AND PROFILING 199 to get reliable results. Also note that this suite of tools is not useful for testing your own specific applications because the tools test only a specific set of generic SQL statements and operations. Running All the Benchmarks Running the MySQL benchmark suite of tests is a trivial matter although the tests themselves can take quite a while to execute. To execute the full suite of tests simply run the following cd path to mysqlsrc sql-bench . run-all-tests options Quite a few parameters may be passed to the run-all-tests script. The most notable of these are outlined in Table 6-1. Table 6-1. Parameters for Use with MySQL Benchmarking Test Scripts Option Description --server server name Specifies which database server the benchmarks should be run against. Possible values include MySQL MS-SQL Oracle DB2 mSQL Pg Solid Sybase Adabas AdabasD Access Empress and Informix . --log Stores the results of the tests in a directory specified by the - -dir option defaults to sql-bench output . Result files are named in a format RUN-xxx where xxx is the platform tested for instance sql-bench output . If this looks like a formatted version of uname -a that s because it is. --dir Directory for logging output see - -log . --use-old-result Overwrites any existing logged result output see - -log . --comment A convenient way to insert a comment into the result file indicating the hardware and database server configuration tested. --fast Lets the benchmark framework use non-ANSI-standard SQL commands if such commands can make the querying faster. --host host Very useful option when running the benchmark test from a remote location. Host should be the host address of the remote server where the database is located for instance . --small-test Really handy for doing a short simple test to ensure a new MySQL installation works properly on the server you just installed it on. Instead of running an

TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.