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

[Upgrade 10.1.25-MariaDB] Lose index from large table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.1.25
    • N/A
    • OTHER
    • Centos 7 - 64bit

    Description

      • When i run "yum update", MariaDB upgrade from 10.0.* to 10.1.25
      • TokuDB (5.6 not upgrade)
      • Small Problem:
      • Can't start service mariadb, folder source on "/home/mariadb". I fixed by "ProtectHome: Off"
      • Big Problem:
      • Table engine TokuDB, with large data > 300GB
      • When query select with too slow, i checked indexes of table. it's has indexes (A,B) for select query
      • I explained query, It's normal with indexes
      • BUT query return large rows
      • Example with one query before, after upgrade:
      • Normal (not upgrade): 10000 rows
      • BUT (upgraded): 1000,000 rows
      • Then server slow down.

      Please help me.
      Many thanks

      Attachments

        Activity

          People

            Unassigned Unassigned
            gacon Toan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.