Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: Tidb 建表很慢
|
username: 奋斗的大象
Creating tables is very slow.
|
username: 奋斗的大象
|
username: 
|
username: 
|
username: Please provide the specific results of admin show ddl jobs. Are there 100 table creation statements in the queue?
|
username: In specific contexts, describing the problem, analyzing the problem, and solving the problem by guessing what the other person is thinking is difficult. In the TiDB community, experts also first analyze various possibilities regardless of the situation, and sometimes it’s just a matter of luck, like a blind cat catching a dead mouse.
|
username: Either provide logs or provide monitoring information.
If you ask in such a general way, we can only make a wild guess.
|
username: Is it queue waiting? The information provided is not detailed.
|
username: 
|
username: 
|
username: Are the 100 processes purely for creating tables, or do they include operations like adding indexes and expanding fields?
|
username: Logs or more information are needed for analysis and troubleshooting.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: You can also check whether the machine performance of TiDB and TiKV has reached its limit.
|
username: Are there many partitions? Creating a table can be slower when there are many partitions compared to normal.
|
username: