Home
Rational® Performance Test Server
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.

Rational® Performance Test Server
- Release Notes
  This document contains information about What's new, installation, known issues, and contact information of IBM Support.
- System Requirements
  This document includes information about hardware and software requirements for IBM® Rational® Test Virtualization Server.
- Getting Started
  This guide provides an overview and describes the tasks to get you started with IBM® Rational® Performance Test Server.
- Administrator Guide
  Typically, a user with the administrator role is responsible for certain tasks including installation, configuration, and integration of the product. This guide lists all such topics.
- 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.
      - 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
    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. This guide is intended for Integration testers.
- Security Considerations
  You can take certain actions to ensure that your installation is secure, customize your security settings, and set up user access controls.
- Notices
  This document provides information about copyright, trademarks, terms and conditions for product documentation.

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