Database Administrator

MySQL master-slave replication (using mysqld_multi) Here, I use two MySQL instances on a single server to build them, mainly using the mysqld_multi I. Replication PrincipleBefore starting the setup, you need to add the following basic knowledge

An example of ORA-07445 troubleshooting The tester reported an error when running SQL statements on a test database (the specific SQL statement is not mentioned here. In short, it is a complicated SQL statement with more than rows .), The error

PL/SQL data type 1. Variables and constantsVariable Syntax: variable_name data_type [[not null] [: = VALUE]Note: not null is a non-NULL constraint on variable definitions. It must assign a non-NULL initial value to the variable and cannot be changed

Mysql trigger, mysql trigger instance Trigger 1. Definition: a specific operation is triggered by insert, update, delete, and other events. The trigger can trigger multiple execution statements. Note: triggers cannot contain keywords such as start

Misunderstanding of Oracle Parallel 2 -- actually locking the entire table, oracle2 -- I have written a misunderstanding about Oracle parallelism before. 1. In fact, you didn't use parallelism. I always thought that Oracle would only lock the data

Solve mysql Chinese display, solve mysql Chinese 1. view the mysql character setting method, as shown in. If it is not gbk, perform related settings. Mysql> SETCharacter_set_client=Gbk;Mysql> SETCharacter_set_connection=Gbk;Mysql>

Limits on mysql, limitsonmysql 1. limits of joins The maximum number of tables that can be referenced in a single join is61. This also applies to the number of tables that can be referenced in the definition of a view.2. Maximum number of

OGG rep process startup encounters sys. dbms_streams_adm_utl_invok.SET_FOO_TRIGGER_SESSION_CONTXT (fire => TRUE);, excelcontxt GGSCI (jjtest) 2> view report repzp***********************************************************************

Obtain different scn information from control file and datafile header, datafilescn Database checkpoint scn -- The following dump from control file: Database checkpoint: Thread=1 scn: 0x0000.0006b6fe Datafile checkpoint scn -- The following is the

Soft Test details --- three paradigms, soft test --- paradigm Relational databases are widely used nowadays. The design of relational databases is the process of organizing and structuring data. We can easily process small-scale databases, but as

Chapter 9 algorithm Interview Questions 27 maximum continuous subset, Chapter 9 subsetChapter 9 algorithm official website-original website Http://www.jiuzhang.com/problem/27/ Question For an integer set S, the subset D of S is defined as a

Paging performance exploration-mysql, paging exploration-mysql Paging technology is very common in development. I used paging technology for the two projects I just joined the company, so I thought about in-depth exploration of paging

Session warehouse receiving and phpsession warehouse receiving Session_set_save_handler (callback open, callback close, callback read, call write, callback destroy, callback gc)   Execution time and usage of each parameter Callback Function

Install postgresql in linux and configure remote graphical desktop connection. I have recently used postgresql for projects that I have never touched before, so I have encountered some installation problems. Now I will record them. 1. Download

Ensure successful installation of oracle11g and oracle11gEnvironment: LSB Version: core-4.0-amd64: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-noarch:Distributor ID: RedHatEnterpriseServerDescription:

Oracle sys_context () function, oraclesys_context The first parameter is 'userenv', which is fixed. The second parameter is also fixed, but multiple options are fixed. The optional values are as follows: Select sys_context ('userenv',

Database and database LearningSerializability of concurrent Scheduling DBMS may produce different results for different scheduling (schedule) of concurrent transactions.What kind of scheduling is correct? Serial scheduling is correct.For serial

Report development instance-dynamic multi-level KPI drilling report (II), kpiii InReport development instance-dynamic multi-level KPI drilling report (I)In, we talked about the scenario where dynamic hierarchical reports require hierarchical

The range and storage size of various int types in MySQL, mysqlint The integer type int in MySQL mainly includes the following types: The tinyint range is-128 ~ 127; The int value ranges from-2 ^ 31 (-2,147,483,648) to 2 ^ 31-1 (2,147,483,647).

Oracle basic functions and object examples -- ## Character function, case-sensitive processing function select lower ('abcde') FROM dual; -- ABcDe, all converted to LOWER case select upper ('abcde') FROM dual; -- abcde, convert all to uppercase