Database Administrator

MySQL Character Set and verification set 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 table; Column

PostgreSQL vacuum Principle 1 Functions and Parameters From the previous article "PostgreSQL MVCC source code implementation []", we know that PG does not store the old version of undo like Oracle, but directly stores the old version in the relation

NUMBER (x, y) Data Types in Oracle databases Test preparation Analyze and Experiment Processing of 1 decimal part 2. Maximum value that can be saved 3. Minimum value that can be saved Summary The NUMBER data type of Oracle

MySQL innodb_table_stats table does not exist MySQL version 5.6.14 The company's error logs for several MySQL servers show that several system tables do not

When the database resource consumption is high, two SQL statements that are simple and useful to quickly identify possible causes of problems, resource consumption SQL 1. view the SQL statement being executed (1) SQL statement: Selectdistinct s. sid,

Redis sentinel cluster construction and Jedis test graphic tutorial [2], redisjedis In Redis, the establishment of sentinel clusters and the Jedis test graphic tutorial [1] have already written the setup and testing of sentinel clusters in Redis.

Hibernate Association ing and hibernate AssociationThis document serves as a learning note for the hibernate course for Ma soldiers at Beijing shangxue.com.Hibernate ing is mainly divided into one-to-one, one-to-many, one-to-one, and many-to-many.

What are the five types of integrity constraints? Data constraints based on the MySQL database instance, integrity mysqlTo prevent non-conforming data from entering the database, DBMS automatically monitors the data according to certain constraints

Install navicat and centosnavicat on centos 7:Http://download.navicat.com/download/navicat111_mysql_en.tar.gzCopy the downloaded file to the specified installation directory.[Hcr @ localhost Downloads] $ cp

Mysql transactions, concurrency issues, lock mechanisms, mysql transactions1. What is a transaction? A transaction is a combination of one or more database operation statements. It has four features: ACID. Atomicity Isolation: transactions are

Three things should never be put into the database, and the three are put into the database. Three things should never be put in the database I have already said in many speeches that the best way to improve your system is to avoid

Many database data processing stories and database data processing stories Every year, you will encounter a series of data import problems. I learned a lot from it. In the past two days, I have been asked why you are always importing data. There is

When inserting mysql database Chinese information in the cmd console, the insertion failure solution is as follows: mysql Chinese Information Fault code: Mysql> insert into t1 (name, sex, age, address) values ('zhang san', 'male', 11, 'shahe ');

SqlServer server role and database role-related operations, sqlserver Database /* Role [server-server role] roles */-- view the fixed server roles (8, not added or deleted, not public, and each user belongs to the public server role) EXEC

No downtime xtrabackup create slave node, xtrabackupslaveMaster: 10.1.1.17: 3306 slave: 10.1.1.18: 3307slave node complete basic environment configuration: Create mysql users, install mysql software of the same version, xtrabackup software package,

Windows operating system (no matter 32bit or 64bit) does not support the db_32k_cache_size parameter of oracle db ., 32bit64bit differences The db_32k_cache_size parameter of oracle db is not supported in Windows (no matter 32bit or 64bit. As

Can I use expdp through dblink to export data from 9i Database ?, Dblinkexpdp Expdp/impdp is a 10g import and export tool, which is not available in 9i. Someone suggested using 10g expdp to export 9i data through dblink, but this is not the case.

SQL Study Notes (5) --------- Time query statements and Study NotesMySQL NOW () function definition and usage The NOW () function returns the current date and time.Example 1 The SELECT statement is as follows: SELECT NOW(),CURDATE(),CURTIME() The

Data Center reconstruction-SqlHelper application and data center reconstruction-sqlhelper Since the implementation of each function in the data center reconstruction process involves database link access, the Code repetition rate is very high, which

Solve Chinese garbled characters in Mysql, mysql Chinese garbled characters Today, I asked about the mysql database Chinese garbled characters on V2EX. First, V2EX is much better than the CSDN Forum module. In an hour, the number of clicks has