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

How to turn off message box about deprecated command

User, date Message
Written by dang
3 months ago
Category: General
3 posts since Sat, 25 Jan 14
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.
Written by ansgar
3 months ago
4789 posts since Fri, 07 Apr 06
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.
Written by dang
3 months ago
3 posts since Sat, 25 Jan 14
Hi ansgar,

Thanks for the answer.

I turn if off but the message box still showing unhappy
Written by ansgar
3 months ago
4789 posts since Fri, 07 Apr 06
Then, what message is it?
Written by TTSneko
3 months ago
39 posts since Thu, 19 Jul 12
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.
Written by kalvaro
3 months ago
563 posts since Thu, 29 Nov 07
'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
Written by kalvaro
3 months ago
563 posts since Thu, 29 Nov 07
BTW, in Windows you can often copy the text of many dialogues with Ctrl+C.
Written by dang
3 months ago
3 posts since Sat, 25 Jan 14
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.