Difference between revisions of "MariaDB"

From InfiniteERP Wiki
Jump to: navigation, search
(Backup & Restore)
Line 4: Line 4:
  
 
== Backup & Restore ==
 
== Backup & Restore ==
 +
 +
refer to https://mariadb.com/docs/recovery/backup-optimization/
 +
 
<pre>
 
<pre>
 
sudo mariabackup --backup \
 
sudo mariabackup --backup \

Revision as of 05:33, 17 April 2022

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