[MDEV-12550] Cannot Use RocksDB Engine In Windows x64 10.2.5 Builds Created: 2017-04-21  Updated: 2017-04-21  Resolved: 2017-04-21

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

Type: Bug Priority: Minor
Reporter: Kevin Gale Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows Server 2012 r2 Standard x64



 Description   

According to the 10.2.5 release notes the RocksDB storage engine is available for x64 MS-Windows builds:
https://downloads.mariadb.org/mariadb/10.2.5/

I've downloaded and installed Mariadb via the installer 'mariadb-10.2.5-winx64.msi' but cannot find any way to enable RocksDB.



 Comments   
Comment by Vladislav Vaintroub [ 2017-04-21 ]

You need to install the plugin. The info was missing in the documentation page
https://mariadb.com/kb/en/mariadb/getting-started-with-myrocks/
I added "Installing MyRocks On Windows" there.

 
MariaDB [(none)]> install soname 'ha_rocksdb';
Query OK, 0 rows affected, 1 warning (0.06 sec)
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> create table t1(i int) engine rocksdb;
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [test]> show create table t1;
+-------+-----------------------------------------------------------------------
-----------------+
| Table | Create Table
                 |
+-------+-----------------------------------------------------------------------
-----------------+
| t1    | CREATE TABLE `t1` (
  `i` int(11) DEFAULT NULL
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------
-----------------+
1 row in set (0.00 sec)

Generated at Thu Feb 08 07:58:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.