4 of 6 standards met
While running sysbench as explained here with a database that is cached by RocksDB from flamegraphs I see that ha_statistic_increment accounts for about 5% of the samples on the scan microbenchmark on a small server with 1 client connection and a large server with 24 client connections. After editing the function to make it cheaper I get between 5% and 10% more throughput. The upstream version is here and just increments a per-handler counter. The MyRocks version is here and does a bit more. The call to check_yield is the most expensive addition. The next most expensive change is the call to update_sql_stats_periodic. A flamegraph from the small server !sb perf g range-covered-pk pre range100 pk1 all
Repository: facebook/mysql-5.6. Description: Facebook's branch of the Oracle MySQL database. This includes MyRocks. Stars: 2585, Forks: 717. Primary language: C++. Languages: C++ (72.2%), C (14.1%), Yacc (4.9%), Perl (1.9%), Java (1.6%). Homepage: http://myrocks.io Open PRs: 40, open issues: 197. Last activity: 1y ago. Community health: 75%. Top contributors: blaudden, zmur, gkodinov, vasild, marcalff, jdduncan, jhauglid, bjornmu, dahlerlend, arnabray21 and others.
Last 12 weeks · 0 commits
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 (42000) at line 10: This version of MySQL doesn't yet support 'FOREIGN KEY for the RocksDB storage engine' Is there any help to solve this? Thanks in advance.
No commits recently. Thanks in advance!
MyRocks version - 8.0.32 Git_hash c6e4b9f3f93dce206370105fe73ee337ece0c5e7 Innodb_adaptive_hash_hits 1537 Innodb_adaptive_hash_misses 3092 Rocksdb_git_hash a24567271031a16115c0ceb4abee03acd9831787 As per the VectorDB documentation(https://github.com/facebook/mysql-5.6/wiki/Vector-Database) , i have created a training data table VECTORDB_DATA with centroids of 768 dimension, nlist=1024, i have attached few snippets for the same. But when i try to create an ivf index(ivfflat or ivfpq), here i am sharing with respect to ivfflat, i get an error message as operation not permitted. So i wanted to be clarified regarding this issue.Will be thankful to you if you can throw some light on my issue.