Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-10076

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

    • Sprint candidates

      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. 

            zabbix.dev Zabbix Development Team
            vmaksimovs Vladimirs Maksimovs
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: