Dumpling Connection Freezes When Exporting Data from MySQL8

Translated
1

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

Original topic: Dumpling连MySQL8导出数据时连接卡死

| username: caiyoubiao

【TiDB Usage Environment】Production Environment
【TiDB Version】v5.4.3
【Reproduction Path】
MySQL version 8.0.18 (more than 6000 tables), database running normally.

    1. The mysql command line client gets stuck when connecting, suggesting to add the -A parameter

image
image1380×174 50.1 KB

image
image1380×254 85.5 KB

【Encountered Problem: Problem Phenomenon and Impact】
Dumpling gets stuck and times out when connecting to MySQL, causing data export failure. Does Dumpling have a similar -A parameter option?

2
| username: Jiawei | Original post link

Why not just write this parameter into the configuration file?
We usually have this parameter in the configuration file.

3
| username: Jiawei | Original post link

It is the configuration file of MySQL.

4
| username: caiyoubiao | Original post link

Because it is an online database, it is not very convenient to change the configuration and restart.

5
| username: caiyoubiao | Original post link

The problem should also be solvable by modifying MySQL’s configuration:

6
| username: Jiawei | Original post link

I don’t think it works. You can check the dumpling documentation to see if there’s a solution for the hash issue. I think this just modifies your command. Give it a try and let us know the result. Normally, the no-auto-rehash option should be written into the database configuration file; otherwise, when there are many tables, the initial loading will be very slow.

7
| username: caiyoubiao | Original post link

I checked the Dumpling documentation and did not find a similar parameter. It seems the best solution is to add this parameter configuration on the MySQL side. Thank you very much for your suggestion.

8
| username: Jiawei | Original post link

You can also make a suggestion to the official team, asking them to add the -A parameter to Dumpling.

9
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.