Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 关于数据库自动优化，TiDB有在做哪些事情么？
In my impression, TiDB-related presentations mentioned automatic optimization. Are there any plans or roadmaps for this currently? By automatic optimization, I mean providing database optimization suggestions based on usage patterns combined with certain algorithms, or even executing optimizations automatically. For example, suggesting reasonable indexes based on usage, or automatically adjusting indexes; if a cluster has machines with better hardware and machines with slightly inferior hardware, tables or partitions can automatically migrate between these groups of machines based on data access patterns, and so on.
There should be SQL-level ones, but it’s quite difficult for higher levels…
As far as I remember, there doesn’t seem to be any suggestions for slow SQL yet. Many other vendors based on open-source MySQL have done this, so it should be soon.
I’ve used Meituan SQLAdvisor, and it basically just recommends indexes and the like.
Actually, I’m not just referring to the tool level. These are two different models. The tool level addresses issues with the current SQL or the SQL being scanned, such as what indexes need to be added or which indexes to use to optimize the current SQL. From the perspective of the database internals, it involves application-oriented analysis, overall optimization, and acceleration schemes. I’m not very articulate, so I’m not sure if I’ve made myself clear.
Currently, there is no information about the related functionality, but the automated deployment department already has a solution that is superior to MySQL.
|
username: 数据小黑
|
username: 
|
username: 
|
username: 
|
username: