Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19858

rocksdb lost all performance after upgrade

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.4.6
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Linux Ubuntu

      Description

      I have a table with 115 MM records. One field is varchar(50) and it has two possible values , either "business" or "residential". It is indexed.
      This simple query takes forever,
      select x from table where recordtype='business'
      explain select number from table where recordtype='business';
      ----------------------------------------------------------------------------------------------------------------+

      id select_type table type possible_keys key key_len ref rows Extra

      ----------------------------------------------------------------------------------------------------------------+

      1 SIMPLE table ref IDX_table_recordtype IDX_table_recordtype 54 const 1115827 Using index condition

      ----------------------------------------------------------------------------------------------------------------+

      It used to work fine in older versions. Now I am changing back to Innodb.
      I already did "optimize table" and it did not make it faster

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            philip_38 Philip orleans
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: