[Mahesh]

HI,

1. Analyse non indexed queries and provide SQL to add suggested indexes

— This we will discuss internally.

2. Log MySQL connections that don't close off the connection once complete (i.e go to SLEEP until terminated by the server)

— Can you explain how we will come to know wheather that particular connection will not be used in future ?

3. List tables that are being created on disk rather than in memory, and why (column type, etc)

— Can you please explain in detail?

4. Slow query log

–This feature has already been implemented, Next version will have this feature.

[Mahesh]

Quote:

The process list is updated every second and by the time I see a SELECT statement to try the EXPLAIN option the screen is refreshed.

In processlist tab there is an option “Pause Auto-refresh” click on that and then click “Explain query” icon of the particular query.

[Mahesh]

Quote:

When I open a database in the tree in 99% of the cases I need the tables. It would be nice to have an option that automatically opens the “Tables” when I open a database.

HI Uyuni,

We discussed this internally as per discussion we decided to keep this as it is because some user may want Other Db items to be expanded like (views,Sp's etc..) and there may be situation that DB may have 100's or 1000's of tables and it is not feasible to open all tables everytime.

[Mahesh]

Issue Confirmed !

We will fix this with high priority.

Thanks for reporting

[Mahesh]

Issue Confirmed !

We will fix this with high priority.

Thanks for reporting.

[Mahesh]

HI,

I think your concern is with security to your portal DB.

This you can achieve by creating a user that will have limited access to the DB.

You can use to access it by using more secure http and ssh connection,

http://www.webyog.com/faq/content/21/19/en…_tunneling.html

http://www.webyog.com/faq/content/22/44/en…_tunneling.html

[Mahesh]

HI,

please tell us program version and mysql version ?

With SQLyog 6.1x onwards we are supporting all languages,

please refer to following Faq's

http://webyog.com/faq/content/34/148/en/do…y-language.html

http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html

http://www.webyog.com/faq/content/34/102/e…-by-sqlyog.html

Also in version 6.15 we implemented a feature “charset specification during CSV import” ( applicable only if mysql server verion is >5.0.37)

[Mahesh]

6.52 beta1 has been released with this option,

see the changelogs,

http://www.webyog.com/forums//index.php?showtopic=3894

[Mahesh]

6.52 beta1 has been released with this fix,

see the changelogs,

http://www.webyog.com/forums//index.php?showtopic=3894

[Mahesh]

HI,

v6.52 will have this feature, we are planning to release it very soon.

[Mahesh]

Issue Confirmed

We will fix this with high priority.

Thanks for reporting

[Mahesh]

We tried DBTuna(v1.7.0).

I think you are talking about Activity tab–which shows (Query exec. time,resource consumption time and Explain plan).

We are implementing features like sniffer,general_query_log analyzer, please evaluate this in next release.

Also tell us which feature you like to integrate with DbTuna ?

[Mahesh]

We have fixed this issue in version 6.15, please upgrade to latest version.

[Mahesh]

v6.51 has been released with the fix,

http://www.webyog.com/forums//index.php?showtopic=3877

Thanks

[Mahesh]

HI,

All Reported issues has been fixed in v6.51

http://www.webyog.com/forums//index.php?showtopic=3877

[Author]

Posts