Skip to content
This repository was archived by the owner on Jul 26, 2022. It is now read-only.

MyRocks tasks (2015.04)

Jump to bottom
Yoshinori Matsunobu edited this page Apr 16, 2015 · 3 revisions

  • Index

  • Unique secondary index

  • Data types

  • Fixing Data format on VARCHAR indexes

  • Support index-only scans for DATETIME, TIMESTAMP, and DOUBLE

  • Character sets

  • Support index-only scans for collations other than _bin

  • Optimizer

  • How to implement ha_rocksdb::records_in_range()

  • Replication

  • Read free slave (https://mariadb.atlassian.net/browse/MDEV-7258)

  • Repeatable Read isolation level

  • Decide if we implement gap locking or not. Not implementing gap locking means we can't run with statement based binary logging. Currently at Facebook we are not going to implement gap locking and require row based binary logging. (slaves can run with statement based binary logging)

  • Decide if MyRocks locks rows that don't exist at all, or conditionally lock rows that don't exist. With gap locking, it is locked. Without gap lock, it is not locked. But it is easy to lock rows that don't exist, if all unique key columns are used.

  • Discuss PostgreSQL style RR implementation. On locking reads/updates, compare current values with snapshot values, and return errors if it has changed. Errors are raised on statements. Not at commit.

  • Other row locking issues

  • Make SELECT LOCK IN SHARE MODE work

  • Large transactions

  • How to handle a case when people run "DELETE FROM tbl;" where tbl was over 1TB

  • Operations

  • Online Backup

  • Listing up useful I_S metrics

  • General QA issues

  • RocksDB internal issues

  • Slow seek after bulk delete

Clone this wiki locally