[MDEV-20433] MRR implementation for MyRocks Created: 2019-08-27  Updated: 2019-11-05  Resolved: 2019-11-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Done Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20967 MRR implementation for MyRocks: cost-... Closed

 Description   

This is to track progress on

https://github.com/facebook/mysql-5.6/issues/790

Branch with the code

https://github.com/spetrunia/mysql-5.6/commits/fb-mysql-5.6.35-issue790

PR https://github.com/facebook/mysql-5.6/pull/1041



 Comments   
Comment by Sergei Petrunia [ 2019-09-19 ]

Commands to run testing with RQG (thanks elenst)

git clone git@github.com:MariaDB/randgen.git mariadb-randgen
cd mariadb-randgen/

rm -rf /dev/shm/vardir{1,2}
 
perl ./runall-new.pl \
--grammar=conf/optimizer/range_access.yy \
--gendata=conf/optimizer/range_access.zz  \
--duration=200 \
--basedir=/home/psergey/dev-git2/mysql-5.6-rocksdb-bka \
--vardir1=/dev/shm/vardir1 \
--vardir2=/dev/shm/vardir2 \
--mysqld1=--optimizer_switch=mrr=on,mrr_cost_based=off \
--mysqld1=--rocksdb \
--mysqld1=--skip-innodb \
--mysqld=--binlog-format=row \
--threads=4 \
--mysqld2=--optimizer_switch=mrr=off \
--mysqld2=--rocksdb --mysqld2=--skip-innodb \
--engine=RocksDB \
--mysqld1=--default-storage-engine=rocksdb \
--mysqld1=--default-tmp-storage-engine=MyISAM \
--mysqld2=--default-storage-engine=rocksdb \
--mysqld2=--default-tmp-storage-engine=MyISAM \
--mysqld1=--rocksdb_strict_collation_check=0 \
--mysqld2=--rocksdb_strict_collation_check=0

Generated at Thu Feb 08 08:59:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.