rockeet

Fix rdb_i_s_sst_props_fields_info

4

In `rdb_i_s_sst_props_fields_info` definition, flag `MY_I_S_MAYBE_NULL` is missing for fields `COMPRESSION_ALGO`, `FILTER_POLICY`, `COMPRESSION_OPTIONS`, causing the `set_null` does not take effect, these 3 fields will keep last SST's value. This PR fixed...

When client sees connection closed, `finish_bulk_load` in `rocksdb_close_connection` may still inprogress, the new connection created instantly following would racing with finish_bulk_load. I can not fix the myrocks code for this...

use lambda instead of std::bind

1

std::bind(yield_condition, table) will generate a functor which size is larger than std::function's local buf, thus std::function needs to new/delete memory to store the functor. This PR use the lambda which...

set m_read_opts.ignore_range_deletions properly

3

ignore_range_deletions should be set to true when range del is not enabled

Wrong query plan for tpcc stock_level

2

### Branch: fb-mysql-8.0.28 ### Version: gitsha c75bf30d86a214a3a7106e5df0df47a130306c2f This bug impact both innodb and myrocks, an version of 6 months ago has no this issue. ### Reproduce Reproduce is very quickly,...

SST stats missing of compaction result of set global rocksdb_compact_cf="default"

9

```mysql set global rocksdb_compact_cf = "default"; ``` ## The compacted SST missing stats info **distincts per prefix**:  ## The correct SST stat info should like this:  We traced...

`Rdb_iterator_base::setup_scan_iterator` consumed too much time. ```bash sysbench select_random_ranges run --simple_ranges=10 --table_size=1000000 \ --time=600 --db-driver=mysql --threads=50 \ --mysql-host=**** --mysql-user=**** --mysql-password=**** --mysql-db=**** \ --mysql_storage_engine='rocksdb default charset latin1' ``` I think properly caching...

MemTable is not get freed while creating index

4

We run myrocks with sysbench: ```bash sysbench --db-driver=mysql --threads=20 --mysql-host=192.168.100.10 \ --mysql-port=3306 --mysql-user=test --mysql-password=1234 \ --mysql-db=test --tables=100 --table_size=100000000 oltp_write_only \ --mysql_storage_engine='rocksdb default charset latin1' prepare ``` When creating index, data...

ha_rocksdb::external_lock use many CPU time for memory only readonly workload

1

It seems myrocks and rocksdb doing many useless works: `Clear`, `Reinitialize`:    In the flame graph, CSPP_WBWI is our WriteBatchWithIndex implementation, used to replace rocksdb default WriteBatchWithIndex. Although...

use union to merge cf_id and index_id to uint64 full_id, because uint64 compare is faster than two uint32 compare