Skip to content

RocksDB for large tables? #338

@Simbiat

Description

@Simbiat

consider https://docs.percona.com/percona-server/8.0/limitations.html MyRocks engine instead of InnoDB for large tables. The main downside is no support for foreign keys, but this may be ok for the character_job table, at least, since no removals are done there. and if's efficient enough, then it may allow storage of all achievements as well, and generally of all "history of changes" kinds of tables, where no DELETEs are expected. This would make the tracker library less transferable, though.

Metadata

Metadata

Assignees

No one assigned

    Labels

    architectureIssue is related to architecture of the service

    Projects

    Status

    To Consider

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions