Swingbench for oracleRAC usage illustration, swingbench

Swingbench for oracleRAC usage illustration, swingbench
Swingbench for oracleRAC usage illustration

1 Swingbench
1.1 Overview
This isOracleAn employee of UK developed on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge and can be freely downloaded from the author's website and has detailed user guides. In addition to Swingbench, the author also developed two related tools:TestData Generation Tool DataGenerator and Trace Analyzer.
Swingbench can be used to perform four different benchmark tests. It has three front-end display Methods: Swingbench, Charbench, and Minibench. Charbench is in character mode, and the other two are in GUI mode. In addition, you can use ClusterOverview to aggregate all the results. Swingbench is mainly used to displayRACBut it can also be used in a single instance environment. The latest version 2.3 starts to support TimesTen memory.Database.
: Http://www.dominicgiles.com/downloads.html
Author blog: http://www.dominicgiles.com/blog/blog.html

Currently, open-source oracle stress testing tools on the network are mainly orabm and swingbench. Because orabm does not support oracle 11g, this test uses swingben for stress testing. In addition, swingbench can also test rac. Swingbench is an oracle stress testing tool developed by UK-based oracle Database Solutions group. It seems that it is an officially abandoned project. The latest software license can be downloaded on the official page http://dominicgiles.com/swingbench.html. Swingbench can run on windows and linux platforms. This example uses windows as an example.

 

2. Environment Configuration

JDK must be installed on the test client, and oracle client is not required.

The swingbench version is 2.4. decompress the software package directly and decompress the package as follows. Because it is a test in windows, use the batch files in the winbin directory.

 

The following four bat files are used:

 

The main functions of bat files are as follows:

1. bmcompare is used to compare the test results

2. ccwizard is the running test data created using the CC seed as the template

3. clusteroverview is used to start the stress test of the cluster and view the test result.

4. coordinator is used to start the coordination server.

5. minibench is used to register nodes to the Coordination server.

6. oewizard uses the OE seed as the template to create run test data

7. Create run test data using the SH seed as the template.

8. swingbench performs benchmark testing.

 

3. Test

3.1 create Test Data

Swingbench does not use customer data, but creates test data according to its own rules. (The generated test data can only be used once. If you need to perform another test after the test, you need to recreate the test data, this is not good)

Run the oewizard. bat batch file in the target directory. You can also run the oewizard. bat batch file in the directory.

The following page is displayed:

Next step

Next, enter the database // ip/sid you want to test and the password of the sys user.

Next, you do not need to modify the first three items. You only need to modify the storage path of datafile for the schema automatically created by swingbench.

Next, select a minimum data volume of 100 M and a maximum of 1 TB to create data. It usually takes 4-7 hours to select 100 GB (related to your hardware I/O performance)

PS: During the test, it is necessary to determine that there is no impact on the production database. The swingbench test will occupy a large amount of IO. I use the new storage of the new core system, and the old environment is completely independent, therefore, the swingbench test has no impact on the old production environment.

Next,

Next, data is inserted. The data size of GB is about 7 hours.

 

4. Start swingbench Configuration

4.1 run coordinator-g in the Winbin directory to start the coordination server, as shown below:

 

4.2 start swingbench and configure relevant stress test parameters

 

The main parameters on the main interface are configured with the corresponding connect string. Create Appendix A for other parameters.

Set the parameters in the vhfs1 node circle on the graph. Node 2 performs the same operation.

When you enable ssh for the database OS, you can collect the cpu disk IO information of the host.

You can also pull out AWR reports.

Set the insert, update, and select ratios.

Click Save to exit.

 

4.3 register a node to the registration server

 

Run the following command:

C: \ swingbench \ winbin> minibench-g vhfs1-cs 192.192.5.107: 1521: vhfs1-co test &

C: \ swingbench \ winbin> minibench-g vhfs2-cs 192.192.5.107: 1521: vhfs2-co test &

 

Command Parameters

-G parameter refers to the group,

-The cs parameter specifies the test source,

-The coordinatorServer parameter specifies the coordinatorServer. The local host name is test and the default value is localhost.

 

5. Test

Run./clusteroverview to test and start the database connection between the two nodes of oracleRAC in sequence.

 

The stress test results are as follows,

 

 

6,Comparison of test results

The result is an XML document.

 

 

 

You can use bmcompare. bat to compare the two test results. The syntax and results are produced locally.

C: \ swingbench \ winbin> bmcompare. bat-r results00003 results00013

 

 

 

 

Appendix:

Test parameters of A and swingbench

1. users: thenumber of users (threads) on swingbench GUI that attach to a database and the amount and tye ofwork they perform. users can dynamically monitor the responsetimes and loadwhich is displayed in a series of graphs.
Here, users controls the number of users connected to oracle at the same time. We know that every user connected to oracle will be assigned a PGA, so here it should be understood as a degree of parallelism.
2. min/max think time: Minimum/large time for thinking between each transaction. If min think time is set, the specified time interval is used between each transaction.
3. max trans: If set, the maximum number of transactions is limited.
4. the top transaction panel: load: Indicates the "weight" of the transaction incomparison to othe transactions. A higher weight indicates that itmore likely to be run.
This Panel can be used to cancel some fixed transaction types. The load column is mainly used to adjust the weights of some transactions in the test. For example, browse product is mainly a select statement, which can increase its weight to indicate more people to query.
Several parameters in oewizard:
Number of Customers: Number of users pre-loaded to the database table.
Number of Orders: Number of Orders pre-loaded to the database table.
The whole OE test is based on nine tables. Is the test result different when oewizard is used to pre-load different data volumes?
For oracle itself, there is no difference in the performance of indexed tables when the size is certain, but when the number of rows in a table reaches a certain level, such as hundreds of millions of rows, the index performance is not as good as the full table scan performance. Therefore, for the scope allowed by OE, I think the table data size has no significant impact on performance.
Swingbench is a stress testing tool. The result tpmc also indicates the number of transactions per minute. If more data is pre-loaded and all types of weights in TX are fixed, adjust the number of parallel users to obtain an optimal tpms value. According to my previous test results, the parallel user is fixed, and the more data is pre-loaded, the smaller the result of the tpmc is, I am also confused. After careful analysis, I found that, the number of parallel users should be modified accordingly.
By modifying the weight of each transaction type in the TX panel, you can also obtain some oracle performance parameters, such as increasing the query, if the value of tpmc is similar, this shows that the query capability of this database is good.

B. Introduction to TPMC

According to the definition of TPC, the traffic indicator describes how many New-Order transactions can be processed per minute while the system executes the four types of transactions: Payment, Order-status, Delivery, and Stock-Level. The response time for all transactions must meet the requirements of the TPC-C test specification.
The larger the traffic indicator value, the better!
TPMC calculation basis
To facilitate the calculation of the shape of the database server, we agree:
"The number of simultaneous online users of the system is 1500 (U1 );
"On average, each user sends two business requests per minute (N1 );
"The system generates 1/3 of the Business requests for updates, queries, and statistics;
"Three transactions (T1) are generated each time the service is updated on average );
"An average of 8 transactions (T2) are generated for each query );
"An average of 13 transactions (T3) are generated for each statistical service );
"The amount of processing during busy hours in a day is 5 times of the average;
"The empirical coefficient is 1.6 (actual engineering experience)
"Considering that the server retains 30% redundancy;
The server requires the following processing capabilities:
TPC-C = U1 * N1 * (T1 + T2 + T3)/3*3 * empirical coefficient/redundancy Coefficient
The processing performance of the application server is estimated to be:
TPC-C = 1500*2*(3 + 8 + 13)/3*5*1.6/0.7 = 274,285 tpmC
The database server is related to the stable operation of the entire system. Considering the high reliability and availability, and pay attention to the scalability and cost-effectiveness of the equipment, the system will configure two high-performance database servers with a TPC-C value not less than 0.28 million.