How to turn off message box about deprecated command

Hi guys,

I use profiling to check if my query is slow or not. The query like below:

set profiling = 1;
select * from table1;
show profile for query 1;

Everytime I execute the query, HeidiSQL show the warning message about deprecated command like below:



It's really anoying cause I have to close the messagebox manually everytime.

Anyway to turn it off?

Thanks.

I don't see what error message you mean, but you can deactivate the button "Stop on errors in batch mode" on the main toolbar, with the yellow warning sign on it.

Hi ansgar,

Thanks for the answer.

I turn if off but the message box still showing

Then, what message is it?

Simple: stop using the deprecated command SHOW PROFILE. The requester even tells you to use the performance schema instead.

You should get used to the information schema / performance schema tables now, before they drop SHOW PROFILE for good - that is why you are WARNED to check out the new solution.

'SHOW PROFILE' is deprecated and will be removed in a future release. Please use Performance Schema instead

(The screenshot is linked from a site that doesn't allow hot-linking.)

From the manual:

These statements are deprecated as of MySQL 5.6.7

BTW, in Windows you can often copy the text of many dialogues with Ctrl+C.

The message is as below.

[Window Title]
Warning
[Main Instruction]
Your query produced 1 warnings.
[Content]Warnings from last query:
Warning: 'SHOW PROFILES' is deprecated and will be removed in a future release. Please use Performance Schema instead
[OK]

Actually, I just need to know the execution time for my query and another after optimized to see if it work. The performance schema looks a little over the need.

Anw, although the command is deprecated, HeidiSQL should considered to show the message as a comment in the log panel or have an option to turn the message off.

Btw, thanks for the trick. I totally forgot it :D