ZABBIX Housekeeper - What You Need To Know
HTML-код
- Опубликовано: 15 май 2022
- Housekeeper 100% busy or database size growing with every hour. These may be the main problems that make you wonder what a housekeeper actually is, what it does, and are there any ways to improve it. Unfortunately, without fully understanding how it works, it is very easy to make even more harm while trying to fix the problem.
☕ In case if you want to support this content with coffee:
☕ www.buymeacoffee.com/dmitryla...
👋 SOCIAL MEDIA
📹 TWITTER - @RealDeimons
🔔 INSTAGRAM - / dmitrylambert
📫 Sign Up For Newsletter And Don't Miss Out on Anything
📫 tinyurl.com/4sz2ewfb
📌 Hey everyone! Did you know you can get exclusive early access to my videos, behind-the-scenes content, and more by becoming a Patreon supporter? By joining our Patreon community, you'll not only be the first to watch new videos, but you'll also be directly supporting the creation of future content. Your support means the world to me and helps me continue to provide free, high-quality tutorials like this one. Click the link below to learn more and become a patron today! 😊
🔗 patreon.com/dmitryl
Thank you for your continued support! 💙
for postgresql U could use pg_repack or offline Vacuum full manualy in each of bloated tables
You are the best Dmitry ! :)
Also, would be great if you put up a video about archiving/backing up databases, history etc.
Next video: MySQL/MariaDB Table Partitioning ;-)
We are also having some issues with slow queries i see locks in Postgre for that 15min and get no data for 15 mins.We have 40000items even more.
Hi @Dmitry. Thank You.
So..my S3 buckts has been discovered. But my EC2 instances still not discovered. You talked about Tag in these instances. In my case I have 2 tags by intance. Could be this the problem?
What’s the difference between history and trends ?
History Is raw data. Trends Is aggregated min max avg for 1 hour, that’s why it is much more efficient for disk space while still giving insights
What if the housekeeper's proccess is 100% just for 4-5 minutes/hour, then goes to 0 % ?
That’s pretty much ok
@@DmitryLambert What if the time increases to 40 min/hour ?
Збс. Четко.
I have a simple 2 CPU, 4 GB RAM and 70 GB total disk space, virtual private server.
I cannot afford for database to grow above 10 or 12GB disk space.
I'm using PostgreSQL.
What housekeeping periods should I set, to keep my database size below 10 or 12GB ?
It's impossible to measure it like that, not knowing your nvps and type of monitored data
Hi, Housekeeper when running is always on 100% for a few hours, causing performance issues. We migrated the database from 5.0 to 6.0 (from MySQL 5.7 to MySQL 8.0) I noticed in the logs folowing entry foe each record:
1662593:20220819:132300.916 query without transaction detected
1662593:20220819:132300.916 query [txnlev:0] [delete from history_uint where itemid=243742 and clock