баг или фича?

[Melanxolik]

Zabbix 2.0.8 Все права защищены 2001-2013 Zabbix SIA

Уже не первый раз наблюдаю, нажимаю кнопку обзор и этот товаришь выгружает мне данные абсолютно по всем узлам сети, а там узлов и данных просто не передать сколько, выбираю нужную группу, перехожу на графики, смотрю, потом снова нажимаю на обзор и снова вываливает мне весь список, но где-то на 10 процентах вываливается окно что вкладка не отвечает, но оно и понятно, данных там немерянно.

[Fullmetal8ender]

Могу предположить что где то у вас в другом окошке открыта страница заббикса в которой фильтр не установлен (мб график какой-то), на ней срабатывает автообновление и сбрасывается фильтр.

[Melanxolik]

вроде нет, и таймауты выставлены.

вот еще одина проблема:
нажимаю на события и выбираю все по всем, и все, frontend висит, чот пытается грузонуть и висит долго и счастливо.
Подозреваю что проблема имеет один общий корень, но куда рыть.

[Fullmetal8ender]

Если у вас много элементов, то это может занять больше времени, чем обновление страницы по умолчанию. Попробуйте в профиле своего пользователя увеличить время автообновления.

[bga83]

вроде нет, и таймауты выставлены.

вот еще одина проблема:
нажимаю на события и выбираю все по всем, и все, frontend висит, чот пытается грузонуть и висит долго и счастливо.
Подозреваю что проблема имеет один общий корень, но куда рыть.

что можно посмотреть:
- включить режим отладки и когда страница прогрузиться посмотреть, что именно заняло столько времени
- посмотреть логи апача(или что используется для веб-морды) на предмет ошибок. У меня несколько раз просто не хватало памяти, выделеной для php, пришлось увеличивать

[Melanxolik]

К сожалению частично нашли от куда растут ноги, проблема начинается как только активируешь хосты которые работают с lld внешним скриптом, по мотивам:

https://www.zabbix.com/forum/showthread.php?t=28870

как только выключаешь хосты из мониторинга, ждешь, начинаешь путешествовать по всем меню без всяких проблем.

как бы дальше этот момент разобрать?

[Melanxolik]

Дамс, все таки похоже что в 2.0.8 какой-то баг.
Уже пробовал разворачивать схему БД, в неё перегружал данные, толку ноль, при попытке открыть события, забикс генерит запрос к БД:

SELECT e.eventid FROM events e WHERE (e.objectid BETWEEN '13023' AND '13028' OR e.objectid BETWEEN '13052' AND '13074' OR e.objectid BETWEEN '13076' AND '13080' OR e.objectid BETWEEN '13082' AND '13097' OR e.objectid BETWEEN '13099' AND '13109' OR e.objectid BETWEEN '13127' AND '13131' OR e.objectid BETWEEN '13133' AND '13148' OR e.objectid BETWEEN '13150' AND '13165' OR e.objectid BETWEEN '13167' AND '13182' OR e.objectid BETWEEN '13184' AND '13199' OR e.objectid BETWEEN '13201' AND '13216' OR e.objectid BETWEEN '13218' AND '13233' OR e.objectid BETWEEN '13235' AND '13239' OR e.objectid BETWEEN '13241' AND '13250' OR e.objectid BETWEEN '13252' AND '13256' OR e.objectid BETWEEN '13258' AND '13267' OR e.objectid BETWEEN '13269' AND '13273' OR e.objectid BETWEEN '13276' AND '13284' OR e.objectid BETWEEN '13286' AND '13301' OR e.objectid BETWEEN '13303' AND '13318' OR e.objectid BETWEEN '13320' AND '13330' OR e.objectid BETWEEN '13337' AND '13352' OR e.objectid BETWEEN '13354' AND '13364' OR e.objectid BETWEEN '13371' AND '13386' OR e.objectid BETWEEN '13391' AND '13403' OR e.objectid BETWEEN '13405' AND '13420' OR e.objectid BETWEEN '13422' AND '13432' OR e.objectid BETWEEN '13444' AND '13448' OR e.objectid BETWEEN '13450' AND '13459' OR e.objectid BETWEEN '13474' AND '13491' OR e.objectid BETWEEN '13522' AND '13526' OR e.objectid BETWEEN '13528' AND '13537' OR e.objectid BETWEEN '13564' AND '13575' OR e.objectid BETWEEN '13577' AND '13644' OR e.objectid BETWEEN '13646' AND '13656' OR e.objectid BETWEEN '13658' AND '13668' OR e.objectid BETWEEN '13670' AND '13680' OR e.objectid BETWEEN '13682' AND '13692' OR e.objectid BETWEEN '13730' AND '13764' OR e.objectid BETWEEN '13786' AND '13790' OR e.objectid BETWEEN '13792' AND '13811' OR e.objectid BETWEEN '13823' AND '13832' OR e.objectid BETWEEN '13834' AND '13853' OR e.objectid BETWEEN '13855' AND '13874' OR e.objectid BETWEEN '13876' AND '13890' OR e.objectid BETWEEN '13953' AND '13964' OR e.objectid BETWEEN '13978' AND '13990' OR e.objectid BETWEEN '13992' AND '14001' OR e.objectid BETWEEN '14008' AND '14014' OR e.objectid BETWEEN '14016' AND '14023' OR e.objectid BETWEEN '14028' AND '14032' OR e.objectid BETWEEN '14038' AND '14055' OR e.objectid BETWEEN '14079' AND '14086' OR e.objectid BETWEEN '14106' AND '14114' OR e.objectid BETWEEN '14116' AND '14132' OR e.objectid BETWEEN '14142' AND '14160' OR e.objectid BETWEEN '14166' AND '14184' OR e.objectid BETWEEN '14186' AND '14197' OR e.objectid BETWEEN '14199' AND '14215' OR e.objectid BETWEEN '14217' AND '14270' OR e.objectid BETWEEN '14489' AND '14501' OR e.objectid BETWEEN '14533' AND '14537' OR e.objectid BETWEEN '14539' AND '14561' OR e.objectid BETWEEN '14579' AND '14588' OR e.objectid BETWEEN '14599' AND '14633' OR e.objectid BETWEEN '14635' AND '14654' OR e.objectid BETWEEN '14695' AND '14701' OR e.objectid BETWEEN '14705' AND '14709' OR e.objectid BETWEEN '14713' AND '14718' OR e.objectid BETWEEN '14723' AND '14727' OR e.objectid BETWEEN '14733' AND '14737' OR e.objectid BETWEEN '14743' AND '14748' OR e.objectid BETWEEN '14773' AND '14778' OR e.objectid BETWEEN '14785' AND '14796' OR e.objectid BETWEEN '14803' AND '14811' OR e.objectid BETWEEN '14817' AND '14825' OR e.objectid BETWEEN '14831' AND '14839' OR e.objectid BETWEEN '15859' AND '15871' OR e.objectid BETWEEN '15914' AND '15925' OR e.objectid BETWEEN '15973' AND '15979' OR e.objectid BETWEEN '16027' AND '16033' OR e.objectid BETWEEN '16264' AND '16276' OR e.objectid BETWEEN '16319' AND '16330' OR e.objectid BETWEEN '16378' AND '16384' OR e.objectid BETWEEN '16432' AND '16438' OR e.objectid BETWEEN '17253' AND '17257' OR e.objectid BETWEEN '17351' AND '17360' OR e.objectid BETWEEN '17406' AND '17422' OR e.objectid BETWEEN '17484' AND '17502' OR e.objectid BETWEEN '17548' AND '17564' OR e.objectid BETWEEN '17566' AND '17570' OR e.objectid BETWEEN '17573' AND '17577' OR e.objectid BETWEEN '17580' AND '17585' OR e.objectid BETWEEN '17621' AND '17627' OR e.objectid BETWEEN '17633' AND '17654' OR e.objectid BETWEEN '17660' AND '17681' OR e.objectid BETWEEN '17728' AND '17739' OR e.objectid BETWEEN '17785' AND '17814' OR e.objectid BETWEEN '17860' AND '17876' OR e.objectid BETWEEN '17878' AND '17884' OR e.objectid BETWEEN '17938' AND '17945' OR e.objectid BETWEEN '17947' AND '17957' OR e.objectid BETWEEN '18003' AND '18032' OR e.objectid BETWEEN '18078' AND '18095' OR e.objectid BETWEEN '18102' AND '18129' OR e.objectid BETWEEN '18175' AND '18196' OR e.objectid BETWEEN '18205' AND '18209' OR e.objectid BETWEEN '18212' AND '18222' OR e.objectid BETWEEN '20376' AND '20399' OR e.objectid BETWEEN '20408' AND '20451' OR e.objectid BETWEEN '20453' AND '20488' OR e.objectid BETWEEN '20490' AND '20524' OR e.objectid BETWEEN '20583' AND '20588' OR e.objectid BETWEEN '20590' AND '20600' OR e.objectid BETWEEN '20602' AND '20650' OR e.objectid BETWEEN '20703' AND '20767' OR e.objectid BETWEEN '20769' AND '20775' OR e.objectid BETWEEN '20791' AND '20883' OR e.objectid BETWEEN '20885' AND '20915' OR e.objectid BETWEEN '20999' AND '21004' OR e.objectid BETWEEN '21006' AND '21096' OR e.objectid BETWEEN '21098' AND '21108' OR e.objectid BETWEEN '21110' AND '21134' OR e.objectid BETWEEN '21211' AND '21233' OR e.objectid BETWEEN '21242' AND '21270' OR e.objectid BETWEEN '21274' AND '21288' OR e.objectid BETWEEN '21290' AND '21298' OR e.objectid BETWEEN '21300' AND '21349' OR e.objectid BETWEEN '21398' AND '21483' OR e.objectid BETWEEN '21496' AND '21545' OR e.objectid BETWEEN '21573' AND '21627' OR e.objectid BETWEEN '21668' AND '21711' OR e.objectid BETWEEN '21713' AND '21762' OR e.objectid BETWEEN '21764' AND '21769' OR e.objectid BETWEEN '21802' AND '22457' OR e.objectid BETWEEN '22514' AND '22609' OR e.objectid BETWEEN '22706' AND '23501' OR e.objectid BETWEEN '23503' AND '23552' OR e.objectid BETWEEN '23554' AND '23559' OR e.objectid BETWEEN '23616' AND '23669' OR e.objectid BETWEEN '23702' AND '23917' OR e.objectid BETWEEN '23919' AND '23968' OR e.objectid BETWEEN '23970' AND '24019' OR e.objectid BETWEEN '24021' AND '24070' OR e.objectid BETWEEN '24072' AND '24077' OR e.objectid BETWEEN '24102' AND '24201' OR e.objectid BETWEEN '24234' AND '25357' OR e.objectid BETWEEN '25430' AND '25505' OR e.objectid BETWEEN '25551' AND '25616' OR e.objectid IN ('13020','13021','13031','13034','13037','13040',' 13043','13046','13049','13332','13333','13334','13 335','13366','13367','13368','13369','13388','1338 9','13438','13461','13463','13465','13467','13470' ,'13471','13472','13493','13495','13499','13500',' 13508','13509','13510','13513','13514','13516','13 539','13541','13545','13546','13554','13555','1355 6','13559','13560','13562','13706','13708','13709' ,'13711','13714','13715','13716','13718','13720',' 13721','13723','13726','13727','13728','13813','13 814','13815','13816','13819','13820','13892','1389 3','13895','13898','13899','13901','13968','13969' ,'13970','13971','13973','13974','13975','13976',' 14034','14035','14036','14088','14104','14134','14 135','14136','14138','14139','14140','14162','1416 3','14164','14591','14592','14595','14596','14657' ,'14658','14659','14660','14667','14668','14669',' 14671','14673','14674','14678','14679','14680','14 685','14686','14689','14693','14753','14754','1475 5','14756','14761','14762','14763','14764','14770' ,'14801','14852','14856','14896','14897','14993',' 15035','15081','15327','15531','15738','15743','15 744','15747','15765','15774','15796','15823','1582 5','15847','15848','15853','15854','15856','15857' ,'15874','15887','15889','15891','15895','15901',' 15902','15904','15908','15945','15949','15962','15 964','15969','15970','15971','16016','16018','1602 3','16072','16082','16083','16085','16086','16087' ,'16133','16136','16137','16143','16148','16149',' 16152','16170','16179','16201','16228','16230','16 252','16253','16258','16259','16261','16262','1627 9','16292','16294','16296','16300','16306','16307' ,'16309','16313','16350','16354','16367','16369',' 16374','16375','16376','16421','16423','16428','16 477','16487','16488','16490','16491','16492','1653 8','16541','16542','16555','16557','16558','16560' ,'16568','16582','16596','16732','16733','16734',' 16740','16741','16743','16746','16747','16748','16 754','16755','16757','16760','16761','16762','1676 8','16769','16771','16776','16790','16804','16815' ,'16818','16821','16823','16824','16827','16829',' 16832','16835','16837','16838','16841','16843','16 846','16849','16851','16852','16855','16899','1690 1','16908','16909','16911','16913','16915','16922' ,'16923','16925','16927','16929','16936','16937',' 16939','16983','16985','16992','16997','16999','17 006','17011','17013','17020','17076','17077','1709 0','17091','17104','17105','17161','17175','17189' ,'17200','17202','17203','17205','17206','17207',' 17220','17221','17222','17226','17227','17228','17 232','17233','17234','17362','17364','17366','1737 0','17372','17374','17377','17379','17381','17385' ,'17387','17389','17392','17394','17396','17400',' 17402','17404','17424','17425','17426','17429','17 430','17433','17434','17435','17436','17446','1744 8','17450','17461','17463','17465','17476','17478' ,'17480','17504','17506','17512','17514','17516',' 17519','17521','17527','17529','17531','17534','17 536','17542','17544','17546','17587','17601','1760 2','17609','17616','17629','17630','17631','17656' ,'17657','17658','17715','17717','17725','17887',' 17888','17889','17890','17892','17900','17902','17 904','17907','17915','17917','17919','17922','1793 0','17932','17934','17967','17982','17997','18042' ,'18043','18044','18057','18058','18059','18072',' 18073','18074','18097','18098','18099','18100','18 200','18201','18203','18224','18225','18227','1822 8','18229','18230','18232','18233','18234','18235' ,'18240','18744','19943','21630','21631','21632',' 21634','21635','25507','25509','25519','25522','25 524','25534','25537','25539','25549')) AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object=0 AND e.clock>=1380639501 AND e.clock<=1381244301 AND e.value_changed='1' AND e.object='0' ORDER BY e.eventid DESC LIMIT 1001 OFFSET 0;

который просто вешает на неопределенный срок загругку странички.
Запуск данного запроса из консоли или phpMyAdmin, тоже вешает систему, но это и ен удивительно, если посмотреть на запрос.

[Melanxolik]

дамс, вот и все

limit 1001 offset 0;

проблема в кол отображаемых элементов.

[Melanxolik]

Дамс, запросы к БД тормозят. Что делать дальше не могу предположить, БД оптимизированна.
Вывод:

root@utils:/root # perl mysqltuner.pl 

 >>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.6.14-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in InnoDB tables: 12G (Tables: 103)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] Total fragmented tables: 18

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 19h 55m 24s (78M q [496.137 qps], 120K conn, TX: 23B, RX: 10B)
[--] Reads / Writes: 40% / 60%
[--] Total buffers: 17.9G global + 40.2M per thread (312 max threads)
[!!] Maximum possible memory usage: 30.2G (92% of installed RAM)
[OK] Slow queries: 0% (110K/78M)
[OK] Highest usage of available connections: 46% (146/312)
[OK] Key buffer size / total MyISAM indexes: 512.0M/97.0K
[OK] Key buffer hit rate: 100.0% (246K cached / 0 reads)
[!!] Query cache efficiency: 10.9% (3M cached / 32M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (1 temp sorts / 457K sorts)
[!!] Joins performed without indexes: 107113
[OK] Temporary tables created on disk: 0% (30K on disk / 3M total)
[OK] Thread cache hit rate: 99% (187 created / 120K connections)
[OK] Table cache hit rate: 47% (342 open / 723 opened)
[OK] Open file limit used: 0% (97/11K)
[OK] Table locks acquired immediately: 100% (83M immediate / 83M locks)
[OK] InnoDB data size / buffer pool: 12.1G/16.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce your overall MySQL memory footprint for system stability
    Adjust your join queries to always utilize indexes
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_limit (> 4M, or use smaller result sets)
    join_buffer_size (> 8.0M, or always use indexes with joins)

Куда еще копнуть не понятно.

[Melanxolik]

народ, а посмотрите индексы на таблице events, их походу не хватает или они не корректно могут работать.
Создал дополнительные на:
objectid
value_changed
object
и список событий стал открыватся мгновенно, вместо тупления с минуту.

[Melanxolik]

Новая плюшка.
Случайно в конце имени комплексного экрана поставил `
получилось: back`

и теперь заходим в раздел мониторинг, комплексные экраны и вуаля, вместого одного поля для выбора графика у нас целых три, меню уплыло.