Database Administrator

MySQL 5.6.7 RC was released a few days ago, so I decided to use tpcc-mysql to test its performance, including performance and stability. I can't say that my testing process is flawless because I found two bugs: MySQL 5.6.7 is locked during CREATE

When creating a new user, you must specify the default tablespace; otherwise, the system tablespace will be treated as the default tablespace. This is not recommended. It is estimated that the default tablespace was not specified when a user was

The 64-bit CentOS6.3 system is installed with a minimal package. It is used as a local Web server and the entire process is recorded.Step 6: Install mysql5.5 database v5.5.28 Mysql starts from Version 5.5 and does not use./configure for compilation.

Let's take a look at the explanation of this parameter in the official documentation. CURSOR_SHARINGProperty DescriptionParameter type StringSyntax CURSOR_SHARING = {SIMILAR | EXACT | FORCE}Default value EXACTModifiable alter session, ALTER

1. If the Key is null, the column value can be repeated, indicating that the column has no index or a non-leading column with a non-unique composite index. 2. If the Key is PRI, this column is an integral part of the primary Key. 3. If the Key is

The application workload can be defined as services in Oracle 10 Gb, also known as services. It can be used in a single instance or separately used and managed in RAC. Therefore, the entire database load can be divided into multiple different

Environment: RHEL-5.8 Oracle _ 10gR2 Bind a bare Device [Root @ localhost ~] # Fdisk-l Disk/dev/sda: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065*512 = 8225280 bytes Device Boot Start

Before Oracle 10 Gb, the warning log is located in the bdump folder, but 11 GB has changed the log and introduced ADR (a directory that stores the diagnostic logs and tracking files of the database ), it corresponds to the initialization parameter

Redis2.6 has been released (http://redis.io/download), download, in make when a bunch of compilation errors, after looking at the issue, with the linux system version and number of digits. Yesterday, the author antirez released 2.6.2. This version

1. Use zabbix + Shell scripts to monitor Mysql master-slave replication. An alarm is triggered when an exception occurs in the slave database. 1.1 first authorize a monitoring account to mysql slave. 1.2 compile a script to monitor the slave

Instance: Kernel. core_uses_pid = 1Kernel. shmall = 2097152Kernel. shmmax = 2147483648Kernel. shmmni = 4096Kernel. sem = 250 32000 100 128Fs. file-max = 65536Net. ipv4.ip _ local_port_range = 9000 65000Net. core. rmem_default = 4194304Net. core.

When viewing Apache log, the url is often mixed with characters such as % 3A and % 2F. What exactly does it represent? You only need to use Oracle built-in Function Conversion. Query characters in hexadecimal notation: Select chr (to_number ('2f ',

Oracle Data dictionary is a very important component of Oracle. Learning Oracle data dictionary is of great significance for database management. Below is the method I learned from my book to track the Oracle view. Here, let's make a mark! I.

I tested Stream over the past two days and found some information on the Internet to collect some information about Oracle RAC. After the test, I sorted out the results and shared them. You can try it on your own.1. Basic Environment1.1 source

Problem description; Install the Oracle11g client in SUSE10sp2 and create an aipcti user. If tnsping vsm (vsm is the service name under the client) fails, an error is returned:TNS-03505: Failed to resolve name, Used parameter

For DBAs, the most basic task is to back up and restore the database. In case of exceptions (such as server downtime or disk damage), the data department should be lost, or, the loss is minimized. MySQl database provides many tools (such as

This record is a change operation record for the production scenario. It focuses on the Operation ideas and sequence, and strives to be rigorous and careful. The premise is that the customer is eager to deploy the application for stress testing when

Oracle Optimizer (CBO optimization) Before executing an SQL statement, Oracle needs to analyze the statement execution plan and then execute it according to the execution plan. The execution plan of the Analysis Statement is completed by the

[Bkjia.com @ OceanBase ~] $ Cat my. SQLCreate table x (a1 int, a2 int, a3 int, b1 int, b2 int, primary key (a1, a2, a3 ));Insert into x (a1, a2, a3, b1, b2) values (, 0 ); [Bkjia.com @ OceanBase ~] $ Mysql-h1.32.36.29-P4797-uadmin-padmin [Bkjia.com

In the previous article (), after installing postgresql with yum, you can manage it through service. This postgresql-9.1 is located /Etc/rc. d/init. d/postgresql-9.1 You can see that it uses an OS username named postgres by default (from this script,