Chevereto & RocksDB ?

matou19

Founder license
Beta tester
Joined
Sep 3, 2011
Messages
120
Points
68
Hello !

I tried RocksDB in my server for the images table, but now the search function doesn't work anymore. When I try to search something :

Error: SQLSTATE [HY000]: General Error: 1214 The type of table used (ROCKSDB) does not support FULLTEXT indexes

Do you know if any update will fix it in the future ?

Thank you
 

bee

Well-Known Member
License owner
Joined
Dec 2, 2014
Messages
181
Points
78
Location
Thailand
Website
bee.creative.xxx
Current MyRocks limitations

No support for Online DDL, Foreign Key, Spatial Index, and Fulltext Index yet
▪ All tables must have Primary Key
▪ No next key locking support, ROW based binary logging must be used
▪ Full durability with XA (binlog and MyRocks) is not supported
▪ Either ORDER BY DESC or ASC is slow
▪ Bulk deletes slow Select/Update/Delete

RocksDB is not build to use it with Scripts like Chevereto.
 

Rodolfo

Chevereto Developer
Chevereto Staff
Joined
Oct 7, 2008
Messages
16,587
Points
237
Location
Chevereto HQ
Website
rodolfoberrios.com
Far as I'm aware, you can use RocksDB as database storage engine (replacement of MyISAM, Inno) but not as a drop-in replacement for MySQL/MariaDB.
 

matou19

Founder license
Beta tester
Joined
Sep 3, 2011
Messages
120
Points
68
Far as I'm aware, you can use RocksDB as database storage engine (replacement of MyISAM, Inno) but not as a drop-in replacement for MySQL/MariaDB.
Exactly. I have mariadb for the server, & rocksdb as database storage engine. But I only have this error when I try to make a research in the images/albums.
Do you know if it can be fixed ?

I have to use rocksdb because I have a lot of images, the loading is pretty slow otherwise