Database Administrator

Percona-toolkit installation and introduction MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many powerful third-party

Build MongoDB Service Based on CentOS 6.5 Operating System MongoDB is a non-relational database (NoSQL) that is very popular in the IT industry. Its flexible data storage method is favored by current IT practitioners. MongoDB implements the

Migrate the Oracle database from the 32-bit platform to the 64-bit The disk of the customer's 32-bit Oracle database system is damaged. Fortunately, the Oracle database is intact. The customer requested that the database be migrated to the newly

Oracle input error count modification, user unlock, password expiration By default, Oracle databases lock users after 10 failed attempts; 1. view the FAILED_LOGIN_ATTEMPTS Value Select * from dba_profiles; 2. Change it to 30 alter profile default

Data backup and Database Replication in Oracle user management mode The first thing to note is that Oracle Database Backup can be divided into logical backup and physical backup. Logical backup backs up data through data export, mainly through the

MySQL Database Import and Export When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work: Import: Import data

Can rename table but can not truncate table, renametruncateA table cannot be truncate but can be rename. This sounds strange at first. The process is simulated below.Three sessions:Session1 performs the truncate and rename operations;Session2

Oracle dynamic display log, oracle dynamic log   1. view the location of the log file; IND_USER @ PROD> select inst_id, name, value from v $ diag_info; INST_ID NAME VALUE--------------------------------------------------------------------------------

Oracle session and connection optimization, oracle session 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQL> show parameter processes; NAME TYPE VALUE----------------------------------------

Use Case Analysis of database Optimization Using Virtual Index and virtual Case AnalysisWhen we optimize the production database, we mainly optimize SQL statements, including equivalent statement rewriting. However, a large part of the optimization

OpenCV basics-Mat data structure and opencv BasicsProcedure and Analysis /* * FileName : MatObj.cpp * Author : xiahouzuoxin @163.com * Version : v1.0 * Date : Thu 15 May 2014 09:12:45 PM CST * Brief : * * Copyright (C) MICL,USTB

Mybatis type conversion when using generator to automatically generate code, mybatisgenerator Use the generator of mybatis to automatically generate code, but in the oracle database, number (6, 2) is always automatically converted to BigDecimal, and

ADO. NET-data reader, DataReader --- ShinePans, Depending on different data providers, DataReader can be divided into four categories: SqlDataReader, OleDbDataReader, OlbeDataReader and OracleDataReader A clever analogy: if the database is a

Oracle rman recovery from different machines and oracle Lerman recovery   Oracle source host Oracle target host Host Platform CentOS6.2 (final) CentOs6.2 (FInal) Host Name Vick Rman IP address

Java Dynamic proxy and CGLib proxy for IT Ninja Turtles, and cglib for ninja turtles public class UserDAOImpl { public void save (){ // TODO Auto-generated method stub System. out. println ("user saved "); } } // related configuration,

"Unable to locate the update row" is reported when MYSQL is updated using ADO. Some values may have been changed after the last read. This strange error occurred when I used ADO to connect MYSQL to update data through ODBC in DELPHI today: the row

Multi-threaded SQL statements that do not repeatedly read data from SQL Server tables When sending text messages or emails, we often use a table to store the data to be sent, multiple threads in the background constantly read the data to be sent

ORACLE Experiment 2: oracle Experiment Experiment 2: Data manipulation Lab hours: 4 hours Lab type: Comprehensive Lab requirements: Required I. Tutorial Purpose 1. Master SQL data query statements; 2. Master the use of SQL Aggregate functions; 3.

Accidental deletion of stored procedures, accidental deletion of file restoration Software After the stored procedure is deleted by mistake, use the following statement to locate the deleted stored procedure and restore it. You need to log on with

Use the FREDATED engine for cross-instance access, and the fredated engine for cross-instance access Cross-database server and cross-instance access is a common access method, which can be implemented through db link in Oracle. For MySQL, there is a