Cindyxin228 commented on issue #28014:
URL:
https://github.com/apache/shardingsphere/issues/28014#issuecomment-1676303558
> Hi @Cindyxin228, can you open `sql-show` and show actual sql?
Hi~
I'm sorry. I didn't find how to open sql-show in shardingsphere-proxy. and
by using ```setprofiling= 1```, I get the result
```
MySQL [sharding_db]> explain SELECT s.*, IFNULL(ss.skill, '') AS skill
-> FROM students s
-> LEFT JOIN student_skill ss ON s.st_id = ss.st_id
-> order by s.tol_score;
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref
| rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------------------------------+
| 1 | SIMPLE | s | ALL | NULL | NULL | NULL | NULL
| 1 | Using temporary; Using filesort |
| 1 | SIMPLE | ss | ALL | NULL | NULL | NULL | NULL
| 1 | Using where; Using join buffer (flat, BNL join) |
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------------------------------+
2 rows in set (0.010 sec)
```
and
```
MySQL [sharding_db]> show profiles;
Empty set (0.004 sec)
```
I'm sorry very much that it seems I didn't find valuable information. But I
can share how it leads to the question above.
The version is 5.4.0.
First, copy the configuration I comment above(config-sharding.yaml), and
sever.yaml is
```
mode:
type: Standalone
repository:
type: JDBC
authority:
users:
- user: root
password: root
- user: sharding
password: sharding
privilege:
type: ALL_PERMITTED
```.
After configuration, copy the sql I give in the first comment and then
execute. Then the question arises.
And if you still need that I give information about the actual sql. May you
please tell me how to open that and get the actual sql. Thanks very much.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
