Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Query Execution Time

TheOneDaveYoung's profile image TheOneDaveYoung posted 7 years ago in Running SQL scripts Permalink
I searched for a topic that covers this and having found none decided to post the question. I apologize if this is already covered in another topic. Please let me know!

Once upon a time, perhaps 18 months back, HeidiSQL would display the query execution time of MySQL queries in the bottom status bar on Windows. That was very useful for me while tuning query performance, especially on long running tasks.

Is there a reason this is no longer displayed and is there a way to bring it back? I could find nothing in the settings to re-enable this.

Thanks for such an AWESOME product!
ansgar's profile image ansgar posted 7 years ago Permalink
I'm sorry to say that, but this was never the case.

Instead of the bottom bar, query execution is displayed in the SQL log panel (which is also at the bottom, so probably you were mixing it up with the status bar).

So, when you run a query, watch out for such a line in the log panel:
select 1;
/* Affected rows: 0  Found rows: 1  Warnings: 0  Duration for 1 query: 0,000 sec. */
TheOneDaveYoung's profile image TheOneDaveYoung posted 7 years ago Permalink
There is no status info from the MySQL server being displayed in the log area. For example, when running a simple query such as "SELECT * FROM my_table WHERE my_field LIKE '%find%'; The only thing that is showing up in the log is query itself; No other status info from the MySQL server.

Of course this got me looking again at the preferences and sure enough somehow logging errors and information messages was turned off. Running the same query now shows the affected rows, found rows, warnings and duration.

Thanks!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.