105 questions
-4
votes
0
answers
41
views
Tikv:Scheduling:PD can only ensure that replicas of a Region are not at a same peer, not correct [closed]
https://tikv.org/docs/7.1/reference/architecture/scheduling/
"Note that the “position” here is different from “machine”. In general, PD can only ensure that replicas of a Region are not at a same ...
0
votes
0
answers
28
views
Increased latency in tidb read queries
I'm running a TiDB 7.x cluster with TiFlash nodes. I am some queries to slow down or fail intermittently. and I'm encountering the following error in the TiFlash logs:
[2025/08/22 09:30:07.938 +00:00] ...
- 49
0
votes
1
answer
53
views
Custom query filter for order by is causing issue with group by
I have a custom post type, and am looking to order-by a meta key. I have added the below, which works:
function training_qv_anyx_training($query, $block) {
if ( 'anyx-training' === $query['...
- 11
1
vote
4
answers
165
views
How does client handle failures in RAFT-replicated datastores? [closed]
Consider a database like cockroachDB that uses RAFT protocol for replicating data to a replica group owning a partition of the data. How does a client handle a request that fails in such DBs? Because, ...
- 129
0
votes
1
answer
87
views
Configuring the node-exporter in a TiDB cluster deployment via TiUP
According to https://docs.pingcap.com/tidb/stable/deploy-monitoring-services during the deployment of a TiDB cluster using TiUP, the monitoring and alert services are automatically deployed, and no ...
- 155
0
votes
0
answers
33
views
Deleting data from MySQL table periodically [duplicate]
We are using MySQL where we have almost around 100 tables. Data in these tables grow with time. So we need to delete the older data periodically. I think there are two approaches for this. First is to ...
- 31
0
votes
1
answer
92
views
In TiDB is it possible to change the SHARD_ROW_ID_BITS later on after inserting some data?
Hi I have a question on SHARD_ROW_ID_BITS in TiDB.
I understand you can specify such as 4 or 5 for this value depending on how much shards you want.
Question, is it possible to increase this value in ...
- 1,039
0
votes
2
answers
144
views
Does TiDB Serverless support TiFlash for analytical jobs (OLAP) just like TiDB?
In TiDB, I can configure and deploy TiFlash, which can be used for columnar based storage to perform OLAP tasks. In TiDB Serverless, I can see the same columnar storage is available on the dashboard. ...
- 1
0
votes
1
answer
161
views
Which path should I put config.toml in TiDB docker container?
I'm trying to integrating the official TiDB docker image with our appication for local development. I use docker-compose.yaml. When I run the TiDB docker container, it outputs lots of logs. It annoys ...
0
votes
3
answers
468
views
Error P1001: Unable to reach database server when following Prisma's Start from Scratch guide for relational databases with Node.js and MySQL
I am trying to follow Prisma's Start from Scratch guide for setting up a relational database with Node.js and MySQL. However, I encountered an error and I cannot connect to the database server.
Here ...
- 1
0
votes
1
answer
125
views
How does the tidb-operator start a pd cluster?
I've recently been learning about Kubernetes operators. When deploying an etcd cluster, the etcd-operator uses the following creation method:
Bootstrap phase: Start a seed member. In the ...
- 390
0
votes
2
answers
223
views
Does TiDB's range based sharding nature have actual read workload benefits?
I understand that TiDB, compared to DynamoDB, chose range-based sharding rather than hash-based sharding.
Now, one explanation I learned is that by using range-based sharding, you can do where ...
- 1,039
0
votes
2
answers
712
views
In TiDB how do you work around the issue where even for indexes, you can't write continuous values to avoid hotspots?
In TiDB, due to its range scan-based sharded nature, I understand that you should avoid writing continuous values.
For primary keys, a standard solution is to use auto random rather than auto ...
- 1,039
1
vote
1
answer
117
views
In TiDB, how to use snowflake style uuid without causing hot spot by doing bit reverse?
In this docs,
https://docs.pingcap.com/tidb/stable/dev-guide-unique-serial-number-generation
It says
"Finally, note that the IDs generated by the above two solutions are not random enough to be ...
- 1,039
1
vote
1
answer
148
views
How to support "FULL JOIN" clause
I'm trying to add "FULL JOIN" support in TiDB parser(https://github.com/pingcap/tidb/tree/master/parser).
I tried two different modifications to parser.y.
In attempt one:
I changed the ...
