Troubleshooting
Problem
A query sent to MySQL takes longer to execute than expected. Using the MySQL tooling to profile a query, a large amount of time is recorded by the query planner.
Symptom
Query execution time in MySQL is high.
Cause
MySQL query planner is considering alternative plans resulting in larger planning times.
For more details, refer to the MySQL documentation on query planning.
http://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
For more details, refer to the MySQL documentation on query planning.
http://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Resolving The Problem
Reduce the search depth value used by MySQL. This can be specified via a connection command block in Cognos Analytics which issues the MySQL set session command or by the MySQL administrator lowering the server default setting.
For more details refer to the MySQL documentation.
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Document Location
Worldwide
[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration->Data Sources"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
05 April 2021
UID
ibm16440305