NAV: SLTechnology News&Howtos > Database >

• 

  Manual hot backup

  Manual hot backup step: open backup is only used for archive mode, and execute the command before hot backup: hot backup step: alter database/tablespace XXX begin backup will cause the lock block, and the scn number will not change. C

  2022-06-01 16:14:15 Views: 266
• 

  Personal Learning Notes-MySQL Multi-instance configuration

  The prerequisite is to install MySQL server ideas: start multiple mysqld processes, plan multiple sets of data, plan multiple sets of data, plan multiple sets of log paths, and configure multiple instances: create multiple directories: mkdir-p / data/330 {7c8 and 9} prepare multiple sets of configuration files: vim

  2022-06-01 16:14:14 Views: 285
• 

  Db2 rollforward session

  Roll forward session-the CLP sample ROLLFORWARD DATABASE command allows you to specify multiple operations at a time, separated by the keyword AND. For example, to roll forward to the end of the log and then finish, you can use the following separate command: db2

  2022-06-01 16:14:14 Views: 261
• 

  Cbc latch in logical Reading (2)

  To continue the verification, use dtracesession1 in solaris: write the dtrace script more test.daub _ ndtrace:::BEGIN _ DTrace-s-bind {I

  2022-06-01 16:13:49 Views: 297
• 

  [exp/imp] Import the dmp file of US7ASCII character set into the database of ZHS16GBK character set

  [exp/imp] Import the dmp file of the US7ASCII character set into the database of the ZHS16GBK character set 1.1 BLOG document structure figure 1.2 introduction 1.2.1 introduction and precautions all technical enthusiasts, after reading this article, you can master

  2022-06-01 16:13:49 Views: 204
• 

  Open source components: (1) DBCP and C3P0

  The emergence of a technology is either to solve practical problems or to optimize existing technologies. The emergence of database connection pool technology is to optimize the performance of database connection operations. When using JDBC for database development, we generally go through the following process: 1) load the driver of the database; 2) set up the number of

  2022-06-01 16:13:48 Views: 228
• 

  Introduction of xtrabackup and backup principle

  1. Xtrabackup introduces xtrabackup's open source software implemented by percona based on innodb's ibbackup, which completely covers the functions of ibbackup and is completely free, which is the conscience of the industry.

  2022-06-01 16:13:48 Views: 207
• 

  The opening and Analysis method of full (query) Log general-log of mysql

  Friends who are familiar with mysql should know that the error log only records errors in the database layer, and binlog only records add / delete / change records, but does not record who executes it, and only records the execution user name. Although slowlog is detailed, it only records slow query sql messages that exceed the set value.

  2022-06-01 16:13:48 Views: 272
• 

  Details of the steps to uninstall Oracle11g

  With the uninstall program that comes with Oracle, you can't uninstall Oracle fundamentally, leaving a hidden danger for the next installation, so how can you uninstall Oracle completely? That is to clear the registry directly. The steps are as follows: 1. Start-> Settings-> Control Panel-> Administrative tools-> Server.

  2022-06-01 16:13:44 Views: 298
• 

  MySQL- multi-version and multi-instance hybrid deployment

  1. Background * centralized operation and maintenance of MySQL database can be deployed to run multiple MySQL service processes on a server, and different socket listens to different service ports to provide their own services. Each instance is independent of each other, and the dat of each instance

  2022-06-01 16:13:44 Views: 237
• 

  Introduction to ORACLE Certification

  About ORACLE examination OCP (Oracle Certified Professional) is an authoritative professional and technical standard promulgated and implemented by Oracle. It is designed to certify services that can meet the requirements of ORACLE core products.

  2022-06-01 16:13:37 Views: 279
• 

  Mysql-- Index (query)

  What is an index if there is no index, the number of records scanned is greater than the value of the index column stored in the index (for example, if id is an index column, then the value of the index column is stored), and the address of the row corresponding to the index value in memory (or directly stores the data of the row) SELECT * FROM

  2022-06-01 16:13:37 Views: 257
• 

  Set up gitlab environment locally, configure mail notifications and basic operations

  Go to the gitlab official website, select the corresponding operating system-- CentOS 6 (and RedHat/Oracle/Scientific Linux 6), and follow the official instructions to install: install and configure the necessary dependencies on Centos.

  2022-06-01 16:13:36 Views: 250
• 

  Basic operation of Sqoop ETL tool

  Basic operation of the Sqoop ETL tool View sqoop Command description sqoop help View instructions for the use of a command: sqoop cammond-help from orange,mysql to hdfssqoop impor

  2022-06-01 16:13:36 Views: 230
• 

  Redis original code installation

  Background: as a very popular nosql, redis should be held by both operation and maintenance staff and developers. Here is an installation of the original code of redis, which installs 1LWget http://download.redis.io/releases/r.

  2022-06-01 16:13:36 Views: 231
• 

  Create DBlink

  Create DBlink to cmscreate public database link CMS connect to cmsxb identified by sph using'(DESCRIPTION)

  2022-06-01 16:13:35 Views: 244
• 

  Creating a new index can improve the query performance of three SQL simultaneously.

  For example, CREATE TABLE `score` (`id` int (11) NOT NULL, `studentid` int (11) NOT NULL, `classtid` int (11)

  2022-06-01 16:13:35 Views: 227
• 

  Rman backup script

  #! / bin/bash## backup oracle database# date: 2019-6-2

  2022-06-01 16:13:26 Views: 296
• 

  AOF of Redis persistence

  Background: the deficiency of RDB 1. Time-consuming, performance-consuming, snapshot file generation time-consuming, load snapshot file time-consuming Fork sub-process network overhead, write file disk Imax O cost 2. Uncontrollable, losing data will lose the data of the last snapshot and the last operation. 1. Workflow Redis write operation orders

  2022-06-01 16:13:26 Views: 297
• 

  Connect to the MySQL database with C # under Linux.

  There are two ways to connect to a MySQL database with cased ADO: first, connect with ADO; second, connect with MySQL's own API function; first, ADO can connect to multiple databases, such as mysql, sqlserver, and ora.

  2022-06-01 16:13:26 Views: 290