Change ID generation approach for housekeeper table to improve performance of parallel API requests to delete

XMLWordPrintable

    • Prev.Sprint, S25-W26/27, S25-W28/29, S25-W30/31, S25-W34/35, S25-W36/37, S25-W38/39, S25-W42/43, S25-W44/45, S25-W46/47, S25-W48/49, S25-W50/51/52/01, S26-W02/03, S26-W04/05, S26-W06/07, S26-W08/09
    • 5

      Currently when deleting large amount of items or triggers which may caused when deleting different hosts in parallel API requests, for example, often locks to "housekeeper" row of "ids" table occurred for the first API request.

      The proposed solution is to use CUID-type IDs or native DBMS ID generation approach (bigserial (for Postgres) or AUTO_INCREMENT (for MySQL)) for primary key's field values, instead of "ids" table row. 

        1. 10000_items_logs.zip
          1.85 MB
        2. 10000_triggers_logs.zip
          1.18 MB
        3. dhosts_mysql.png
          dhosts_mysql.png
          17 kB
        4. dservices.png
          dservices.png
          30 kB
        5. events.png
          events.png
          77 kB
        6. events-1.png
          events-1.png
          77 kB
        7. objectids_events_psql.png
          objectids_events_psql.png
          64 kB
        8. objects_psql.png
          objects_psql.png
          17 kB
        9. screenshot-1.png
          screenshot-1.png
          8 kB
        10. screenshot-2.png
          screenshot-2.png
          60 kB
        11. screenshot-3.png
          screenshot-3.png
          41 kB
        12. screenshot-4.png
          screenshot-4.png
          128 kB
        13. screenshot-5.png
          screenshot-5.png
          21 kB
        14. screenshot-6.png
          screenshot-6.png
          34 kB
        15. screenshot-7.png
          screenshot-7.png
          115 kB
        16. screenshot-8.png
          screenshot-8.png
          120 kB
        17. screenshot-9.png
          screenshot-9.png
          222 kB

            Assignee:
            Arturs Dancis
            Reporter:
            Vladimirs Maksimovs
            Team C
            Votes:
            1 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 435h 5m
                435h 5m