Test Oracle/mysql Performance with JMeter

----------------------------------------------------MySQL------------------------------------------------------------

1. Download JDBC, unzip the JDBC, copy the Mysql-connector-java-version-ga-bin.jar file to Jmeter/lib;

2. Open the JMeter and set the JDBC request;

1) database Url:jdbc:mysql://localhost:3306/datebasename. Where localhost:3306, this is the server address you tested, Datebasename, This is the database name you tested. This URL is a JDBC connection

2) Driver Class:org.gjt.mm.mysql.Driver or Com.mysql.jdbc.Driver If you can't connect to the database, try another one.

3) Username: Login name for this database

4) Password: This is the login password for the database

5) write the SQL statement in SQL Query string to test

----------------------------------------------------Oracle----------------------------------------------------------

1. Download JDBC, copy the Oracle JDBC Driver jar package file (Ojdbc14.jar) to the JMeter Lib directory;

2. Open the JMeter and set the JDBC request;

1) Database Url:jdbc:oracle:thin:@192.168.0.236:1521:orcl

format : Jdbc:oracle:thin:@[ip address]:[Port number]:[instance name]

2) JDBC Driver class:oracle.jdbc.driver.OracleDriver

3) Username: your database user name

4) Password: your database password

5) write the SQL statement in SQL Query string to test

Note:

1) The configuration test method for other databases (such as mysql/oracle, etc.) is also the same as

2) OJDBC version differences < differences between Ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar >

6929553

Test Oracle/mysql performance with JMeter