Chevereto & RocksDB ?

matou19

Founder license
Beta tester
Joined
Sep 3, 2011
Messages
118
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
173
Likes
37
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 Guru-Guru
Staff member
Joined
Oct 7, 2008
Messages
16,134
Likes
4,177
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
118
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