Zhong Weicheng Study Notes

原创 Oracle 11.2.0.4.0 Released

原创 Shell Script For MySQL Enterprise Backup Crontab Schedule

#!/bin/ksh #prints usage usage() { echo "$VERSION" echo " Usage: `basename $0` [command] [MEB options] Commands: full make full backup incremental

原创 PostgreSQL View the table structure

command line testdb=> \dt List of relations Schema | Name | Type | Owner --------+-----------+-------+------- public | orderinfo | table | zwc (1 row) testdb=> testdb=> \d orderin

原创 How to Create Partial Backups Using MySQL Enterprise Backup

Few usage examples. We have following setup for our tests: Tables t1, t2, d1, d2 in all databases use InnoDB storage engine and tables t11, t12, d11, d12 use MyISAM storage engine. mysql> sho

原创 How to recover a single InnoDB table from a Full Backup

You must set var innodb_file_per_table = 1 [root@zhongwc ~]# /service/mysql/bin/mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is

原创 MySQL使用information_schema获取锁表信息

information_schema SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, TIMESTAMPDIFF( SECOND, r.trx_wait_started, CURRENT_TIMESTAMP ) wait_time, r.trx_query waiting_query

原创 Oracle DBlink 比较两边对象和数据

对象比较 select a.object_type, a.ds_count, b.dt_count, ds_count - dt_count minus_count from (select object_type, count(*) ds_count from dba_objects@dbverify wher

原创 Oracle Logical Replication install check scripts

set null "NULL VALUE" set feedback off set heading off set linesize 132 set pagesize 9999 set echo off set verify off set trimspool on col table_name for a30 col column_name for a30 col data_type fo

原创 Use Innotop Monitoring MySQL

install [root@mytest ~]# tar -zxvf innotop-1.9.0.tar.gz innotop-1.9.0/ innotop-1.9.0/t/ innotop-1.9.0/t/InnoDBParser.t innotop-1.9.0/t/innodb-status-001 innotop-1.9.0/t/innodb-status-002 innotop-1.9