Why cache_store uses too much space?

[binary4cat]

I use mysql as cache store database, but this data is too big, soon the database reached 200G data, I don't know if there's something wrong, the following is the configuration that I thought might work, I hope to get help, thank you very much!

Mainly sorted_sets and values two data tables are particularly large.

[recommend]

# The cache size for recommended/popular/latest items. The default value is 10.
cache_size = 100

# Recommended cache expire time. The default value is 72h.
cache_expire = "72h"

[zhenghaoz]

How many categories are in the dataset? Categories will increase cache usage by times the number of categories.

[binary4cat]

The number of data items in the data_store database are:

• users: 1xxxxxx
• items: 2xxxx
• feedback: 0

[zhenghaoz]

I see. Most space is used by neighbors of users.

[binary4cat]

Is there any way to limit it? Because the amount of data is constantly growing, the database has performance problems.

[zhenghaoz]

I think the only solution is to switch the cache database.

https://gorse.io/docs/benchmark.html#restful-apis

MongoDB is more suitable than MySQL for Gorse, especially for large datasets.

[binary4cat]

Thank you very much for your suggestion.