Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6800

Uncontrollable memory allocation with TRIGGERS, PROCEDURES and FUNCTIONS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.29-32, 8.0.19-10
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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 Percona MySQL 

      Prepared simple DB structure test examples:
      dSTAR16.sql (with 16 tables) - uses 2GB
      dSTAR64.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 Percona MySQL service - all of them failed using this kind of script.

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

        Smart Checklist

          Attachments

          1. MySQLBug.JPG
            MySQLBug.JPG
            120 kB
          2. dSTAR64.sql
            951 kB
          3. dSTAR16.sql
            85 kB

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                eimix Eimantas
                Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated: