Database Administrator

Principle:In Linux, MySQL Databases belong to/var/db/mysql or other directories. A directory is a database. Therefore, you can obtain the database size by checking the directory size to determine whether the capacity has exceeded the limit. If the

Log on to Linux with the root account 1. Stop the background resident program of the NetBackup/Media Manager: /Usr/openv/netbackup/bin/goodies/bp. kill_all 2. Run the following command to log out of the master configuration of VxUL. The

I have always felt that it is complicated to install Oracle 10 GB on Ubuntu, which is not as easy as mysql (although mysql is not good at learning ). You must install an Oracle 10g server on your machine to learn how to use it. The oracle design

If Oracle is installed first, and tomcat is installed again, open the default tomcat (TEST) webpage: http: // localhost: 8080. An oracle "fliggy" is displayed in the test result ", without the apache "cat ". generally, the current tomcat port is 8081

Installation environment: RedHat Chmod 755 mysql-5.0.45.tar.gz# Tar-zxvf mysql-5.0.45.tar.gz-C/usr/src/# Mysql-5.0.45/cd/usr/src/#./Configure -- prefix =/usr/local/mysql -- with-charset = gbk -- localstatedir =/usr/local/mysql/data# Make# Make

MySQL cannot be startedToday, there is another problem with MySQL on the server. If there is no exception, no error is reported. After mysql is started in the service, no error is reported, but the startup is not successful. It is not like a 1067

Select for update knowledge An application that sends an email will fetch unsent emails from the database and send the emails each time slice. After the application succeeds, it will change the mail ID in the database to "sent. This application is

Sqlplus/nolog SQL> conn system/password @ oraname as sysdba First, close the database: SQL> shutdown normal Or SQL> shutdown immediate; View the current status: SQL> archive log list; Conversion Mode SQL> startup mount; SQL> alter database

Local service name (Tnsname) The connection between the Oracle client and the server is a connection request sent by the client. The server listener checks the client connection request legally. If the connection request is valid, the connection is

The system uses minimal installation, and the installation steps are not detailed. 1. Install the RPM package: # Rpm-ivh glibc-headers-2.5-12.i386.rpm # Rpm-ivh glibc-headers-2.5-12.i386.rpm # Rpm-ivh libaio-0.3.106-3.2.i386.rpm # Rpm-ivh libgomp-4.1

Nginx's high efficiency is out of the name. Recently I want to use it to replace Apache on the Ubuntu 8.10 server, so I did a test on the local machine. The following steps are recorded!Step 1: Install mysqlSudo apt-get install mysql-server Step 2:

Said a website evaluated the performance of a series of desktop software on the Linux kernel, using a series of pure kernels from the Ubuntu company without patching, from 2.6.24 to 2.6.29, other software is standard Ubuntu 8.10, including X Server 1

Oracle 10.2.0.1RAC (not Using asm) with a full set of raw disks (including crs and voting disks and database files) (titles written in asm are used by many comrades, I can modify the ASM method here) To test my software, we need two sets of the same

MySQL version: mariadb 5.5.30 OS Version: CentOS 5.6 x86_64 From a line in the Network: "transactions are written into the binlog in the order of submission. MySQLserver is a statement that distinguishes different threads and maintains a transaction

Error Report: SQL error: ORA-01688: Table JINRILOG. USEROPERATELOG partition P1 cannot be extended through table space JINRILOG 01688. 00000-"unable to extend table % s. % s partition % s by % s in tablespace % s" * Cause: Failed to allocate an

Restoration of Oracle log files and control files corruption: Recovery steps: 1. Add _ allow_resetlogs_appsuption = true, _ uploupted_rollback_segments = true, _ offline_rollback_segments = true, start to nomount 2. Use the backup of the control

View the current License status SQL> show parameter license;NAME TYPE VALUE-----------------------------------------------------------------------------License_max_sessions integer 0License_max_users integer 0License_sessions_warning integer 0 View

Control File ExperimentA maximum of 8 control files and at least 1 are mutual images. If the control file is lost, the database cannot be shut down normally and cannot be started.// Add a control file. The original control file must be added. Note

The Table Cache --------------------------------------------------------------------------------Table cache objects: tables Each cached object contains the parsing result of the related table. frm file, and some other data is added. To be accurate,

In Oracle databases, indexes can be divided into three types based on different indexing mechanisms. 1. B-Tree index Application Scenario: OLTP is applicable to B-Tree indexes for fields with low key-value repetition rate. When the key-value