mysql-5.6
mysql-5.6 copied to clipboard
Facebook's branch of the Oracle MySQL v5.6 database. This includes MyRocks.
use union to merge cf_id and index_id to uint64 full_id, because uint64 compare is faster than two uint32 compare
Use emplace instead of find + emplace, check pair.second for emplace success
branch `fb-mysql-8.0.23` insert should be faster when --disable-log-bin is specified, but it is slow when --disable-log-bin is specified. we found this issue when running sysbench: ```bash sysbench --db-driver=mysql --threads=80 --report-interval=1\...
CMake Error, ubuntu 20.04, inside docker already install libssl-dev etc apt install openssl libssl-dev ``` -- OPENSSL_LIBRARY = /usr/lib/x86_64-linux-gnu/libssl.so -- CRYPTO_LIBRARY = /usr/lib/x86_64-linux-gnu/libcrypto.so -- OPENSSL_MAJOR_VERSION = CMake Error at cmake/ssl.cmake:188...
This will github issue will track the progress of foreign key support in MyRocks. Initial proposal/thoughts (credits to @jkedgar): 1. To handle foreign keys in MyRocks, we need to create...
I installed MyRock here and I queried below ALTER TABLE distinc ADD CONSTRAINT fkey_district_1 FOREIGN KEY(d_w_id) REFERENCES warehouse(w_id); But it cannot be done by this error message below ERROR 1245...
db_bench only exposes cache_high_pri_pool_ratio and enables cache_index_and_filter_with_high_priority when cache_high_pri_pool_ratio is greater than 0. MyRocks exposes both, so you can enable cache_index_and_filter_with_high_priority while leaving cache_high_pri_pool_ratio at zero. That seems like a...
Apparently some systems require `-latomic` when linking, while other systems don't have the library and the linker fails with `-latomic`. I copied this check from HHVM sources (https://github.com/facebook/hhvm/blob/master/CMake/HPHPFindLibs.cmake#L484), not sure...
Running a large sysbench prepare against facebook/mysql-5.6 causes it to OOM. The same large sysbench prepare against Percona Server's MyRocks with exactly the same configuration runs fine without any OOM....
Server started with RocksDB engine crashes with compressed tables or tables with generated columns. Please find different test-cases which lead to same stacktrace. Steps to repeat the crash: [testcase.txt](https://github.com/facebook/mysql-5.6/files/7130516/testcase.txt) Another...