Zabbix Performance (history syncer 100%)SQlite and zabbixLog monitoring using ZabbixAutomated zabbix 2.0 installHow to combine Zabbix with MariaDB?Migrating Zabbix host to new serverZabbix 2.2 SSH/FTP performance monitoringZabbix: MySQL service monitor - invalid entry when restarting zabbix-agentSeveral Zabbix proxies in Zabbix senderMariaDB threads optimalization

Is it possible to have 2 different but equal size real number sets that have the same mean and standard deviation?

Thread Pool C++ Implementation

Fixing obscure 8080 emulator bug?

How can I search for all contacts without email?

Why are trash cans referred to as "zafacón" in Puerto Rico?

Ability To Change Root User Password (Vulnerability?)

What is inside of the 200 star chest?

How did old MS-DOS games utilize various graphic cards?

How to trick the reader into thinking they're following a redshirt instead of the protagonist?

Meaning of 'lose their grip on the groins of their followers'

Why are MBA programs closing?

Let M and N be single-digit integers. If the product 2M5 x 13N is divisible by 36, how many ordered pairs (M,N) are possible?

Are there any important biographies of nobodies?

How does the Around command at zero work?

Can I utilise a baking stone to make crepes?

Electricity free spaceship

Teaching a class likely meant to inflate the GPA of student athletes

Second (easy access) account in case my bank screws up

Is an entry level DSLR going to shoot nice portrait pictures?

Heap allocation on microcontroller

How to handle (one's own) self-harm scars (on the arm), in a work environment?

Bb13b9 confusion

US doctor working in Tripoli wants me to open online account

What ways have you found to get edits from non-LaTeX users?



Zabbix Performance (history syncer 100%)


SQlite and zabbixLog monitoring using ZabbixAutomated zabbix 2.0 installHow to combine Zabbix with MariaDB?Migrating Zabbix host to new serverZabbix 2.2 SSH/FTP performance monitoringZabbix: MySQL service monitor - invalid entry when restarting zabbix-agentSeveral Zabbix proxies in Zabbix senderMariaDB threads optimalization






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















Since November 2018 we have performance problems with Zabbix 3.4.10.
Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the Zabbix Server conf and tuning in the Zabbix Proxies conf.



The following problem remains:



2 times a day (5:22 p.m. and 8:22 p.m., we have different hours in the past) History Syncer reaches 100% and proxies become "NoDataProcessing".
While history syncer is at 100% several "NoData" alarms start to appear.
To recover, we stop the 2 major proxies, restart the server and raise the 2 proxies with a time interval.



Number of hosts 6679
Number of items 732813
Number of triggers 358638
Required server performance, new values per second 2695.54



Hardwares (VM):



  • Server:
    CPU: 4 CPU
    Memory: 24GB


  • Database (Ver 15.1 Distrib 10.3.4-MariaDB, for Linux (x86_64) using readline 5.1):
    CPU: 8 CPUs
    Memory: 64GB
    Disk: SSD


Infrastructure:



1 Zabbix Server version 3.4.10 (lx-all-mon-zserver-01)

1 Database Ver 15.1 Distrib 10.3.4-MariaDB (lx-all-mon-zdb-03)

6 proxies for machines

1 proxy for Databases monitoring

1 proxy for webchecks



Logs, confs and graphs










share|improve this question















migrated from superuser.com May 23 at 20:26


This question came from our site for computer enthusiasts and power users.


















  • 100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

    – Rick James
    May 23 at 21:49












  • With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

    – Michael Hampton
    May 24 at 0:16

















0















Since November 2018 we have performance problems with Zabbix 3.4.10.
Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the Zabbix Server conf and tuning in the Zabbix Proxies conf.



The following problem remains:



2 times a day (5:22 p.m. and 8:22 p.m., we have different hours in the past) History Syncer reaches 100% and proxies become "NoDataProcessing".
While history syncer is at 100% several "NoData" alarms start to appear.
To recover, we stop the 2 major proxies, restart the server and raise the 2 proxies with a time interval.



Number of hosts 6679
Number of items 732813
Number of triggers 358638
Required server performance, new values per second 2695.54



Hardwares (VM):



  • Server:
    CPU: 4 CPU
    Memory: 24GB


  • Database (Ver 15.1 Distrib 10.3.4-MariaDB, for Linux (x86_64) using readline 5.1):
    CPU: 8 CPUs
    Memory: 64GB
    Disk: SSD


Infrastructure:



1 Zabbix Server version 3.4.10 (lx-all-mon-zserver-01)

1 Database Ver 15.1 Distrib 10.3.4-MariaDB (lx-all-mon-zdb-03)

6 proxies for machines

1 proxy for Databases monitoring

1 proxy for webchecks



Logs, confs and graphs










share|improve this question















migrated from superuser.com May 23 at 20:26


This question came from our site for computer enthusiasts and power users.


















  • 100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

    – Rick James
    May 23 at 21:49












  • With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

    – Michael Hampton
    May 24 at 0:16













0












0








0








Since November 2018 we have performance problems with Zabbix 3.4.10.
Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the Zabbix Server conf and tuning in the Zabbix Proxies conf.



The following problem remains:



2 times a day (5:22 p.m. and 8:22 p.m., we have different hours in the past) History Syncer reaches 100% and proxies become "NoDataProcessing".
While history syncer is at 100% several "NoData" alarms start to appear.
To recover, we stop the 2 major proxies, restart the server and raise the 2 proxies with a time interval.



Number of hosts 6679
Number of items 732813
Number of triggers 358638
Required server performance, new values per second 2695.54



Hardwares (VM):



  • Server:
    CPU: 4 CPU
    Memory: 24GB


  • Database (Ver 15.1 Distrib 10.3.4-MariaDB, for Linux (x86_64) using readline 5.1):
    CPU: 8 CPUs
    Memory: 64GB
    Disk: SSD


Infrastructure:



1 Zabbix Server version 3.4.10 (lx-all-mon-zserver-01)

1 Database Ver 15.1 Distrib 10.3.4-MariaDB (lx-all-mon-zdb-03)

6 proxies for machines

1 proxy for Databases monitoring

1 proxy for webchecks



Logs, confs and graphs










share|improve this question
















Since November 2018 we have performance problems with Zabbix 3.4.10.
Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the Zabbix Server conf and tuning in the Zabbix Proxies conf.



The following problem remains:



2 times a day (5:22 p.m. and 8:22 p.m., we have different hours in the past) History Syncer reaches 100% and proxies become "NoDataProcessing".
While history syncer is at 100% several "NoData" alarms start to appear.
To recover, we stop the 2 major proxies, restart the server and raise the 2 proxies with a time interval.



Number of hosts 6679
Number of items 732813
Number of triggers 358638
Required server performance, new values per second 2695.54



Hardwares (VM):



  • Server:
    CPU: 4 CPU
    Memory: 24GB


  • Database (Ver 15.1 Distrib 10.3.4-MariaDB, for Linux (x86_64) using readline 5.1):
    CPU: 8 CPUs
    Memory: 64GB
    Disk: SSD


Infrastructure:



1 Zabbix Server version 3.4.10 (lx-all-mon-zserver-01)

1 Database Ver 15.1 Distrib 10.3.4-MariaDB (lx-all-mon-zdb-03)

6 proxies for machines

1 proxy for Databases monitoring

1 proxy for webchecks



Logs, confs and graphs







proxy mysql mariadb zabbix






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited May 24 at 17:33









Community

1




1










asked May 23 at 17:33









webbixwebbix

1




1




migrated from superuser.com May 23 at 20:26


This question came from our site for computer enthusiasts and power users.









migrated from superuser.com May 23 at 20:26


This question came from our site for computer enthusiasts and power users.














  • 100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

    – Rick James
    May 23 at 21:49












  • With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

    – Michael Hampton
    May 24 at 0:16

















  • 100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

    – Rick James
    May 23 at 21:49












  • With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

    – Michael Hampton
    May 24 at 0:16
















100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

– Rick James
May 23 at 21:49






100% of what? If CPU, then what queries were running at the time? To get to the bottom of the problem, we probably need to look at it from a MySQL/MariaDB point of view. Zabbix's output seems to be obfuscating the issue. Do you know how to connect to the database from phpmyadmin or mysql workbench or the commandline tool 'mysql'?

– Rick James
May 23 at 21:49














With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

– Michael Hampton
May 24 at 0:16





With the caveat that I can't access any of the files in that SharePoint link (and so probably others cannot either): Zabbix should be monitoring itself. Check its own graphs to see if a bottleneck is obvious. And post the data in the question itself, so that it remains accessible even if external links are not.

– Michael Hampton
May 24 at 0:16










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f968623%2fzabbix-performance-history-syncer-100%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Server Fault!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f968623%2fzabbix-performance-history-syncer-100%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Club Baloncesto Breogán Índice Historia | Pavillón | Nome | O Breogán na cultura popular | Xogadores | Adestradores | Presidentes | Palmarés | Historial | Líderes | Notas | Véxase tamén | Menú de navegacióncbbreogan.galCadroGuía oficial da ACB 2009-10, páxina 201Guía oficial ACB 1992, páxina 183. Editorial DB.É de 6.500 espectadores sentados axeitándose á última normativa"Estudiantes Junior, entre as mellores canteiras"o orixinalHemeroteca El Mundo Deportivo, 16 setembro de 1970, páxina 12Historia do BreogánAlfredo Pérez, o último canoneiroHistoria C.B. BreogánHemeroteca de El Mundo DeportivoJimmy Wright, norteamericano do Breogán deixará Lugo por ameazas de morteResultados de Breogán en 1986-87Resultados de Breogán en 1990-91Ficha de Velimir Perasović en acb.comResultados de Breogán en 1994-95Breogán arrasa al Barça. "El Mundo Deportivo", 27 de setembro de 1999, páxina 58CB Breogán - FC BarcelonaA FEB invita a participar nunha nova Liga EuropeaCharlie Bell na prensa estatalMáximos anotadores 2005Tempada 2005-06 : Tódolos Xogadores da Xornada""Non quero pensar nunha man negra, mais pregúntome que está a pasar""o orixinalRaúl López, orgulloso dos xogadores, presume da boa saúde económica do BreogánJulio González confirma que cesa como presidente del BreogánHomenaxe a Lisardo GómezA tempada do rexurdimento celesteEntrevista a Lisardo GómezEl COB dinamita el Pazo para forzar el quinto (69-73)Cafés Candelas, patrocinador del CB Breogán"Suso Lázare, novo presidente do Breogán"o orixinalCafés Candelas Breogán firma el mayor triunfo de la historiaEl Breogán realizará 17 homenajes por su cincuenta aniversario"O Breogán honra ao seu fundador e primeiro presidente"o orixinalMiguel Giao recibiu a homenaxe do PazoHomenaxe aos primeiros gladiadores celestesO home que nos amosa como ver o Breo co corazónTita Franco será homenaxeada polos #50anosdeBreoJulio Vila recibirá unha homenaxe in memoriam polos #50anosdeBreo"O Breogán homenaxeará aos seus aboados máis veteráns"Pechada ovación a «Capi» Sanmartín e Ricardo «Corazón de González»Homenaxe por décadas de informaciónPaco García volve ao Pazo con motivo do 50 aniversario"Resultados y clasificaciones""O Cafés Candelas Breogán, campión da Copa Princesa""O Cafés Candelas Breogán, equipo ACB"C.B. Breogán"Proxecto social"o orixinal"Centros asociados"o orixinalFicha en imdb.comMario Camus trata la recuperación del amor en 'La vieja música', su última película"Páxina web oficial""Club Baloncesto Breogán""C. B. Breogán S.A.D."eehttp://www.fegaba.com

Vilaño, A Laracha Índice Patrimonio | Lugares e parroquias | Véxase tamén | Menú de navegación43°14′52″N 8°36′03″O / 43.24775, -8.60070

Cegueira Índice Epidemioloxía | Deficiencia visual | Tipos de cegueira | Principais causas de cegueira | Tratamento | Técnicas de adaptación e axudas | Vida dos cegos | Primeiros auxilios | Crenzas respecto das persoas cegas | Crenzas das persoas cegas | O neno deficiente visual | Aspectos psicolóxicos da cegueira | Notas | Véxase tamén | Menú de navegación54.054.154.436928256blindnessDicionario da Real Academia GalegaPortal das Palabras"International Standards: Visual Standards — Aspects and Ranges of Vision Loss with Emphasis on Population Surveys.""Visual impairment and blindness""Presentan un plan para previr a cegueira"o orixinalACCDV Associació Catalana de Cecs i Disminuïts Visuals - PMFTrachoma"Effect of gene therapy on visual function in Leber's congenital amaurosis"1844137110.1056/NEJMoa0802268Cans guía - os mellores amigos dos cegosArquivadoEscola de cans guía para cegos en Mortágua, PortugalArquivado"Tecnología para ciegos y deficientes visuales. Recopilación de recursos gratuitos en la Red""Colorino""‘COL.diesis’, escuchar los sonidos del color""COL.diesis: Transforming Colour into Melody and Implementing the Result in a Colour Sensor Device"o orixinal"Sistema de desarrollo de sinestesia color-sonido para invidentes utilizando un protocolo de audio""Enseñanza táctil - geometría y color. Juegos didácticos para niños ciegos y videntes""Sistema Constanz"L'ocupació laboral dels cecs a l'Estat espanyol està pràcticament equiparada a la de les persones amb visió, entrevista amb Pedro ZuritaONCE (Organización Nacional de Cegos de España)Prevención da cegueiraDescrición de deficiencias visuais (Disc@pnet)Braillín, un boneco atractivo para calquera neno, con ou sen discapacidade, que permite familiarizarse co sistema de escritura e lectura brailleAxudas Técnicas36838ID00897494007150-90057129528256DOID:1432HP:0000618D001766C10.597.751.941.162C97109C0155020