Skip to content

Import wikipedia dump is slow #9

Description

@nobuf
  • Remove unnecessary indexes
    • KEY ll_lang
    • KEY page_random
    • KEY page_len
    • KEY page_redirect_namespace_len
  • Remove ROW_FORMAT=COMPRESSED
  • Increase innodb_buffer_pool_size
SET GLOBAL innodb_buffer_pool_size=4294967296 ;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions