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

Uncontrollable memory allocation with TRIGGERS, PROCEDURES and FUNCTIONS

Details

    • Bug
    • Status: On Hold
    • Medium
    • Resolution: Unresolved
    • 5.7.29-32, 8.0.19-10
    • None
    • None
    • 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.

      Attachments

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

        Issue Links

          Activity

            People

              Unassigned Unassigned
              eimix Eimantas
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Smart Checklist