Database Administrator

Online Job migration: migrate jobs from GP to Hadoop and find that some jobs have been running for 2-3 minutes to Hadoop for about 10 minutes. This will affect the migration performance; an obvious Query is as follows: Insertinto table_big

After mysql is installed in Linux, table names are case-sensitive by default, but column names are case-insensitive; After logging on with the root account/Etc/my. cnfAdd lower_case_table_names = 1, Restart the MYSQL service. The setting is

The simplest installation file is. Bff file, cainiao's favorite. I have been looking for a long time, now contribute: http://www.bullfreeware.com/ 1. Download samba-3.0.4.0.bff 2. Place files in the temporary installation directory of the AIX system,

Recent learning highlights: 1. oracle performance optimization, especially waiting for the publication of Cui Hua's book. It is estimated that this month's renewal will be available next month. Statistics, execution plans, SQL profile, index

10 is the primary node, and 6 is the slave node. Use a script to back up the database of the host. [root@qianzhidb01 shell]# cat exprot_3306.sh#!/bin/shset -xdata=`date +%Y%m%d%H%M`mkdir

1. TOM's table information viewing process and authorization Create or replace procedure SHOW_SPACE (P_SEGNAME IN VARCHAR2, P_OWNER IN VARCHAR2 default user, P_TYPE IN VARCHAR2 DEFAULT 'table', P_PARTITION IN VARCHAR2 default null) -- this procedure

DML statement restrictions: 1. If the DML statement uses the degree of parallelism, you must set the alter session enable parallel dml for both HINT and directly set the degree of parallelism on the table. This step is essential! 2. If the

At present, all major portal websites tend to use mysql to a certain extent. In addition to the I/O/E campaign advocated by the Alibaba system, we must correct the earlier view that we have always despised mysql, as a database practitioner, we must

In the previous article, I analyzed a specific implementation idea, mainly using Chinese Word Segmentation and Unicode encoding to solve the problem that mysql full-text indexes cannot be used for Chinese search, this article describes how to

I received a monitoring text message saying that the threshold value was updated and inserted, So I logged on to mysql-monitor to view the alarm, 650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131229/19412211N-0.jpg

This blog post aims to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion. First of all, let's introduce the source

Repair of oracle11g Bad blocksI. a brief introduction to the bbed command. Later, we will use this tool to construct the block checksum and do not express it to simulate Bad blocks. Show all current configuration optionsInfo: list the files that can

MicrosoftInternetExplorer402DocumentNotSpecified7.8Normal0 MySQL5.5 standardizes the writing of SQL statement table connections. delete user a,user2 b from user a join user2 b on a.id=b.id;  MicrosoftInternetExplorer402DocumentNotSpecified7.

When checking the system today, I found that the system reported an error message about the ORA-00376. In general, the data file:/database/data1/orcldata/d_datafile7.dbf is wrong?   How can we solve this problem, The following describes how to solve

The user cannot log on to the database because the syslogins table in the master database is deleted by mistake. However, if there is a backup of the master database, try to restore it. The following are the summary steps. 1. Back up the master

MASICONG @ orcl> select sid from v $ mystat where rownum = 1; SID ---------- 35 MASICONG @ orcl> select sid from v $ mystat where rownum = 1; SID ---------- 1 1. Simulate the blocking example caused by insert, update, and delete, describe the

  650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131229/1U0143T8-0.jpg "/> Nosql leads us into a new database world. Literally, we should not regard it as "No SQL ", it should be correctly understood as "Not

650) this. width = 650; "border =" 0 "src =" http://img1.51cto.com/attachment/201212/102038943.jpg "alt =" "/> -- MySQL INNODB technology insider Jiang chengyao Here is my table structure: mysql> show create table p1\G;  **********************

Under the CBO (cost-based optimizer mode) condition, the execution plan of SQL statements is determined by the statistical information. If no statistical information is available, the execution plan is determined by dynamic sampling! It can be said

This is an SQL statement they developed Select id, title, createdate from table name order by createdate asc limit 334570,10; The person who asked this question meant reading the oldest news title and reading 10 records from 334570 rows of