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

Update is taking too much time after migrating to mariadb

Details

    Description

      After migrating from mysql 5.7 to mariadb 10.6.4 the normal update which used to finish in seconds is now taking 5-8 minutes and live transactions are not getting updated. After sometimes we face timeout error and again we need to kill older sesssions and start again. It is impacting our busines please help me.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          danblack Daniel Black added a comment -

          Can you include a `show processlist` while this is happening to see what SQL is in progress?

          danblack Daniel Black added a comment - Can you include a `show processlist` while this is happening to see what SQL is in progress?
          danblack Daniel Black added a comment -

          When you see some long running queries. Use show explain for <thread_id?> to capture what its doing.

          danblack Daniel Black added a comment - When you see some long running queries. Use show explain for <thread_id?> to capture what its doing.

          People

            Unassigned Unassigned
            suhas0528 Suhas Kumar
            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.