MariaDB

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

Introduction

Database Maintenance and Monitoring script

Backup & Restore

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