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

Uncontrollable memory allocation with TRIGGERS, PROCEDURES and FUNCTIONS

    XMLWordPrintable

Details

    Description

      I have project with 8 databases, each 500Mb.
      Each has ~800 tables, some of them with triggers.
      Use ~100 stored procedures and functions.

      Notices excessibe memory usage 128GB is not the limit.
      Then HW limit is reached - OOM kills MariaDB

      Prepared simple DB structure examples:
      dSTAR16_MariaDB.sql (with 16 tables) - uses 2GB
      dSTAR64_MariaDB.sql (with 64 tables) - uses 32GB
      It is not linear (8 tables would be ~250Mb)

      In such DB simple (imposible query) is enougth to massivie memory usage:

      UPDATE jj001 SET vj001 = 0 WHERE 'TEJA' = 'FEJA';
      

      Could not find server config variables that could limit such memory usage.

      Tried script on hosting servers with shared MySQL/MariaDB service - all of them failed using this kind of script.

      256 tables script (expected 512GB memory usage) would kill almost any server.

      Attachments

        1. Capture.JPG
          Capture.JPG
          162 kB
        2. dSTAR16_MariaDB.sql
          85 kB
        3. dSTAR64_MariaDB.sql
          951 kB

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              eimix Eimantas
              Votes:
              4 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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