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.

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

Management commands show some useless information #200

Closed
actiontech-bot opened this issue Sep 2, 2017 · 2 comments
Closed

Management commands show some useless information #200

actiontech-bot opened this issue Sep 2, 2017 · 2 comments

Comments

@actiontech-bot
Copy link
Member

actiontech-bot commented Sep 2, 2017

Raised by: @zhunina

mysql> show @@datanode where schema=tpcc;
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| NAME | DATHOST          | INDEX | ACTIVE | IDLE | SIZE | EXECUTE | TOTAL_TIME | MAX_TIME | MAX_SQL | RECOVERY_TIME |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| dn1  | 10.186.21.73/db1 |     0 |      0 |    3 |  400 |   42835 |          0 |        0 |       0 |            -1 |
| dn2  | 10.186.21.75/db1 |     0 |      0 |    0 |  100 |     246 |          0 |        0 |       0 |            -1 |
| dn3  | 10.186.21.73/db2 |     0 |      0 |    1 |  400 |     246 |          0 |        0 |       0 |            -1 |
| dn4  | 10.186.21.75/db2 |     0 |      0 |    3 |  100 |   42722 |          0 |        0 |       0 |            -1 |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
4 rows in set (0.00 sec)
mysql> show @@datanode;
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| NAME | DATHOST          | INDEX | ACTIVE | IDLE | SIZE | EXECUTE | TOTAL_TIME | MAX_TIME | MAX_SQL | RECOVERY_TIME |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| dn1  | 10.186.21.73/db1 |     0 |      0 |    3 |  400 |   42840 |          0 |        0 |       0 |            -1 |
| dn2  | 10.186.21.75/db1 |     0 |      0 |    0 |  100 |     246 |          0 |        0 |       0 |            -1 |
| dn3  | 10.186.21.73/db2 |     0 |      0 |    1 |  400 |     246 |          0 |        0 |       0 |            -1 |
| dn4  | 10.186.21.75/db2 |     0 |      0 |    3 |  100 |   42727 |          0 |        0 |       0 |            -1 |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
4 rows in set (0.00 sec)

Columns after DataHost are useless

@actiontech-bot
Copy link
Member Author

By @zhunina

In show @@sql.slow, datasource is always NULL

@actiontech-bot actiontech-bot added this to the 2.17.08.0 milestone Sep 3, 2017
sunsun314 added a commit that referenced this issue Sep 7, 2017
… = 'datanode_name' &

 recover the sql.sum & fix sql.sum.table cache delete
yanhuqing666 added a commit that referenced this issue Sep 7, 2017
#200 delete the support when use the show @@Datasource where datenode…
@actiontech actiontech deleted a comment from actiontech-bot Sep 8, 2017
@zhunina
Copy link

zhunina commented Sep 8, 2017

fixed

@zhunina zhunina closed this as completed Sep 8, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants