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

RemoteApp sporadic failureWindows 2008 RemoteAPP client disconnects within a matter of minutesWhat is the minimum version of RDP supported by Server 2012 RDS?How to configure a Remoteapp server to increase stabilityMicrosoft RemoteApp Active SessionRDWeb TS connection broken for some users post RemoteApp certificate changeRemote Desktop Licensing, RemoteAPPRDS 2012 R2 some users are not able to logon after changed date and time on Connection BrokersWhat happens during Remote Desktop logon, and is there any logging?After installing RDS on WinServer 2016 I still can only connect with two users?RD Connection via RDGW to Session host is not connecting

How to write a 12-bar blues melodyI-IV-V blues progressionHow to play the bridges in a standard blues progressionHow does Gdim7 fit in C# minor?question on a certain chord progressionMusicology of Melody12 bar blues, spread rhythm: alternative to 6th chord to avoid finger stretchChord progressions/ Root key/ MelodiesHow to put chords (POP-EDM) under a given lead vocal melody (starting from a good knowledge in music theory)Are there “rules” for improvising with the minor pentatonic scale over 12-bar shuffle?Confusion about blues scale and chords

Esgonzo ibérico Índice Descrición Distribución Hábitat Ameazas Notas Véxase tamén "Acerca dos nomes dos anfibios e réptiles galegos""Chalcides bedriagai"Chalcides bedriagai en Carrascal, L. M. Salvador, A. (Eds). Enciclopedia virtual de los vertebrados españoles. Museo Nacional de Ciencias Naturales, Madrid. España.Fotos