alright so i installed zabbix yesterday around this time and its monitoring 4 servers. In this ammount of time, this is my mysql stats...
66 table(s) Sum 1,028,315 MyISAM latin1_swedish_ci 43.9 MiB 2.7 KiB
basically 1 million rows in 24 hours and 44Mb space... is this normal? if not.. im guessing the polling frequency is way too often and how do i change it to something around once every minute or something? basically all the time i see my mysql process at 5% cpu from zabbix putting in data from the zabbix_server and agent. My server load was also around .05 before now its at a solid 1.. please let me know about this and how to fix this... at this rate i cant have much data without having to prune it.
PS: its averaging around 100-200 rows every couple of seconds inserting.
66 table(s) Sum 1,028,315 MyISAM latin1_swedish_ci 43.9 MiB 2.7 KiB
basically 1 million rows in 24 hours and 44Mb space... is this normal? if not.. im guessing the polling frequency is way too often and how do i change it to something around once every minute or something? basically all the time i see my mysql process at 5% cpu from zabbix putting in data from the zabbix_server and agent. My server load was also around .05 before now its at a solid 1.. please let me know about this and how to fix this... at this rate i cant have much data without having to prune it.
PS: its averaging around 100-200 rows every couple of seconds inserting.
Comment