Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 请问大家TiDB怎么批量造数
|
username: TiDBer_QHSxuEa1
I would like to ask everyone, what methods does TiDB have for generating data in bulk?
|
username: TiDBer_QHSxuEa1
|
username: 
|
username: 
|
username: 
|
username: Do you use Navicat? Right-click the table, then generate data, select the amount of data, it’s especially fast.
|
username: Write a script to loop through and execute insert statements. It’s best to have multiple rows of data in a single insert statement.
|
username: Any benchmarking tool will do if there are no special requirements.
|
username: 
|
username: For TiDB, you can directly use tiup bench to create TPC-C and TPC-H.
|
username: 
|
username: Thank you, this feature is only available in Navicat 16. I have tried it, and it is indeed very useful.
|
username: 
|
username: 
|
username: TPCC BENCHMARK; or use other scripting languages; development tools like Navicat Premium, PLSQL Developer, etc., all have data generation functions.
This script is best as a stored procedure, but the problem is that TiDB doesn’t support it, so we have to use another programming language to write it.
|
username: This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.