MySql / Mariadb support

[Pheromon]

I have a lot of issues with the current db, amongst them:

• sometimes the db gets corrupted and I lose weeks of crawling
• the background process that handles it uses a lot of memory and sometimes hangs/crashes
• I have no easy way to debug what's inside and manage it

It would be great to have native mariadb support so that I can use an high performance server to store the index and be able to do all sort of the usual administrative operations on it

[DEgITx]

It last 1.7 version the app switched to new version of db, you can try to test it and play for a while - possibly it's must be more stable
the db process must be limited to 128mb of memory usage, if not please send me the screen when it's happening. Out of memory possibly going from another components.

mariadb/mysql not intended for fast search and keep such large torrent db's, so for now I don't see any reasons to switch on it.

[Pheromon]

Thanks for your comments.

May I know the details on why you say mysql is not intended for fast search and handling of large dbs?

I use it daily for blazing fast searches on gigabytes of data.

[Pheromon]

BTW, is there a way to access the db from the commandline to check the structures, have some stats on the number of records, etc?

[DEgITx]

same as mysql or mariadb:
mysql -P9306 --protocol=tcp
while app running

at the most sytax are the same as with mariadb or mysql

[Pheromon]

wow that's great, thanks

What's the package/tool you are using for the db service?

[Pheromon]

it seems it's something related to sphinx but I'm unable to understand which package and how to access the files from the commandfile when rats is not running

any help appreciated :-)