Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Improve] add STAGE for show @@connection.sql #1564

Closed
yanhuqing666 opened this issue Dec 20, 2019 · 2 comments
Closed

[Improve] add STAGE for show @@connection.sql #1564

yanhuqing666 opened this issue Dec 20, 2019 · 2 comments
Assignees
@yanhuqing666
Labels
doc-it differ with mysql, and let it go Improvement
Milestone
2.19.11.0

Comments

@yanhuqing666
Copy link
Member

the result of show @@connection.sql; will looks like this:

mysql> show @@connection.sql;
+----------+-----------------+------+--------+---------------------+--------------+-----------------------+-----------+
| FRONT_ID | HOST            | USER | SCHEMA | START_TIME          | EXECUTE_TIME | SQL                   | STAGE     |
+----------+-----------------+------+--------+---------------------+--------------+-----------------------+-----------+
|    1     | 0:0:0:0:0:0:0:1 | man  | NULL   | 2017/10/17 17:00:58 |          139 | show @@connection.sql | Read SQL  |
+----------+-----------------+------+--------+---------------------+--------------+-----------------------+-----------+

The Stage column will the same as trace result, but add a finished
@yanhuqing666 yanhuqing666 added this to the 2.19.11.0 milestone Dec 20, 2019
@yanhuqing666 yanhuqing666 self-assigned this Dec 20, 2019
yanhuqing666 added a commit that referenced this issue Dec 20, 2019
@yanhuqing666
add stage to show conn sql #1564
a72ca68
@yanhuqing666 yanhuqing666 mentioned this issue Dec 20, 2019
Merged
@yanhuqing666 yanhuqing666 added the doc-it differ with mysql, and let it go label Dec 20, 2019
yanhuqing666 added a commit that referenced this issue Dec 20, 2019
@yanhuqing666
add stage to show conn sql #1564
7cd898c
yanhuqing666 added a commit that referenced this issue Dec 23, 2019
@yanhuqing666
add stage to show conn sql #1564 (#1565)
1f71a4f
yanhuqing666 added a commit that referenced this issue Dec 23, 2019
@yanhuqing666
#1564 big_result may not correct
efbd566
@yanhuqing666 yanhuqing666 mentioned this issue Dec 23, 2019
Merged
yanhuqing666 added a commit that referenced this issue Dec 23, 2019
@yanhuqing666
#1564 big_result may not correct
cc7f111
@yanhuqing666
Copy link
Member Author

https://github.com/actiontech/dble-docs-cn/blob/develop/2.Function/2.1_manager_cmd/2.1.03_show.md#21318--show-connectionsql

yanhuqing666 added a commit that referenced this issue Dec 25, 2019
@yanhuqing666
#1564 big_result may not correct
afacede
yanhuqing666 added a commit that referenced this issue Dec 26, 2019
@yanhuqing666
#1564 big_result may not correct (#1570)
4a68a4e 
*  #1564 big_result may not correct

*  #1564 big_result may not correct
yanhuqing666 added a commit that referenced this issue Dec 31, 2019
@yanhuqing666
if select not autocommit ,the second query lost end time #1564
60e54d5
@yanhuqing666 yanhuqing666 mentioned this issue Dec 31, 2019
Merged
yanhuqing666 added a commit that referenced this issue Jan 2, 2020
@yanhuqing666
if select not autocommit ,the second query lost end time #1564 (#1596)
e3cf5f3
@yanhuqing666
Copy link
Member Author

https://github.com/actiontech/dble/blob/master/src/main/java/com/actiontech/dble/backend/mysql/nio/handler/query/DMLResponseHandler.java

Lordess added a commit to Lordess/dble that referenced this issue May 28, 2020
@Lordess
import feature from 2.19.11.0/rel to 2.19.03/lts
3e1ef65 
 * actiontech#1564 [Improve] add STAGE for show @@connection.sql
@Lordess Lordess mentioned this issue May 28, 2020
Merged
yanhuqing666 added a commit that referenced this issue May 29, 2020
@Lordess @yanhuqing666
release 2.19.03.4/lts (#1865)
2173c4e 
* split merge hander #1139 (#1140)

* reachedConCount thread safe #1139

* import feature from 2.19.11.0/rel to 2.19.03/lts

 * #1564 [Improve] add STAGE for show @@connection.sql

* import feature from 2.19.11.0/rel to 2.19.03/lts

* #1575 [Improve]add an manager command to show recently(doing or done) query detail stage

* release 2.19.03.4/lts

Co-authored-by: tiger.yan <yanhuqing666@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yanhuqing666 yanhuqing666

Labels
doc-it differ with mysql, and let it go Improvement
Projects
None yet
Milestone
2.19.11.0
Development

No branches or pull requests
1 participant
@yanhuqing666