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

Slow Performance with COUNT() on InnoDB Tables - Inquiry for Faster Alternatives

    XMLWordPrintable

Details

    Description

      Hello Team,

      I would like to know if there are any faster alternatives or optimizations available to retrieve the exact row count in InnoDB engines without resorting to estimated counts.
      While I understand that certain techniques (like using SHOW TABLE STATUS or INFORMATION_SCHEMA) can be used for estimates, I specifically need the exact row count. Is there any way to retrieve the exact row count faster instead of count()?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              baludbr Balaji Reddy Dwarampudi
              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.