mysql-5.6

mysql-5.6 copied to clipboard

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...

rockeet

Update plugin_audit.h.pp according to f7c9e2f2d11f09bd003a101f89153bde85ac4da8

1

f7c9e2f2d11f09bd003a101f89153bde85ac4da8 updated `my_sqlcommand.h`, but `plugin_audit.h.pp` had not been updated accordingly. This PR updated `plugin_audit.h.pp` according to f7c9e2f2d11f09bd003a101f89153bde85ac4da8. Test Plan: ``` git checkout https://github.com/facebook/mysql-5.6.git --branch fb-mysql-8.0.20 cd mysql-5.6 cmake . ```

Atry

This bug maybe isolated to Percona mysql 5.7.latest stable. Did not test other mysql distro with rocksdb engine. mysql error log: ``` 2022-10-22T02:32:32.656099Z 5 [ERROR] Chunk size is too small...

Qubitium

Hi, I am wondering does the rocksdb engine support R-tree index for spatial data. I recently worked on a project for spatial data. I notice Mysql with Innodb or MyISAM...

Change72

`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...

rockeet

Initialize Rdb_tbl_prop_coll_factory in RocksDB for remote compaction

1

I'm working for remote compaction of RocksDB, which is an experimental feature. When I try to use this feature in MyRocks, I encounter one problem. It seems that the remote...

Qiaolin-Yu

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...

rockeet

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...

rockeet

rocksdb_force_flush_memtable_and_lzero_now has a race

1

The race is that there is no pause between flushing memtables (rocksdb_flush_all_memtables) and requesting compaction from L0 to L1. So if flushing memtables triggers some L0->L1 compaction then the attempt...

mdcallag

Build Failure "error: ‘cap_value_t’ was not declared in this scope"

6

Hi all, I followed the instructions on [this page](http://myrocks.io/docs/getting-started/) but still met the following errors, which said some data types in `libcap2` were not declared. My environment is ``` $...

lei-houjyu