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

Wikipedia:Vital articles Мазмуну Biography - Өмүр баян Philosophy and psychology - Философия жана психология Religion - Дин Social sciences - Коомдук илимдер Language and literature - Тил жана адабият Science - Илим Technology - Технология Arts and recreation - Искусство жана эс алуу History and geography - Тарых жана география Навигация менюсу

Bruxelas-Capital Índice Historia | Composición | Situación lingüística | Clima | Cidades irmandadas | Notas | Véxase tamén | Menú de navegacióneO uso das linguas en Bruxelas e a situación do neerlandés"Rexión de Bruxelas Capital"o orixinalSitio da rexiónPáxina de Bruselas no sitio da Oficina de Promoción Turística de Valonia e BruxelasMapa Interactivo da Rexión de Bruxelas-CapitaleeWorldCat332144929079854441105155190212ID28008674080552-90000 0001 0666 3698n94104302ID540940339365017018237

What should I write in an apology letter, since I have decided not to join a company after accepting an offer letterShould I keep looking after accepting a job offer?What should I do when I've been verbally told I would get an offer letter, but still haven't gotten one after 4 weeks?Do I accept an offer from a company that I am not likely to join?New job hasn't confirmed starting date and I want to give current employer as much notice as possibleHow should I address my manager in my resignation letter?HR delayed background verification, now jobless as resignedNo email communication after accepting a formal written offer. How should I phrase the call?What should I do if after receiving a verbal offer letter I am informed that my written job offer is put on hold due to some internal issues?Should I inform the current employer that I am about to resign within 1-2 weeks since I have signed the offer letter and waiting for visa?What company will do, if I send their offer letter to another company