pfile and spfile Overview Oracle stores initialization parameters in configuration files that are loaded during instance startup. These files define the database's physical structure, memory allocation, system constraints, and various default values. Oracle supports two types of parameter files: pfi...
MongoDB Routine Inspection Commands Overview Table of Contents- MongoDB Routine Inspection Commands Overview - Monitoring System Operational Status - Checking Collection and Index Status - Replica Set Synchronization Status - Sharding State Monitoring - Balance Operation Status - System Performance...
Defining Memory FragmentationWhen Redis deallocates memory, the freed space is not immediately returned to the operating system. Instead, it remains under the control of the underlying memory allocator. A critical issue arises when these released blocks are non-contiguous. While technically free, th...
Introduction Like most database systems, MongoDB relies on several log types to track different aspects of its operation. Understanding these logs is essential for monitoring, troubleshooting, and ensuring data integrity. MongoDB primarily uses four kinds of logs: System logs, Journal logs, the Oplo...
Databases function as structured repositories for persistent data management. Unlike transient memory variables or isolated local files, database systems enable concurrent access, network sharing, and robust integrity controls. Systems are broadly categorized into relational and non-relational archi...
Starting the Cluster gpstart -a # bring the entire cluster online gpstop -r # restart after configuration changes that require reboot gpstop -u # reload config files without stopping services Master-only Maintenance Mode gpstart -m # start master in utility mode PGOPTIONS='-c gp_session_role=utility...
Create the target directory structure. The server binaries will reside under /usr/local/mysql, and the data files will be placed in /mysql/data. mkdir -p /usr/local/mysql /mysql/data Download the MySQL community server tarball and extract it to the installation directory. Rename the unpacked folder...
Error Log Diagnostics The error log tracks server startup, shutdown, and critical runtime failures. Locate the active error log path: SELECT @@GLOBAL.log_error; To modify the destination, update the instance configuration: [mysqld] log_error=/var/log/mysql/instance_error.log Apply changes by restart...
Redo Logging Modes Overview Redo logging controls how much information Oracle writes to on line redo log files during data changes. Three principal modes exist: LOGGING: Default mode where all DML and object creation actions generate redo entries. Suitable for most database objects; NOLOGGING is gen...
InnoDB Gap Lock Mechanism Gap locks are index interval locks that address phantom reads, active exclusively in InnoDB’s REPEATABLE READ isolation level. Instead of targeting existing index entries, they block operations on open ranges between index records, excluding the records themselves. For a ta...