MariaDB

From InfiniteERP Wiki
Revision as of 05:28, 17 April 2022 by Wikiadmin (talk | contribs) (Created page with "= Introduction = = Database Maintenance and Monitoring script = == Monitor Index status dan size for optimization == == Monitor Cache Hit Ratio == == Monitoring Database...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

Database Maintenance and Monitoring script

Monitor Index status dan size for optimization

Monitor Cache Hit Ratio

Monitoring Database Query Performance

Locks held by Open Transactions (pg_locks)

Check Trigger Status

Monitor LIVE and DEAD Tupples

Monitor LIVE and DEAD Tupples with AUTO VACUUM

How to