26 questions
0
votes
2
answers
204
views
Increased replication in TiKV cluster, but storage use did not increase after applying
I am running a TiKV v7.2.0 cluster, which was deployed with tiup with server_configs.pd.replication.max-replicas: 1 configured in topology. After storing about 8TB of data in the cluster, I edited ...
- 1
0
votes
1
answer
614
views
TiDB executing full table scan
I am using TiDB version 6.5.1, I wanted to know the behavior of TiKV, let's say I have a table t which contains composite index example (a,b), when I am trying to execute following cases,
1.select sum(...
- 39
0
votes
1
answer
410
views
TiKV is sufficient for both OLTP and OLAP workloads?
I have an requirement to maintain big data sets in a single database and it should support both OLTP & OLAP workloads, I saw TiDB it will support HTAP workloads but we need to maintain data in ...
- 39
3
votes
1
answer
646
views
specifying the TiKV cluster endpoint as the backing data store error
1.start tikv commang:
# tiup playground --tag surrealdb --mode tikv-slim --pd 1 --kv 1
tiup is checking updates for component playground ...
Starting component `playground`: /root/.tiup/components/...
- 41
1
vote
1
answer
302
views
How can I set memory capacity of each TIKV?
How can I set the capacity of a TIKV instance? Lets say I have 2 TIKV instances and I want them to consume 200GB of storage (each 100GB).
- 119
0
votes
1
answer
318
views
What different betweent optimistic and pessimistic in tikv?
When I use tikv api, and I found it has an option in TxnKV client, then I test it, but I can not find what the difference between optimistic and pessimistic is in tikv?
The test code is this:
func ...
- 21
-2
votes
1
answer
143
views
what dose lockkeys in tikv api use for?
Recently, I was looking at tikv's api document. There is a LockKey api in transaction. When I call it for operation, I directly panic.
i have serval question?
i want to know why it panic
what does ...
- 21
2
votes
1
answer
357
views
Key Value Database Modeling for searchability
Let's say I am building a marketplace like eBay (or something) for example,
With a data that looks like this (pseudo-code):
public class Item {
Double price;
String geoHash;
Long ...
- 35.7k
0
votes
1
answer
191
views
Range query using TiKV database
How do you do range query with TiKV and java-client?
Suppose I have this model:
public class Hub implements Serializable {
private String name;
private List<Schedule> schedules;
}
and
...
- 1,042
1
vote
2
answers
170
views
How is data replicated among 2 different TiKv clusters?
Suppose I have one TiKV cluster deployed in city A and another TiKV cluster deployed in city B. And I want to write data in cluster A and read it in cluster B.
I know that inside cluster A, the data ...
- 461
1
vote
1
answer
588
views
how to optimize count(*)queries on tidb
I have a table with about 3000000 rows described as below.
Field |Type |Null|Key|Default|Extra |
------------------|------------|----|---|-------|--------------|
id ...
- 667
3
votes
1
answer
2k
views
Java-grpc and tikv-java: NoSuchFieldError: CONTEXT_SPAN_KEY
I am using java-grpc together with tikv-java (separately they work OK). But together I am struggling with the following error:
Exception in thread "main" java.lang.NoSuchFieldError: CONTEXT_SPAN_KEY
...
- 4,041
0
votes
1
answer
402
views
TIKV java client on MacOS: Failed to init client for PD cluster
I want to access TIKV using its java client on MacOS.
I have a hello-world app:
package com.pv.app;
import org.tikv.common.TiConfiguration;
import org.tikv.common.TiSession;
import org.tikv.raw....
- 4,041
0
votes
2
answers
448
views
What is "mult-raft" in TiKV?
I came across this intersting database the other day, and have read some doc on its offical site, I have some questions regarding Raft Group in TiKV (here),
Suppose that we have a cluster which has ...
- 1,819
2
votes
1
answer
731
views
Why the TiDB performance drop for 10 times when the updated field value is random?
I set up the TiDB, TiKV and PD cluster in order to benchmark them with YCSB tool, connected by the MySQL driver.
The cluster consists of 5 instances for each of TiDB, TiKV and PD.
Each node run a ...
- 377