distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to turn off message box about deprecated command

dang posted 11 months ago in General
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.
ansgar posted 11 months ago
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.
dang posted 11 months ago
Hi ansgar,

Thanks for the answer.

I turn if off but the message box still showing unhappy
ansgar posted 11 months ago
Then, what message is it?
TTSneko posted 11 months ago
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.

kalvaro posted 11 months ago
'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
kalvaro posted 11 months ago
BTW, in Windows you can often copy the text of many dialogues with Ctrl+C.
dang posted 11 months ago
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

Please login to leave a reply, or register at first.