Database Administrator

Redis Research (18th)-pipelines, redispipeline The client and Redis use TCP to connect. Whether the client sends a command to Redis or Redis returns the execution result of the command to the client, it must be transmitted over the network. The

ORA-00600 kcratr_nab_less_than_odr, ora-00600 In the morning, the database reports the following error: Successful mount of redo thread 1, with mount id 339694234Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER

Mysql timeout and mysqltimeoutMysql timeout know how much ------ by bibimbap1. How much does the timeout variable know? Open mysql and useshow variables like '%timeout%'The command looks like I don't know, but I was shocked. The result is shown

Modify the sa authentication logon method in SQLServer, sqlserversa Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Modify the sa authentication logon method in SQLServer: 1. Find SQLServer Management Studio in the Start

Access denied for user @ 'localhost' (using password: NO), denieduser @   Accessdenied for user @ 'localhost' (using password: NO)   1. Error description:   2. Find the following file:   3. Modify permissions:   4. Copy the password:

Understanding Shared Pool 1 and sharedpoolThe Heap management shared pool is managed by means of Heap memory management (KGH: Kernel Generic Heap ). starting from Oracle 9i, You can have multiple TOP-level heap instances. The TOP-level heap

JDBC programming-solution to lack of Mysql driver, jdbcmysql When you connect to a local Mysql using Java, the program will throw the ClassNotFoundException exception if the Mysql driver is missing (SEE) During jdbc programming, the local Mysql

SQL Server paging stored procedures, SQL stored procedures Paging storage process 1: --/* ----- Stored Procedure paging processing Sun Wei creation ------- */--/* ----- processed the data in two minutes so that the performance of the first half of

Build logical standby database by DG and build logic by dg The logical standby database is built on the basis of the physical standby database. Therefore, you must first set up the physical standby database. The slave database performs the

Set up VNC Remote Desktop Connection in Linux to install Oracle11G and vncoracle11gPreface:To install oracle in linux, you need to start the swing interface of java. Therefore, the x-window is required. Therefore, it is difficult to directly go to

MYSQL master-slave switchover, mysql master-slave 1. modify the configuration fileRead-only = 1 (master database)# Read-only = 1 (slave database) 2. view the status of the Master/Slave DatabaseShow slave status \ GShow master status \ G 3. Operate

Solve the problem that erlang and java operate a table at the same time, resulting in the lock table problem. erlangjava Author: Zhang changchang 1. Problem Description The Erlang end writes an oracle table through odbc, and java also writes this

MySql character set learning and MySql character set learning 1. MySql CHARACTER set includes two concepts: CHARACTER set (CHARACTER) and validation rule (COLLATION. Character set is used to define the way MySql stores strings; validation rules are

Group by top n application scenarios, grouptop Due to work reasons, some time ago, we encountered such a problem: the game role can be used together, but only three roles can be retained under the same account in each zone. The problem is that the

Oracle Data Type-4, oracle-4 18. NCLOBThe character set defined by the international character set of the database can be used to store character-based data of the Unicode type only. A maximum of 4 GB of data can be stored, which is larger than the

Oracle recursive query and Oracle recursive queryCreate a table and a primary foreign key CREATE TABLE SC_DISTRICT( ID NUMBER(10) NOT NULL, PARENT_ID NUMBER(10), NAME VARCHAR2(255 BYTE) NOT NULL);ALTER

SQL for Program Performance Optimization If the function is the body of the program, the performance is the soul of the program. The complete function can ensure that the physical body of the program is sound, and good performance is the symbol of

Django -- about Managers, django -- ManagersDefault managers If you use objecm Manager objects, take note that the first Manager Django encounters (in the order in which they're defined in the model) has a special status. django interprets the first

A large number of ons processes are generated in the RAC environment, resulting in Resource depletion of user processes. Resource temporarily unavailable and racons are displayed during User Switching.Basic elements (time, user, problem) The user

Basic MySQL statement and mysql statement# Creating a table# Create table stu (id int primary key, name char (10), age int );# Deleting a table# Drop table stu;# Add# Insert into stu (id, age, name) values (1, 20, 'xiaoming ');# Insert into stu (id,