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

Logging user requests via the API

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 1.8.10
    • API (A), Frontend (F)
    • None
    • FreeBSD x64 8.1
      MySQL x64 5.5.14
      PHP 5.3.10

      google translate :
      --------------------------------------------------

      I ask you to pay attention to this situation.
      I monitor the status of ports, IP equipment with the help of ladders. In order to avoid problems due to loss of crossing the gangway or after a long downtime Zabbix, I use a script to synchronize the states of the interfaces, which deducts the state of ports on the equipment that receives the previous state of the ports of the equipment through the API from Zabbix, compares the data and sends the information the server only those ports whose state has changed. I'm also using the API for synchronization interfaces and renting state statistics on different types of oobrudovaniya and realizing at the script with all the necessary logic for data processing.

      Having, so far, about 450 hosts, when working with scripts that I use working through the API, in Zabbix is ??logging a lot of hits.
      The frequency of calls can be seen in the screenshot "1.Adminstration.Audit.jpg"
      At the same time, rapidly increasing the table "sessions", as are constantly inserting data into this table. Just last week, the table has increased by 1Gb.
      Also on the table the slowest queries in its treatment (delete the session, which bylshe year):

      1. Time: 120320 11:27:57
      2. User @ Host: zabbix [zabbix] @ [10. *. *. 5]
      3. Query_time: 297.700568 Lock_time: 0.000353 Rows_sent: 0 Rows_examined: 9758927
        SET timestamp = 1332235677;
        delete from sessions where lastaccess <1300698906;

      I ask you to pay attention to this point, and possibly change the logic of logging operations in Zabbix to umenesheniya number of records.

      original :
      --------------------------------------------------

      ????? ??? ???????? ???????? ?? ????? ????????.
      ? ??????????? ?????????? ????????? ?????? IP ???????????? ? ??????? ????. ??? ????, ????? ???????? ???????? ???????? ??- ?????? ????? ??? ????? ??????????? ??????? ??????? Zabbix, ? ????????? ?????? ??? ????????????? ????????? ???????????, ??????? ?????????? ????????? ?????? ?? ????????????, ???????? ?????????? ????????? ?????? ???????????? ????? API ?? Zabbix, ?????????? ?????? ?, ?????????? ?????????? ?? ?????? ?????? ?? ??? ??????, ????????? ??????? ??????????. ????? ? ????????? API ??? ????????????? ????????? ?????????? ? ????? ?????????????? ?????? ?? ?????? ????? ???????????? ? ???????? ?? ?????? ???????? ??? ??????????? ?????? ?? ????????? ??????.

      ????, ????, ??????? 450 ??????, ??? ?????? ? ???????? ? ????????? ??????? ?????????? ????? API, ? Zabbix ?????????? ??????????? ???????? ?????????? ?????????.
      ??????? ????????? ????? ??????? ?? ????????? "1.Adminstration.Audit.jpg"
      ??? ????, ?????????? ?????? ????????????? ??????? "sessions", ?.?. ????????? ???? ??????? ?????? ? ??? ???????. ????????? ?? ??????, ??????? ??????????? ?? 1Gb.
      ????? ?? ?????? ??????? ????? ????????? ??????? ?? ?? ??????? (????????? ??????, ??????? ?????? ????):

      1. Time: 120320 11:27:57
      2. User@Host: zabbix[zabbix] @ [10.*.*.*5]
      3. Query_time: 297.700568 Lock_time: 0.000353 Rows_sent: 0 Rows_examined: 9758927
        SET timestamp=1332235677;
        delete from sessions where lastaccess<1300698906;

      ????? ??? ???????? ???????? ?? ?????? ?????? ?, ????????, ???????? ?????? ??????????? ???????? ? Zabbix ? ????? ?????????? ?????????? ???????.

            Unassigned Unassigned
            gdgsoft Dmitrij Gavrilenko
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: