Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-2076

Deleting/updating is slow on single numeric row key tables

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.0
    • Fix Version/s: None
    • Component/s: perf, tablet
    • Labels:
      None

      Description

      A user reported that deleting 50M rows on the simplest of tables, (id INT, text STRING, PRIMARY KEY (id)), doesn't complete.

      It reproduces locally and I was able to see that we're deleting 1.4 rows / ms which is awful considering that everything is cached.

      Todd found that we're spending most of our time decoding big blocks of bit-shuffled keys. Intuitively he though that having a composite row key would perform better and indeed adding a column set to 0 in front makes it 10x faster.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jdcryans Jean-Daniel Cryans
            • Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: