webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.21k stars 326 forks source link

Multi Threading Issues #1638

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1638 created by webyog on 2011-05-13T10:34:03.000Z:

Issue 1. While executing any long running query, the following need to be enabled: a) Import External Data. b) Scheduled Backup. c) Data sync. d) SQL scheduler and Reporting tool. e) Help file.


Issue 2. While executing any long running query, in favorites option the saved favorite queries need to be grayed out(now although they are not grayed out, they are not click-able either).


Issue 3 (PAINTING ISSUE). While executing a long running query-> Open a new connection ->Select Tile window option-> Close the new connection-> Maximize the connection in which the query is being executed(See the image). There are some painting issue.


Issue 4.

  1. Open 2 new connections.
  2. In one of them expand a database->table and execute a long running query in the same connection.
  3. While the query is being executed switch to the other connection and come back to the initial connection.
  4. while the query is still getting executed the expanded database->table gets collapsed. The database->table again expands back after the query execution completes.
atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2012-05-28T06:50:07.000Z:

"Long operations such as create indexes on large database fully block user interface, and I can't work with other databases and show processes."