Database Administrator

Platform: ms SQL 2008 Set the foreign Key contact. The primary Key must be Unique. Generally, it is Key. Set foreign key: 1: 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/205K410S-0.png "title =" QQ20130922224245.png

Install CMAKEYum install cmake-yOrWget http://www.cmake.org/files/v2.8/cmake-2.8.11.2.tar.gzDecompress the package and install it. I use the YUM method.Download MYSQL5.5Wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.34.tar.gz/from/http:/

SQL Manager for MySQLIsMySQLDatabase Server SystemManagement tools. It is favored by database administrators. Its Artistic graphic user interface does not bother new users. RecentlyEMSSoftwareThe company released version 5.4. 650) this. width = 650;

UNDO space recycling:1 Confirm undoSelectfile_name, bytes/1024/1024 fromdba_data_fileswheretablespace_namelike 'undotbs1 ';2. Check the UNDOSegment status3 selectusn, xacts, rssize/1024/1024/1024, hwmsize/1024/1024/1024, shrinksfromv $

1. Role of tnsnames. ora in listener The database only reads the content in tnsnames. ora during the startup process to parse LOCAL_LISTENER. After that, tnsnames changes have nothing to do with listening. --- Set LOCAL_LISTENER, port 1522 SQL>

Recently, I have been studying mysql clusters and have to install and deploy at least two or more mysql databases. This is troublesome and time-consuming. Today I wrote a Shell script based on the Installation Steps, you only need to execute the

From 5.5, the INNODB engine can also be compressed like the MYISAM engine. Of course, the compressed table is okay. You should not INSERT or UPDATE it. DELETE doesn't matter. It's just MARK, and then batch DELETE it. This is the same as the

The binlog function is enabled for mysql in the home decoration. The advantage of enabling this function is that it facilitates data recovery in the future, but the disadvantage is that log files are growing rapidly and will soon occupy the disk

Source of this article: http://www.lustlost.com /? P = 101 Mysql supports logical backup and physical backup Based on Backup recovery methods. Logical backup is a backup SQL statement. The backup SQL statement is executed during restoration to

MicrosoftInternetExplorer402DocumentNotSpecified7.8Normal0 In MySQL 5.1.x, the process of creating and deleting clustered indexes is as follows: 1. Create an empty table with the same structure as the original table, and then create a clustered

Oracle RAC is a cluster database that enables seamless load balancing and failover. How can we know that the RAC database has implemented these functions? We will test the functions below. I. Server Load balancer TestingThe server Load balancer of

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.

My. cnf configuration file binlog_format = MIXED, and use the default isolation level REPEATABLE-READ, there is a major problem, resulting in master-slave data inconsistency. The following is an example: Both the master and slave databases are MySQL5

For an online e-commerce system, we now need to simply divide the customer into three types based on the consumption amount in the order table and insert them into three tables.Order table order (order_id number, cust_id number, amount number);

1) for ORACLE connection overrun modification, we need to adjust the maximum number of connections of the oracle database. The adjustment of the number of connections is made in the init. ora file in the dbs directory of the oacle.The number of

Today, I am so ashamed .... Because of my carelessness, I deleted millions of data records, deleted. The customer's important data for a few years is gone. I was worried about it. Fortunately, I got it back. You must exercise caution when operating

MySQL triggers are simple. Most of them are used to update third-party tables. Today I will demonstrate the functions of MySQL triggers in Data creation.The result of the base table is as follows: CREATE TABLE `tb1` (    `id` varchar(255) NOT 

In the master-slave architecture, create an event on the master, as shown below: mysql> show create event `insert`\G;  *************************** 1. row ***************************                 Event: insert              sql_mode:  

1. Configure Advanced Security Options and network services for oracle databases through OUI 2. Configure kerberos Authentication 1. Execute the command netmgr and click the authentication label. In Available Methods, select KERBEROS5 and move it to

Hugepages are you using it? ---- Concept Hugepages are you using it?----Test Cases Introduction The system process accesses the memory through a virtual address, but the CPU must convert it to the physical memory address to truly access the memory.