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

Query Cache Contention

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.0.29-galera
    • N/A
    • Query Cache

    Description

      oss-performance is a Hack language script which controls the operation of nginx, siege, and a specified PHP or HHVM runtime using MariaDB.

      It performs the following steps:
      Installs the workload (from an included archive)
      Starts nginx, Initializes the PHP engine, Performs a sanity check
      Runs 200 sequential requests with siege (single threaded warmup)
      Runs siege for a 60 second multi-threaded warmup
      Benchmarks with siege for 60 seconds of multi-threaded access
      Tears down nginx and PHP
      Prints results
      Install from link OSS-performance

      When the Query Cache is enabled, we see very low CPU utilization and in the mariadb shell we see (using show processlist that they are waiting on the query cache.

      We disabled the Query Cache and are able to saturate the CPU and also doubled the performance.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              ssuresh Suresh Srinivas
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.