Difference between revisions of "MariaDB"

From InfiniteERP Wiki
Jump to: navigation, search
(Created page with "= Introduction = = Database Maintenance and Monitoring script = == Monitor Index status dan size for optimization == == Monitor Cache Hit Ratio == == Monitoring Database...")
 
Line 6: Line 6:
  
 
== Monitor Cache Hit Ratio ==
 
== Monitor Cache Hit Ratio ==
 
  
 
== Monitoring Database Query Performance ==
 
== Monitoring Database Query Performance ==
  
== Locks held by Open Transactions (pg_locks) ==
+
== Locks held by Open Transactions ==
  
  
 
== Check Trigger Status ==
 
== Check Trigger Status ==
 
 
== Monitor LIVE and DEAD Tupples ==
 
 
 
 
== Monitor LIVE and DEAD Tupples with AUTO VACUUM ==
 
  
  

Revision as of 05:28, 17 April 2022

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

Check Trigger Status

How to