br: support batch ddl for sql restore

[BornChanger]

Enhancement

Restore sql execution does not support batch ddl as in restore clp. It's a performance issue, and we need to provide the support to SQL restore.

[BornChanger]

/component br

[BornChanger]

/severity major

[BornChanger]

/assign @Leavrth

[Leavrth]

If directly use the sessionCtx of the brie executer, the processlist would be other SQL:

MySQL [(none)]> show processlist;
+----------+------+-----------------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
| Id       | User | Host            | db   | Command | Time | State      | Info                                                                                                 |
+----------+------+-----------------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
| 85983238 | root | 127.0.0.1:47606 | NULL | Query   |    1 | autocommit | update `mysql`.`stats_meta` set snapshot = 445989087621414917, version = 445989087621414917, count = |
| 85983240 | root | 127.0.0.1:47722 | NULL | Query   |    0 | autocommit | show processlist                                                                                     |
+----------+------+-----------------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

[BornChanger]

/label needs-cherry-pick-6.5

[ti-chi-bot]

@BornChanger: The label(s) needs-cherry-pick-6.5 cannot be applied. These labels are supported: fuzz/sqlancer, challenge-program, compatibility-breaker, first-time-contributor, contribution, good first issue, correctness, duplicate, proposal, security, ok-to-test, needs-ok-to-test, needs-more-info, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.1, needs-cherry-pick-release-6.5, needs-cherry-pick-release-7.1, needs-cherry-pick-release-7.5, affects-5.4, affects-6.1, affects-6.5, affects-7.1, affects-7.5, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5.

In response to this:

/label needs-cherry-pick-6.5

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.