Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.7.3
-
None
-
None
-
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; |