Show Variables: Where is the Time Spent?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: show varialbes 时间消耗在哪了

| username: h5n1

Executed 21 times in half an hour, averaging 11 seconds

Manual speed test is very fast

| username: TiDBer_QYr0vohO | Original post link

It feels like it might be network overhead.

| username: xiaoqiao | Original post link

How about trying union all?

| username: 舞动梦灵 | Original post link

Where did this SQL come from?? Was it executed by the system backend? I didn’t see anything like this in the slow SQL logs.

| username: yiduoyunQ | Original post link

Look in the slow query.