-
Change Request
-
Resolution: Won't fix
-
Trivial
-
None
-
1.8.10
-
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):
- Time: 120320 11:27:57
- User @ Host: zabbix [zabbix] @ [10. *. *. 5]
- 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.
????? ?? ?????? ??????? ????? ????????? ??????? ?? ?? ??????? (????????? ??????, ??????? ?????? ????):
- Time: 120320 11:27:57
- User@Host: zabbix[zabbix] @ [10.*.*.*5]
- Query_time: 297.700568 Lock_time: 0.000353 Rows_sent: 0 Rows_examined: 9758927
SET timestamp=1332235677;
delete from sessions where lastaccess<1300698906;
????? ??? ???????? ???????? ?? ?????? ?????? ?, ????????, ???????? ?????? ??????????? ???????? ? Zabbix ? ????? ?????????? ?????????? ???????.