tag:blogger.com,1999:blog-9149523927864751087.post3722192449530684223..comments2024-03-26T09:43:01.052-07:00Comments on Small Datum: MyRocks vs InnoDB, the insert benchmark and a disk arrayMark Callaghanhttp://www.blogger.com/profile/09590445221922043181noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9149523927864751087.post-15356539905763085932017-12-04T07:22:25.960-08:002017-12-04T07:22:25.960-08:00Try with rocksdb_block_cache_size set to between 2...Try with rocksdb_block_cache_size set to between 20% and 30% of RAM.<br />This has my.cnf for different versions of MyRocks and a server with 8gb of RAM<br />https://github.com/mdcallag/mytools/tree/master/bench/conf/corei3Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-9149523927864751087.post-54921153780592178262017-12-04T05:12:57.617-08:002017-12-04T05:12:57.617-08:00Do you have suggestions for much smaller systems l...Do you have suggestions for much smaller systems like with 8GB and 4 cores? I tried hacking up your optimized one to fit but could never get mariadb to start or detect what it didn't like. I have it running with just one line: rocksdb_block_cache_size=4G but I'd like to see if I can improve insertion rates (with random keys). Much obliged for a link or pointers. :)Chris S.http://neocogent.comnoreply@blogger.comtag:blogger.com,1999:blog-9149523927864751087.post-68269116286545496962016-01-25T06:48:29.578-08:002016-01-25T06:48:29.578-08:00I might have results next weekI might have results next weekMark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-9149523927864751087.post-15259474256427975802016-01-24T23:38:09.900-08:002016-01-24T23:38:09.900-08:00How does MyRocks compare to TokuDB in terms of ins...How does MyRocks compare to TokuDB in terms of insertion?Anonymousnoreply@blogger.com