Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.7.3
-
Fix Version/s: None
-
Component/s: Storage Engine - RocksDB
-
Labels:None
-
Environment:Linux
Description
if you have a table with a primary key and no secondary keys, this variable:
rocksdb-blind-delete-primary-key=1
should allow you to delete faster, but in reality, does not delete all
for example a table like:
CREATE TABLE lrntest ( |
did varchar(10) NOT NULL DEFAULT '', |
lrn varchar(10) DEFAULT NULL, |
PRIMARY KEY (did) |
)
|
ENGINE = ROCKSDB,
|
AVG_ROW_LENGTH = 12,
|
CHARACTER SET latin1, |
COLLATE latin1_swedish_ci, |
STATS_AUTO_RECALC = 1,
|
STATS_PERSISTENT = 1,
|
ROW_FORMAT = DYNAMIC; |