Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Cleaning of zabbix historical data and excessive processing of libdata1 files

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

A historical data cleaning

Stop related services and avoid writing data

/ etc/init.d/zabbix-server stop

/ etc/init.d/httpd stop

Emptying historical data

Mysql-uroot-p

Use zabbix

Truncate tablehistory

Optimize tablehistory

Truncate tablehistory_uint

Optimize tablehistory_uint

Truncate tabletrends

Optimize tabletrends

Truncate tabletrends_uint

Optimize tabletrends_uint

Back up the database and modify the independent tablespace

Mysqldump-R-Q-- all-databases > / opt/all.sql

/ etc/init.d/mysqld stop

Rm-fr / var/lib/mysql/*

Vim / etc/my.cnf

# set under [mysqld]

Innodb_file_per_table=1

Mysql_install_db # initialize mysql database

/ etc/init.d/mysqld start

Check whether the innodb_file_per_table parameter is in effect

Mysql-uroot-p

Mysql > showvariables like'% per_table%'

+-+ +

| | Variable_name | Value |

+-+ +

| | innodb_file_per_table | ON |

+-+ +

1 row in set (0.00 sec)

Mysql

< /opt/all.sql 三 删除数据库中zabbix原用户并重新配置 Mysql>

Dropuser zabbix@'localhost'

Mysql > grantall privileges on zabbix.* to zabbix@'localhost' identified by 'zabbix'

Mysql > flushprivileges

4. Enable zabbix and httpd services

/ etc/init.d/zabbix-server start

/ etc/init.d/httpd start

Five reference materials

Http://www.linuxidc.com/Linux/2014-12/110353.htm

Http://6034036.blog.51cto.com/6024036/1636779

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report