Chevereto & RocksDB ?

matou19

Founder license
Beta tester
Joined
Sep 3, 2011
Messages
120
Likes
13
Points
68
#1
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
176
Likes
35
Points
78
Location
Thailand
Website
bee.creative.xxx
#2
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,394
Likes
4,259
Points
237
Location
Chevereto HQ
Website
rodolfoberrios.com
#3
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
Likes
13
Points
68
#4
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