solve, automate, speed up

Zabbix MySQL

MySQL zabbix data table backup and upload

mysqldump and restore without a data file

Aborted connection to db, Got timeout reading communication packets

MySQL monitoring, Zabbix, agentd, agent1

Assign bare minimum permissions

Backup database with MySQL shell, alternative to mysqldump, mysqlsh

Could not execute Delete_rows event on table, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND

FOREIGN_KEY_CHECKS=0 before zcat

Manually backup historical data

select from full process list where info mysql, processlist

Size per tables

Reset MySQL root password

MySQL, Insert into ignore, sql gz

Migrate innodb_file_per_table 0 to 1, MariaDB 5.5

What happens to objectid, triggerid

Drop create index contraint alerts

Enable high precision float values, Zabbix 5.0

Optimize mysql table, the safe way

Delete all historical data, leave only current day

MySQL backup schema only