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

MariaDB crashes on Azure with query_cache_type enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.3.23
    • N/A
    • Query Cache
    • MariaDB on Azure, General Purpose, 4 vCore(s), 400 GB, probably running under some Windows Server version

    Description

      When query_cache_type is enabled the server frequently crashes. Since it runs on Azure I have no access to the logs and I did not get them when requested.

      Azure support wrote this:
      We got update from our engineering team that server was down because of query cache is not disabled. query_cache_type is a static variable and needs to restart the server to take it effect. So, can you please set query_cache_type parameter to OFF and query_cache_size as 0, and restart server as need to see if the variable query_cache_type as OFF.

      The server is quite slow. A similar configuration on Googe Cloud (MySQL however) is much faster. I suspect this setting affects performance.

      Attachments

        Activity

          People

            Unassigned Unassigned
            WillydZ Willy de Zutter
            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.