Freaks City

Overview of RMAN RMAN (Recovery Manager) performs physical backups and supports point-in-time recovery. It operates in two database modes: Archivelog mode: Allows both offfline (cold) and online (hot) backups. Noarchivelog mode: Only offline backups are permitted. Using RMAN Connect to the target database from the server: rman target / # or w ...

Creating the Test Database CREATE DATABASE partition_demo CHARACTER SET utf8 COLLATE utf8_unicode_ci; Creating the Table Note: The column used for partitioning must be part of the primary key. USE partition_demo; CREATE TABLE event_logs ( id BIGINT(20) NOT NULL AUTO_INCREMENT, event_time DATETIME NOT NULL, message VARCHAR(200), ...

Introduction Data is stored in various formats including text, images, and video, which computers interpret as binary or hexadecimal machine language. Depending on the importance and complexity of the information, different management strategies are required. Databases are best suited for storing critical data with complex relationships. Datab ...

Environment Variable Configuration Establish system paths to execute utilities globally from any directory. Access System Properties through the control panel or desktop shortcuts. Navigate to Advanced settings followed by Environment Variables. Within the System variables section, create a new entry named MYSQL_INSTALL_DIR assigning it to your ...

Greenplum 6 provides robust partitioning capabilities that allow for efficient data management. This guide presents an enhanced automatic partitioning solution that supports daily, monthly, and yearly partitioning strategies with dynamic future partition creation. Partition Management Function The following function automates partition creatio ...

System Preparation and Kernel Tuning Establish dedicated system accounts and directory structures before initiating the deployment. Use a privileged terminal session to execute the following group and user provisioning commands: groupadd dbadmin_grp groupadd dboper_grp useradd -g dbadmin_grp -G dboper_grp -m odbsvc passwd odbsvc id odbsvc Desi ...

1. Common mysql Command Options 1. --auto-rehash (tab completion for table names and fields) # mysql -u root --auto-rehash # vim my.cnf [mysql] auto-rehash 2. -B (disable history file, non-interactive mode) # mysql -uroot -D test -e "show tables;" -B 3. -E (vertical output for query results) # mysql -uroot -D test -e "sho ...

The db file sequential read wait event represents time spent waiting for single-block I/O operations. Unlike db file scattered read, which fetches multiple blocks into non-contiguous SGA buffers, sequential reads target one block at a time—typically into contiguous memory locations within the process workspace. It commonly arises when accessing ...

MariaDB Installation Process Execute the following command to install both server and client components: sudo apt-get install mariadb-server mariadb-client Verifying Installation Status Checking Version mysql --version Example output: mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) Checking Service Status sudo service m ...

-- Identify databases with unused space SELECT table_schema AS database_name, table_name, data_free, ENGINE FROM information_schema.tables WHERE table_schema NOT IN ('sys', 'mysql', 'performance_schema', 'information_schema', 'test') AND data_free > 0; -- Calculate total storage per database SELECT table_schema AS dat ...