9.7 - Databases - MySQL
Databases - MySQL — Knowledge Base articles.
Databases - MySQL Knowledge Base Articles
Databases - MySQL Knowledge Base Articles This page should be used as an index for AIQ MySQL data...
Exception: "org.appvance.hibernate.exception.GenericJDBCException: Cannot open connection"
Exception may appear in error logs within a controller while executing a Database Scenario This t...
How to drop a schema/database from mysql in Linux (ubuntu) machine?
Open mysql using myql -u root -p command. #To see the list of databases run below command show da...
How to upgrade MySQL database ?
For upgrading MySQL from 5.6 to 5.7 version: ** Windows OS only ** Backup the APC database instan...
Installing sqlplus to connect to RDS and run queries
MySQL performance improvement
MySQL 5.7 and 5.6 performance improvement By Default MySQL performs a flush operation per commit ...
MYSQL: Drop Schema is taking way too long to drop the schema.
Solution: Stop mysql service. goto task manager > Go to services tab > look for MYSQL. Right clic...
Precedence of MySQL credentials in Appvance IQ
There are 3 different ways a user can provide the MySQL credentials in Appvance IQ. 1. Scenario B...
Question on SQL Testing in Appvance IQ
Is there a way to check in Appvance IQ that load is actually simulated on the DB under test . Som...
Response times in SQL Reports.
There are 2 entries in the report for response times, can you highlight the line which we are sup...
Troubleshooting MySQL
Packet for query is too large Please change max_allowed_packet=1024M in my.init. For more informa...
Troubleshoot Database Password Expiration
My local machine's SQL password got expired and I did change it from Workbench, but AIQ still thi...
Windows: Unable to connect database when Running a test in a different location
If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might ...
Manually Remove AIQ Executions from MySQL - Controlled Procedure
High-risk maintenance guidance Manually removing executions from the AIQ database is a high-risk ...
Stacktrace com.mysql.jdbc.PacketTooBigException: Packet for query is too large
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (6862323 > 4194304...
Configure MySQL SSL/TLS for AIQ Environments
OpenSSL installation. OpenSSL needs to be installed, the proper package can be found at https://w...
Queries on Sql Testing support in AIQ
1.Is the Joins clause Supported in .Sql script? Yes, it’s supported. 2. Can we write all sorts of...
How to install SQL Server, MS SQL Server Studio and get connected to the Server.
Browse the link https://www.microsoft.com/en-us/sql-server/sql-server-downloads-free-trial and cl...
Restore "blank" DB
Date: 2020-09-03 Procedure to restore previous executions Create a procedure to restore all the ...
How to write multiple queries in sql script to use with Process SQL file API and retrieve the values from locker?
In order to create a valid SQL script,below basic configuration settings is required to create a ...
Remove Executions from the Database - Controlled Procedure
Remove Executions from the Database - Controlled Procedure Removing executions from the AIQ datab...