Index larger than data

  • Resolved joy0114

    (@joy0114)


    10 months, 3 weeks ago

    Hi,

    For some table, I’ve got index larger than data (and for others, more or less same size).

    For example:

    _hustle_tracking Données : 1.52MB + Index : 2.78MB + Moteur InnoDB
    _litespeed_url_file Données : 0.39MB + Index : 1.08MB + Moteur InnoDB
    _termmeta Données : 0.22MB + Index : 0.25MB + Moteur InnoDB

    Is it “normal” and coherent ?

    Thanks for any advices.
    Best regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Yes, adding keys (indexes) to tables makes copies of the data in the key data structures. That’s how indexes work. Please see this.

    This plugin does not do anything with the first two tables mentioned in your question, only the termmeta file.

    Thread Starter joy0114

    (@joy0114)

    Hi Ollie,

    Ok, thanks for your answer.

    Best regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Index larger than data’ is closed to new replies.