Database Administrator

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 $

Job functions:Database Engineer/Administrator Job description:Requirements:1. Familiar with Oracle 10g and 11g database features, more than 3 years of database experience2. Have a deep understanding of Oracle technical architecture, be

1. oracle only provides cascading deletion when creating tables, and sqlserver provides cascading deletion and update. Although the primary key value of the primary table cannot be modified frequently after the primary-foreign key relationship is

When MySQL uses the innodb engine, the page size defaults to 16 KB, which is too large for many applications, many applications that run well in ORACLE, for example, migrate data to innodb, find that the IO pressure is too high. MySQL does not

In earlier versions, if a high-load machine is restarted and a large amount of hot data in the memory is cleared, it will re-load the data from the disk to the Buffer_Pool buffer pool, in this way, the performance will become very poor during peak

According to the company's plan recently, we need to incrementally fetch data from some tables in the previous SQL Server database to the ORACLE database and decide to use the newly added CDC Change Data Capture function in SQL Server. The procedure

In daily work, because I am not familiar with the InnoDB engine, many people in the group have deleted InnoDB ibdata files by mistake) and ib_logfileredo log redo transaction log files. If you have master-slave replication and synchronization, it's

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);

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 

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

This article introduces the manual failover operation and troubleshooting process in the redis master-slave environment. When the master instance goes down, the master instance is upgraded from the master instance to the master instance and data is

1. Use row-level locks to avoid table-level or page-level locksTry to use a storage engine that supports row-level locks, such as InnoDB; use a storage engine that uses table-level locks only in scenarios where reading operations are significantly

Fault symptom:[Oracle @ L-DB-100-17 ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.4.0-Production on Saturday January 5 14:59:15 2002 Copyright (c) 1982,200 7, Oracle. all Rights Reserved. ERROR: ORA-01031: insufficient privilegesEnter user-name:

These days, it was too busy. The provincial leaders on the 12th wanted to check the progress, so the project team was really a mess. Get off work at every night, and do not rest at noon. Learning over time has become a luxury. Over the past few days,

This is an SQL statement they developed to delete duplicate data and the row whose id is the minimum value is not deleted: delete from jd_chapter a where a.`id` in (select `id` from jd_chapter group by book_id,chapter_id  having count(*)>1)   

Note: This article is from the linux O & M training of Old Boys-MySQL database training course series1) video tutorial directory1. MySQL service operation .................................... ........................................ 31.1 start and

  1. Node 1 is damaged and cannot receive heartbeat from other nodes.Node 2 can receive the heartbeat of Node 3 and node 3 can receive the heartbeat of Node 2.Node 1, heartbeat information to votingdisk: "Only I am alive !"Node 2 and 3, heartbeat