Database Administrator

The main responsibility of daily management is to manage the running status of MySQL server program mysqld, so that database users can smoothly access the MySQL server. The following are the main responsibilities of this job:Server startup and

1 because orcale10 does not support RHEL5, you need to change/etc/redhat_real.pdf to Red Hat Enterprise Linux Server release 5 (Tikanga) to Red Hat Enterprise Linux Server release 4 (Tikanga)2. Modify the/etc/hosts file to change 127.0.0.1 to your

1. Export the entire databaseMysqldump-u username-p Database Name> exported file nameMysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL2. Export a tableMysqldump-u user name-p database name Table Name> exported file nameMysqldump-u wcnc-p smgp_rj_wcnc users>

In many cases, we need to terminate all Oracle processes ). When the database is "locked" and you cannot enter Server Manager to terminate the database, you can use the kill command in UNIX to terminate all Oracle processes. This is one of the

I remember that because there was no network, I mistakenly wrote the root password as follows:Update user set password = "122" where user = "root ";Then mysql will not work.# Mysql-u root-p#123ERROR 1045 (28000): Access denied for user ''@

The installation of MySQL5 In the Solaris operating system is based on the official MySQL5.1 Reference Manual section 2.7 "Install MySQL in other Unix-like systems" steps, and the official information is reliable, sort it out for easy

Question 1: The MySQL disk is full. Question 2: mysql repair multiple tables Repair table: perform the following steps by week: 1: lock table EE write; 2: flush table EE; 3: repair table EE; 4: flush table EE; 5: unlock table EE; // A

Record mysql commands and scripts that are frequently used in development for backup. I haven't written SQL for a while recently, and it's a little unfamiliar. (The following code is developed in winxp. Open a command prompt ). First, start and stop

NAME TYPE VALUE--------------------------------------------------------------------------Audit_trail string DB Hello everyone! Recently, the company's server system tablespace is getting bigger and bigger, and segments logical reads and segments

Debian 6 sets Oracle 11g R2 to automatically start upon startup Log On with the root account. Step 1: Modify/etc/oratab Orcl:/home/oracle/product/11.2.0/db_1: Y Where Orcl: sid /Home/oracle/product/11.2.0/db_1: db_home Y: Start Y (yes) or N (no).

1. Use of DBMS_JOB packageThe DBMS_JOB package is used to arrange and manage job queues. By using jobs, the Oracle database can regularly execute specific tasks.Note: When you use DBMS_JOB to manage jobs, you must ensure that the initialization

Fault description: The following error occurs when I establish a DBLINK verification connection to 11.2.0.3 in Oracle10.2.0.4: ORA-01017: invalid username/password; logon deniedORA-02063: preceding line fromAnalysis Error: According to the error

RedHat 5.8 install Oracle 11gR2_Grid Cluster 1. Install the corresponding software package through rpm: Rpm-ivh binutils-2 *. i386.rpm Rpm-ivh binutils-2 *. x86_64.rpm Rpm-ivh compat-libstdc ++-33-* I * Rpm-ivh compat-libstdc ++-33-x * Rpm-ivh

The principle and script are both very simple, that is, whether the Slave_IO_Running and Slave_ SQL _Running values in the synchronization state are both Yes. If not, send a text message to the police. [Root @ mysqlb script] # cat

B-tree indexes are the most common indexes (traditional indexes ).The simple creation method is: create index test_id_idx on test (id ).The following figure illustrates the B-Tree Index: ①: From top down, the first layer is the root node, the

Oracle Stored Procedure refresh materialized view SQL: Create or replace package body REFRESH_MVIEW IS -- Author: 241433-- Created: 4:25:04-- Purpose: This PKG is for REFRESH MVIEW -- Public type declarationsCONS_BCR_LIST VARCHAR2 (40): =

When a request was submitted today, the ORA-01652 was prompted that the TEMP segment could not be extended through 128 (in tablespace temp. Finally, use alter database tempfile '/*/db/apps_st/data/tempx01.dbf' to RESIZE 7168 M; to expand the

Generally, as a non-DBA, we only focus on some SQL indicators. For the main indicators, see, For more information, see the description below. SQL ordered byElapsed Time Top SQL statements that record the total execution Time (note that the total

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time

The main work of the InnoDB Storage engine is completed in a separate background thread master thread.The main thread of the master thread mainly includes the following cycles:Main loopBackground loopRefresh loop flush loopPause loop suspend