[peterlaursen]

If you are right,  it would probably also apply to “HOST”.

[peterlaursen]

Let me clarify MySQL “reserved words” and “keywords”. The term “reserved keyword” is a mismatch of terms that has no place on Earth. 

 

“reserved words”  are listed here https://dev.mysql.com/doc/refman/5.6/en/reserved-words.html. A “reserved word” is reserved because the MySQL parser need them to parse the statement (and you need to `quote` them, should they be used as identifiers). 

 

“keywords” are words/tokens often used in SQL. If you check the link above you will see that neíther “CREATE”, “DROP”, “DELETE”, “INSERT” nor “UPDATE” are “reserved words”. Still they are “keywords” in the meaning that they are commonly used in SQL. SQL “keywords” are not strictly defined anywhere in MySQL documentation.  It is a ‘grey area’ what is a “keyword”, actually . 

 

That said: I don’t remember right now why we added USER to the keywords list in SQLyog. But I believe because in some type(s) of statement USER is a keyword. We will check. 

[peterlaursen]

DDL/schema alone is always fine for testing Schema Sync issues. DML/data are not required.

[peterlaursen]

1) 

If I execute this

SELECT SLEEP(10);

SELECT SLEEP(11);

SELECT SLEEP(12);

.. I cannot reproduce that it shows “http://www.webyog.com” – also not when switching programs or whatever.  Do I need to increase the sleep times (to several minutes or more)? A test case would be much appreciated. Also have you observed if it has started happening recently? 

 

 

2)

Displaying ‘current query of an executing batch’ is a reasonable request, I think. However if internals of the program causes a high effort to implement, we may decide not to do it for the time being. We will check. 

[peterlaursen]

We are checking this.

[peterlaursen]

Now look at this

 

/*

SQLyog Job Agent v12.1 (64 bit) Copyright(c) Webyog Inc. All Rights Reserved.

MySQL – 5.6.17 : Database – sys-controls

*********************************************************************

*/

 

 

 

What about the MySQL version information (“MySQL – 5.6.17 : Database – sys-controls”) .. is this a problem? Would this (below) be OK for your needs?

 

 

/*

SQLyog Job Agent – Copyright(c) Webyog Inc. All Rights Reserved.

MySQL – 5.6.17 : Database – sys-controls
*********************************************************************
*/

 

 

 

I think practically all backup programs – including mysqldump – provide such information on top of the dump.  And in case you use multiple programs it could be useful to identify what program generated a specific dump. 

[peterlaursen]

OK, but what should the implemenation be like exactly? 

 

We can only have one non-persistent DATA tab (a non-persistent DATA tab is the one the shows the latest table selected in Object browser). However we have an option for persistent DATA tabs as well.  So  think it would be possible to open the parent table in such (from context menu, for instance in order not to waste space in the GRID). The actual row may then be preselected/highlighted here. 

 

However you may not have considered that there could be more than one row in parent table that is the parent. MySQL allows a for many-to-may relationships with a non-unique index on parent column.  In that case there is not (or may not be) one specific row on target that can be consisered the parent row.  All rows with same value in target would be equally much parents here. Any idea how to handle this? 

 

Maybe also you can tell exactly how you would use such feature and why?

[peterlaursen]

Can’t you switch to MESSAGES tab when you need such information? 

[peterlaursen]

I have to correct myself.  With above example I get in MESSAGES tab:

 

2 queries executed, 2 success, 0 errors, 0 warnings

 

Query: select * from `webyog_portal`.`order_details` order by `order_id` desc limit 100

 

100 row(s) returned

 

Execution Time : 0.127 sec

Transfer Time  : 0.121 sec

Total Time     : 0.248 sec

---

 

Query: SELECT * FROM `webyog_portal`.`order_details` ORDER BY `order_id` DESC LIMIT 10000

 

10000 row(s) returned

 

Execution Time : 0.126 sec

Transfer Time  : 6.485 sec

Total Time     : 6.612 sec

 

(only noticed half of it before).

 

In status bar of RESULT tabs I get the same in both tabs: the aggregated execution time and aggregated transfer time of the *complete query batch*. This is as per design.

 

 

So what is the problem here? 

[peterlaursen]

I also believe that this should be possible using string functions available here https://dev.mysql.com/doc/refman/5.6/en/string-functions.html. With respect to string parsing I don’t think MySQL is less capable than other RDBMS

 

One thing I could suggest is to SELECT HEX .. and use the string function on the hexadecimal string identifying linebreaks here, and extracting the substring you need.  Next UNHEX. It can still be done in a single statement by nesting UNHEX and HEX like “SELECT UNHEX(.. HEX ..)”. But there may be simpler solutions.

[peterlaursen]

According to http://faq.webyog.com/content/8/147/en/how-shall-i-understand-the-_query-execution-time_-that-sqlyog-gives-me.html

 

.. I am reffering to all the 3 interfaces (MESSAGES tab, status bar of RESULT tabs and *per query* listing in HiSTORY tab.  MESSAGES tab has the most most complete information.

[peterlaursen]

It is a bug, obviously. Do you use (HTTP- or SSH) tunnel? I reproduced wth SSH-tunnel, but it is not reproducible for me with direct connection. 

 

I think

* in RESULT TAB(s) information should be for that particular query only. 

* In MESSAGES tab it should be telling sums of all queries – as the FAQ states: “In case you execute multiple statements at a time SQLyog will ‘aggregate’ the information for all queries executed.”

* in HISTORY tab it seems OK.

[peterlaursen]

It is supposed t work like described here http://faq.webyog.com/content/8/147/en/how-shall-i-understand-the-_query-execution-time_-that-sqlyog-gives-me.html.

 

 

I think Abishek does not get the point that this is about *bach execution* of multiple queries.

 

I have two queries (against our live customer/orders database) :

SELECT * FROM `database`.`table` ORDER BY `order_id` DESC LIMIT 100;

SELECT * FROM `database`.`table` ORDER BY `order_id` DESC LIMIT 10000;

 

In MESSAGES tab I get

 

Execution Time : 0.129 sec

Transfer Time  : 6.475 sec

Total Time     : 6.604 sec

 

Here I believe that “0.129 sec” is the execution time of the first (and fastest) query *ONLY*.  Because when executing the first query only I get

 

Execution Time : 0.126 sec <– here difference to 0.129 sec is neglible and varies from execution to execution. 

Transfer Time  : 0.121 sec

Total Time     : 0.248 sec

[peterlaursen]

First of all  I have moved this to teh proper Forum  (SQLyog, not MONyog, category.

 

I am not sure I understand “how SQLyog import to external data and how many process to do this”. But if I do, the answer is that SQLyog as such always runs in a single process (but a multi-threaded process): Modern Operating Systems mostly uses multithreading rather than inter-process communication for concurrency. In addition to this, there will be one or two PLINK processes if you use SSH-tunnel (two if you have autocomplete enabled) plus a Windows system process handling the ODBC-driver. Launching an SJA-module will start an sja.exe process and possiibly a PLINK-(‘slave’)-process, too. 

 

Maybe we could provide a better reply if you told why you are asking? What are your concerns? 

[peterlaursen]

If I simplify your statement as much as possible:

SELECT * FROM a INTO a_copy;

I get the error

— Error Code: 1327

— Undeclared variable: a_copy

The MySQL parser expects a “user variable” here. 

 

It does not matter what tabels a and a_copy are like as long as they arei dentical  and whether tables are empty or not.

 

 

This statement is correct for MySQL and works as expected:

INSERT INTO a_copy SELECT * FROM a; 

[Author]

Posts