Mysql Error: Show Profiles Nr: 1289

[glimbeek]

[SOLVED]

Hi,

I'm using SQLyog Enterprise – MySQL GUI v8.14

Connected to my Leaseweb server I try to run a simple select statement and I get the following error:

****

MySQL Error

Executed SQL statement

SHOW PROFILES

Error number: 1289

Error message

The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

****

So I contacted my host (leaseweb) and they told me they need to “rebuild” the mysqldb from scratch to fix this, because CPanel doesn't come with a build in mysql version which is build with the 'profiles' option. Of course this isn't covered by my SLA…

Is there anyway I can fix this?

Or can I ignore it? Even though it's annoying. However, if it doesn't influence any mysql statements I'm ok with leaving it as it is.

With the select statement, even though I get an error, the result is still ok.

Thanks in advance.

[peterlaursen]

the only thing you can do is to got to tools .. preferences .. powertools tab .. enable query profiler group …. and here uncheck 'show profile'.

[glimbeek]

'peterlaursen' wrote on '08:

the only thing you can do is to got to tools .. preferences .. powertools tab .. enable query profiler group …. and here uncheck 'show profile'.

Ok, so that removes the message. Are there any consequences to doing this?

[peterlaursen]

Only the Query Profiler will not display any information from SHOW PROFILE statement. But your server does not support it anyway.

[glimbeek]

Ok, great! Thanks for the reply.

[glimbeek]

Just to be sure, this doesn't affect mysql statements in anyway shape or form right?

[Author]

Posts