python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - yugabytedb

How clock synchronization affects the performance of YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I would like to examine how the accuracy of clock synchronization affects the performance of YugabyteDB. How do you usually test such things i...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

To answer your question, we use Jepsen tests to verify correctness, which introduces clock skew issues (as a part of a larger set of failures it introduces). This report is old, but it explains the po...
test-img

dh YB

Optimizing YugabyteDB for tables with frequent deletes

[Question posted by a user on YugabyteDB Community Slack] Wanted to check if we should do any optimization on the db side for the tables that have frequent inserts and deletes ...like re-indexing or v...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

YugabyteDB uses rocksdb, which is an LSM-tree implementation. Any change, including a delete, is an addition to the memtable. Unlike PostgreSQL, where changes introduce row versions that must be clean...
test-img

dh YB

YugabyteDB YCQL transaction capabilities

[Question posted by a user on YugabyteDB Community Slack] I'm trying to figure out how powerful YCQL transactions are. Reading https://docs.yugabyte.com/latest/explore/transactions/distributed-transac...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

There are no client-controlled transactions in YCQL like in YSQL. YCQL transactions work like YSQL with autocommit on. The reason is that YCQL was developed to match Cassandra’s API, but also be consi...
test-img

dh YB

Big storage overhead when moving from Oracle to YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I'm doing the Oracle DB migration to YB and when testing and noticed after Import the size of the YB is tripled on each node, meaning 50GB of ...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

When putting only 1 char in the varchar(100) you have 4x storage overhead on YugabyteDB. So if you have really small or null values this can be explained. This is because of the way YugabyteDB current...
test-img

dh YB

Posts

Questions

Blogs

Jobs