Profile a query without query_cache_type enabled

[vivek]

I am using Studio v6.2.280 and mySQL 5.6.20

I have a query that I am trying to profile and the query_cache_type is disable in mysql and I cannot seem to enable it.

In the dbForge Studio, I have check the option 'Profile a query without caching (use SQL_NO_CACHE option) and it does not seem to help either.

I always get:

"1 Query cache is disabled; restart the server with query_cache_type=1 to enable it SQL.sql"

How can I profile a query without enabling the query_cache_type?

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

In the meanwhile, as a workaround, you can specify the following in the my.ini file on the server:

Code: Select all

set query_cache_type=ON

[vivek]

Thanks for the response, I got that working after a bit of searching on the internet.

[alexa]

We would like to let you know that we have released a new version 6.3 of dbForge Studio for MySQL where this issue is fixed http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.