Home
Tester Guide
This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
Technical Tester Guide
Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
Creating and running performance tests
This topic describes how to create, configure, and run performance tests.
Troubleshooting: Running a performance test with a MySQL database
You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

Tester Guide
This guide describes the tasks that you can perform for testing various domains, technologies, and applications. To enable testing, you must configure and enable the environment for testing.
- Integration Tester Reference
  This guide provides the topics to help the Integration tester use the product by using the user interface, commands or scripts. This guide is intended for Integration testers.
- Technical Tester Guide
  Typically, a user with the Integration Tester role is also responsible for performance testing. This guide lists all such topics.
  - Creating and running performance tests
    This topic describes how to create, configure, and run performance tests.
    - Before creating performance tests
      Agents (Rational® Integration Tester Agent) are required on the computers that will run IBM® Rational Integration Tester tests and the probes that monitor the systems.
    - Creating performance tests
      A performance test is created within a Rational® Integration Tester project.
    - Performance tests
      Performance tests are executed in Rational® Integration Tester in the same way and from the same perspectives as any other test resource.
    - Troubleshooting: Running a performance test with a MySQL database
      You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.
  - View test results
    This topic describes how to work with IBM® Rational® Performance Test Server charts in the Results Gallery perspective.
  - Deploying probes
    A Rational® Integration Tester probe measures variables from a particular component in the system and reports back its findings for processing and storage.
- Integration Tester Guide (Service Virtualization)
  This guide describes the tasks that you can perform for using virtual services or stubs to simulate parts of an environment if the real services are not yet available or because they are difficult or expensive to use. This guide is intended for Integration Testers.

Troubleshooting: Running a performance test with a MySQL database

You can troubleshoot an issue that you encounter while you run a performance test with a MySQL database.

About this task

If you are using MySQL version 5.7 or later, the SQL mode ONLY_FULL_GROUP_BY is enabled by default. This mode must be removed, otherwise, when you run a performance test from Rational® Integration Tester with a MySQL database, an error is reported for the GROUP BY clause.

To remove this mode, follow these steps:

Procedure

For Windows or Linux follow these steps:
1. Edit the MySQL configuration file my.ini on Windows or my.cnf on Linux. Set the sql_mode parameter from a command line in one of two ways:
```
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  
```
```
sql_mode=""
```
2. Restart the MySQL server.

For Ubuntu follow these steps:

Create the following file:

/etc/mysql/conf.d/disable_strict_mode.cnf

Edit the file. Copy and paste the following command into the disable_strict_mode.cnf file to set the sql_mode parameter:

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart the MySQL server.
```
sudo service mysql restart
```

Check that the mode was removed:

mysql> select @@sql_mode

The result shows you the following:

STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION