クライアント
OS: CentOS7
メモリサイズ: 4GB
-- 1. Installing JMeter
yum -y install java-1.8.0-openjdk
yum -y install java-1.8.0-openjdk-devel
java -version
export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk
export PATH=$PATH:$JAVA_HOME/bin
. ~/.bash_profile
echo $JAVA_HOME
javac -version
wget https://dlcdn.apache.org//jmeter/binaries/apache-jmeter-5.5.tgz
tar xvzf apache-jmeter-5.5.tgz -C /usr/local/
cd /usr/local/apache-jmeter-5.5
ls -1p
export JMETER_HOME="/usr/local/apache-jmeter-5.5"
export PATH=$PATH:$JMETER_HOME/bin
. ~/.bash_profile
-- 2. Loading the JDBC driver
<DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar
を下記にコピー
<JMeter>/lib
<DENODO_HOME> = C:\Denodo\DenodoPlatform8.0
<JMeter> = /usr/local/apache-jmeter-5.5
-- 3. Running JMeter
cd /usr/local/apache-jmeter-5.5/bin
./jmeter.sh
-- 4. Setting up the testing plan
① Thread group (the users)
② JDBC and/or HTTP Request
③ Report Listener
-- 4.1 Adding users
select the Test Plan, and then select Add > Thread(Users) > Thread Group
Number of Threads (users): 1
Ramp up Period (in seconds): 1
Loop Count: 3
-- 4.2 Setting up the JDBC connection
select the Users element, and then select Add > Config Element > JDBC Connection Configuration
Variable name bound to pool: jdbc01
Database URL: jdbc:vdb://10.0.0.9:9999/db01?chunkSize=3000
JDBC Driver class: com.denodo.vdp.jdbc.Driver
Username: admin
Password: admin
Validation query: Select 1
Max Number of Connections: 10
-- 4.3 Defining the requests
Select the Users element, and then select Add > Sampler > JDBC Request.
Name: test01
Variable Name Bound to Pool: jdbc01
SQL Query: select * from db01.b_tab1
-- 4.4 Add a listener to get a report for the Test Results
Select the Users element, and then select Add > Listener > Summary Report
-- 5. Running the test
テスト計画を保存(ファイル名=test01.jmx)
cd /usr/local/apache-jmeter-5.5/bin
./jmeter.sh -n -t test01.jmx -l test01.jmx
生成したtest01.jmx
をGUIのSummary Reportから読み込んで結果を表示