Forum Replies Created
-
AuthorPosts
-
nithinMember
It has been fixed now. We will release 8.6Beta3 with this fix on next week.
nithinMemberIt has been added to our issue tracker
http://code.google.com/p/sqlyog/issues/detail?id=1425
The Statusbar can show aggregate of all queries.
Time info for individual queries can get from Message tab
nithinMemberThanks for the info.
We will check this in detail.
nithinMemberWe fixed this internally, issue was some white spaces in the beginning that shows as garbage here.
Thanks again
Nithin
nithinMemberThanks a lot, We got this when changed to 'German'.
We will check it and fix it.
July 26, 2010 at 7:24 am in reply to: Sja Hangs/idle/freezes While Backing Up Mysql Db Tables #31119nithinMemberSaleem,
Looks like these processes are not related to scheduled-backup. These are three sessions created by SQLyog while connecting to MySQL.
Can you try these,
– Instead of using command prompt, use the scheduled-backup wizard itself and do export for these cases: i)the specific database ii)all databases.
– Do you have an option to import the SQL dump to a local server? If yes, then import and do the export and tell if slowness still persists.(One reason we expect is since you export from live server and many are accessing the tables at same time and some lock on table may have happened).
July 23, 2010 at 1:13 pm in reply to: Sja Hangs/idle/freezes While Backing Up Mysql Db Tables #31117nithinMemberSaleem,
We need to know which query is slow on server.
So please recreate the situation and follow the steps explained below, when it is in waiting state for “Exporting
…. ”– Open another SQLyog and connect to same server
– Open Tools->Show->Processlist. It lists all active processes of the server. Click on 'Refresh' button in dialog, and you can find which process is for the Scheduled-backup.
To identify the process, please check the columns 'Command'(which would be “Query”) and 'State' (which would be “Sending data”, or “Writing”) of the table displayed. Please see the attached screen-shot.
– Once you identified the row (process) that refer to the Scheduled-backup thread, copy the 'Info' column (that contains the query executing) and send to us.
– You can also provide the other column status also by sending screen-shot of 'process list' dialog and mark the particular row.
For privacy you could create ticket using below link
Regards
nithinMemberPlease check this MySQL forum post, that may help you.
July 16, 2010 at 4:07 am in reply to: Feature Request: Don't Lock Interface During Query Execution #31091nithinMemberHello,
Latest SQLyog (since version 8.5) we have implemented the Tabbed-interface for connections. So your request can be achieved by opening multiple connections to same server and is possible to switch to other connection-tab while other is executing a long-running query. Let me know your thoughts.
Regards
Nithin
nithinMemberWe would like to inform that we have made a public release 8.53GA where we have solved 2 issues related to SSH. Please download, try it in your environment and let us know if need any further assistance.
nithinMemberHello,
The suggested feature costs more, in terms of query and time.
When you expand a 'database' node in the tree(called as object-browser), you could see the parent nodes such as 'Tables', 'Views', 'Functions', etc with [+} icon. While expanding the Database node SQLyog doesn't know whether the tables (or other objects) are present for the database, it comes to know these details only when expanding the 'Tables' node(I mean it issues query to find the tables details).
This is how its implemented otherwise while expanding database itself we should issue queries to get info for tables, views, etc and it's time consuming. So queries for 'Tables' are issued only while expanding tables, queries for 'Views' are issued only while expanding 'Views', and etc
Also I agree its confusing to keep [+] sign if contains no item, but the reason is same as I explained above.
Thank you
Nithin
nithinMemberWe have released 8.52GA. The bug fix related to the SQLyog's Plink is included to this official release.
http://www.webyog.com/blog/2010/06/29/sqlyog-mysql-gui-8-52-released/
Please download, try it in your environment and let us know if you need any further assistance.
nithinMemberDo we both need to have the same version of SqlYog software running for the data sync to work?
Not necessary. But it would be better if you could use the latest version if in case any bug fix, enhancement related to Data sync is included.
nithinMemberMake sure you set the compiler options that your application supports Unicode. To display you have to convert it to wide-char string, you could try to use API MultiByteToWideChar().
nithinMemberThanks for the suggestion.
It will be implemented as you have suggested, when table is truncated the range options would be the default(LIMIT 0-100). This will be done in next public release (Expected release date for 8.5GA is 15th of this month).
It's added to the issue tracker
-
AuthorPosts