Database Administrator

When the database operates on a small amount of test data and a large amount of data, the performance is very different. Generally, in the early stage of the development process, people do not pay attention to the database performance. However, with

MySQL4.1 is an Alpha test version, which is not created as a dummies installer and may be inconvenient. However, I like it very much.Distribution of compressed packages: The following describes how to install and upgrade the package 3.23.49. I. New

When you submit a query, MySQL will analyze it to see if some optimization can be done to make it faster to process the query. This section describes how the query optimizer works. If you want to know the optimization methods used by MySQL, you can

Table Structure:Create table tab_name(Id tinyint,Name varchar (10 ),Age tinyint,Phone varchar (15 ));Original content: select * from tab_name;Id name age phone1 zhangsan 10 123456789102 lisi 28 987654321103 wangwu 33 456789123124 zhaoliu 45 789456123

The default database of Roller is MySQL. In many cases, it is integrated into the existing web system, and the database used in the original web system is not MySQL. Therefore, you have to replace the database when integrating with Roller. Roller's

Environment:Server1: MYSQL1 + AS4Server2: MYSQL2 + AS4Purpose:Connect to MYSQL on Server2 from Server1TNND, tried N times. The remote connection is always unable to connect to MYSQL. the following error occurs:[Root @ etc mysql] #

At the same time, the online access volume continues to increase. For servers with 1 GB of memory, the server even crashes every day or gets stuck from time to time. This problem has plagued me for using MySQL for more than half a month. scalable

When installing Oracle in the Red Flag DC 5.0 Standard Edition or Red Hat as 4u2, A compat-libcwait-2.0-2. i386.rpm package,In earlier versions (now this package has solved this problem, * http:// In

There are a lot of Oracle10g documents searched online. I have sorted them out and hope to give them a reference.Configure the environment RedHat4.2 cpu: p42.8 dual-core memory 1g NIC: realtek RTL8169/8110 depressed NicDisk size: 10 Gb dual-system,

Q: How is the current_scn of Oracle10g calculated?A: We know that Oracle10g introduces current_scn in the v $ database view. This SCN comes from the underlying table and represents the current SCN. in Oracle9i, we can use

1. download the relevant package (the source package must be used)Mysql-5.0.22.tar.gzIi. Run configure. /Configure -- prefix =/data1/zhangsc/local/mysql -- with-mysqld-user = zhsc -- with-unix-socket-path =/data1/zhangsc/local/mysql. sock --

Software environment: 1. Windows 2000 Oracle 8.1.7 2. ORACLE installation path: C: \ ORACLE Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program->

Today again encountered ORA-01033: Oracle initialization or shutdown in progress this oracle service initialization error, generally I will first listen to the file to see if the host name has let me change, the port number has changed. The result

1. Create the original dblink statement: Create public database link db_lsxy Connect to lsxy identified by lsxyUsing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192. xxx. xxx. xxx) (PORT = 2261) (CONNECT_DATA = (SERVICE_NAME =

MySQL 5.5 series has become a stable version for some time, but according to my survey, it is still dominated by the 5.1 series in the production environment. In large Chinese companies, it is only determined that Jinshan is using 5.5.I have been

There is no problem in running Oracle 10g environment, as shown below: For c in (SELECT * from table (pkg_1__common.f_split (P_IN_IDS _, ',') LOOP.... Omitted hereEnd loop; However, in Oracle 9i execution, the ORA-22905: cannot access rows from a

1. view the basic attributes of the database:SELECT dbid database number, name database name, db_unique_name global name, created creation time, log_mode archive mode, open_mode access mode, platform_name version type FROM v $ database; 2. view the

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This section describes how

In Oracle, four lobs types are available: blob, clob, bfile, and nclob. The following is a brief introduction to the lob data type. Blob: Binary lob, Which is binary data. It can be up to 4 GB and stored in the database. Clob: character lob,

1. MySQL-VIP: 192.168.0.50MySQL-master1: 192.168.0.42MySQL-master2: 192.168.0.495. OS Version: CentOS 5.56. MySQL version: 5.5.137. Keepalived version: keepalived-1.2.7.tar.gz  1. MySQL master-master Configuration1. Modify the MySQL configuration