Database Administrator

Use Windows performance monitor to monitor common SQL Server metrics As mentioned in the above article, Win's Performance Monitor is an essential tool for monitoring database performance. Next I will introduce some common monitoring metrics, which

Install Percona Server using a binary tar package Install Percona Server using a binary tar package InstallingPercona ServerFrom a Binary Tarball1. Download the binary tar package Take version 5.6 as an example. Go to the official website

Use XtraBackup to perform Online Incremental backup and database restoration for MySQL 1. Introduction to Percona Xtrabackup 1. Xtrabackup bin directory file Introduction 1) innobackupex Innobackupex is a symbolic link of xtrabackup. innobackupex

Implement RowNumber () Over (Partition by) and qlikviewrownumber in SQL Server in QlikView This is often the case when field A has many duplicate values, but the values in field B are unique After grouping by field A. Therefore, SELECT, when field B

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package, fifa 14rpm **************************************** ******************************** ************** Original Works are from the blog

Java oci connection oracle throwing java. lang. UnsatisfiedLinkError: ocijdbc11..., ocijdbc11 First, the oracle client is successfully installed. Use the sqlplus tool to connect to the local service name configured by TNSNAMES. ORA, for

Sqlite study notes 7: Open the database using sqlite in C language, sqlite Study Notes The basic content of the database has been mentioned earlier. Next, let's take a look at how to use sqlite in the C language. Interface 1 sqlite3_open(const char

Transaction Processing and concurrency control, transaction processing Concurrency Control What is a transaction? Is a mechanism, an operation sequence, it contains a group of database operation commands, and all the commands as a whole, together to

Oracele Timesten connects to DSN to create a user, oraceletimesten 1. Enable startup [Tt @ host2 info] $ ttDaemonAdmin-start-force /Home/tt/TimesTen/tt1122/info/timestend. pid file exists, attempt start due to-force option. TimesTen Daemon startup

SQL Server Performance Tuning 3 Index MaintenancePreface The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you

Krist ófskács, a software architect and consultant who once worked in a number of major companies, blogs on mainstream NoSQL databases (Cassandra, Mongodb, CouchDB, Redis, Riak, Membase, Neo4j, and HBase)) A comprehensive comparison was

Full process of installing MySQL 11.04 through apt in Ubuntu 5.1: Read: MySQL 5.5.11 compiling and Installation notes in Linux (complete installation tutorial) compile and install MySQL dual-instance in Ubuntu and configure master-slave replication

Oracle provides the following explanations for ASCII and CHR functions: ASCII (x) gets the ASCII value of the character X, CHR () and ASCII () have the opposite effect. That is, the ASCII function is used to convert characters into their

For details about how to use the count function in MySQL, mysqlcount The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*)

RedHat Linux 6.2 Oracle10g installation and configuration Manual The following are all root user operations: 1. Installation preparation 1.1 RedHatLinux Server 6.2 Installation File RatHatLinuxServer-6.2-x86_64.iso 1.2 Oracle10g Linux Installation

SQLite tutorial (III): Introduction to data tables and views, sqlite View 1. Create a data table: The syntax rules and usage of this command are basically the same as those of most relational databases. Therefore, we use examples to demonstrate the

Basic DB2 database operations and basic db2 operationsStart the DB2 service: db2startDisable the DB2 service: db2stop1. load data:1. load with the default separator. The default value is ",".Db2 "import from btpoper.txt of del insert into btpoper"2.

MongoDB data model and index learning summary, mongodb ModelMongoDB data model and index learning Summary 1. MongoDB Data Model: MongoDB data storage structure:MongoDB uses BSON (binary json, binary encoding) data format for document (large files

DB link migration (the password in dblink is unknown), dbdblinkI don't know if DBAs sometimes encounter such a situation where the Public db link is used for Schema migration. However, the target account password in db link is unknown, therefore,

SQL Server trigger and SQL Server triggerSQL Server triggers A trigger is a special type of stored procedure, which is different from the stored procedure we introduced earlier. A trigger is triggered by an event and automatically called for