MariaDB

From InfiniteERP Wiki
Revision as of 05:33, 17 April 2022 by Wikiadmin (talk | contribs) (Backup & Restore)
Jump to: navigation, search

Introduction

Database Maintenance and Monitoring script

Backup & Restore

refer to https://mariadb.com/docs/recovery/backup-optimization/

sudo mariabackup --backup \
      --user=root \
      --password=P@ssw0rdINDO7Kali \
      --target-dir=/home/backup/db

sudo mariabackup --prepare \
      --target-dir=/home/backup/db

Monitor Index status dan size for optimization

Monitor Cache Hit Ratio

Monitoring Database Query Performance

Locks held by Open Transactions

Check Trigger Status

How to