Database Administrator

MySQL Vertical Split (Reading Notes)1. Vertical Split Compared with horizontal split, vertical split is easier to implement. Vertical Split means to split different business data in the database into different databases. Vertical splitting can

Beckham _ mysql trigger and Beckham _ mysql triggerTriggerBrief1. Basic concepts of triggers2. Trigger syntax and practical examples3. Differences between before and after   I. Basic concepts of triggers 1. Instant Transmission 2. Role: monitor a

InnoDB Insert (Insert) operation (II)-mysql technology insider, innodb-mysql I want to prove the relationship between the mysql innodb Storage engine, commit operations, and flush data to the disk. After talking with colleagues, he said, you

Locate the problem of log file switch (checkpoint incomplete), incompletezipfile Today, in the test environment, the application is slow and an error occurs in the database. Report the error directly to AWR.Because it is a virtual machine, you do

SQL queries the example of the table, stored procedure, trigger Creation Time, and last modification time. The creation time is modified. -- Query creation time -- table select * from sysobjects where id = object_id (n'table name ') and xtype = 'U'

MATLAB data analysis and mining practices, matlab data analysis practicesThis is a high-quality pre-sale recommendation for database storage and management in computers, MATLAB data analysis and mining practices.With more than 10 years of practical

LIST type of Redis data type, list type of redis Data Type Web programmer blog: http://blog.csdn.net/thinkercode List type-Features List is a linked list structure. The main function is to push, pop, get all values in a range, etc. In the

Analysis of data leakage investigation report in 2014 and investigation report in 2014Web application attacks are one of the top concerns about Verizon data leakage Investigation Report (DBIR) data disclosure in 2014. These events mainly affect

Calculus is the grand entrance hall of the modern mathematics building. As you know, you must first step into the lobby of the building. Kongji is the gatekeeper of the mathematics building. Anyone entering the math building must "Say hello" to the

The ORA-00354 caused by a read-only rhel5.8 File System: upt redo log block header, An rhel5.8 file system read-only caused by ORA-00354: upt redo log block header Wed Jun 03 03:31:24 CST 2015 Thread 1 advanced to log sequence 396 (LGWR switch)

Recent R learning overview and R learning OverviewI have been a little busy recently, and I am learning a little less. Previously, I learned the R language for a short period of time, mainly in R language practice. I read a part of it and practiced

Install and use mongodb 1. Install and start MongoDB Widndows and linux are basically the same 1. Download the database, Mongodb-linux-x86_64-ubuntu1404-3.0.3.tgz: linux 2. decompress the file and place it in a proper location. Tar-vxf mongodb-linux-

Mysql Character Set and verification set, mysql Verification I. Character Set 1. mysql's Character Set settings are flexible You can set the default Character Set of the server; Default Character Set of the database; The default Character Set of the

Oracle BASICS (5): Multi-Table query and oracle basic table Query I. Multi-Table query (1) simple multi-Table query 1. Multi-Table query mechanism 1) SQL: SELECT * FROM emp; -- 14 records SELECT * FROM dept; -- four records SELECT * FROM emp, dept; -

Oracle BASICS (4): Single Table query and oracle basic Single Table query 1. Basic Query(1) Basic Statement 1. Syntax Select [distinct] * | {Column name...} from table name [where {condition }] 2. Note 1) distinct: Indicates whether duplicate

ORA-28001: the password has expired, ora-28001expired Oracle prompt error message ORA-28001: the password has expiredCause: due to the new features of Oracle 11G, the default password expiration limit for Oracle 11G users is 180 days.

File attachment or query results size exceeds allowable value of 1000000 bytes, exceedsallowable DECLARE @ tab char (1) = CHAR (9) EXEC msdb. dbo. sp_send_dbmail @ profile_name = 'backgroundy', @ recipients = 'xxx @ wuxiapptec.com ', @ query =

SQL Server INSTEAD OF UPDATE view trigger problem, sqlserverinstead An error occurs when the system's instead of update view trigger is associated with table UPDATE: Message 414, level 16, state 1, 1st rowsUPDATE is not allowed, because this

MySQL Server SWAP usage is high, which causes db to be very slow and slow. mysqlswapHigh usage of MySQL Server SWAP causes slow dbEnvironment Introduction:CentOS: 6.XMySQL version: 5.5.40Fault Cause Analysis:The physical memory is 16 GB, And the

ADO. NET -- DataAdapter object, ado. netdataadapter DataAdapter object Source and function: In the ADO. NET object I introduced earlier, such as the Connection object, Command object, and DataReader object, all of these objects belong to the Data