Created
December 10, 2022 13:08
-
-
Save sric0880/cc04f44317d8911f9463fa34fdab44c3 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| mysql -uzabbix -pzabbix -e" | |
| use zabbix; | |
| truncate table history; | |
| optimize table history; | |
| truncate table history_log; | |
| optimize table history_log; | |
| truncate table history_str; | |
| optimize table history_str; | |
| truncate table history_uint; | |
| optimize table history_uint; | |
| truncate table alerts; | |
| optimize table alerts; | |
| truncate table trends; | |
| optimize table trends; | |
| truncate table trends_uint; | |
| optimize table trends_uint; | |
| delete from events; | |
| optimize table events; | |
| " |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment