Database Administrator

Define data tablesAssume that a computer manufacturer stores the product information of the whole machine and accessories in its database. The table used to save the product information of the entire machine is called Pc; the table used to save the

Decompress mysql4.0.26Root @ www:/db # tar zxvf mysql-4.0.26.tar.gzBack up the data directory of mysql5Root @ www:/db # tar czvf mysql5.data.tar.gz mysql5CompileRoot @ www:/db # cd mysql-4.0.26Root @ www:/db/mysql-4.0.26 #./configure -- prefix

By default, MySQL supports three engines: ISAM, MyISAM, and HEAP. The other two types are InnoDB and Berkley (BDB ).ISAMISAM is a well-defined and time-tested data table management method. It is designed to take into account that the number of

In Linux, MySQL (especially the MySQL client tool) is used for query. When there is a large amount of data, the page is quickly turned over and cannot be seen. In Linux, you can view the data on each page. You can use the -- pager parameter. For

Note:EXP-00091: Suspicious exit statistics.EXP-00091: Exporting questionable statistics. Generation:This error occurs when the database table is exported (dump) when the database server and client character set are different. This error does not

If "ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)" appears, your MySQL has not been started. Windows solution: Step 1 Delete my. ini under c: \ windowns Step 2 Open c: \ mysql \ bin \ winmysqladmin.exe and enter the user name

1. Open a terminal in the graphic interface of the Linux server and enter the following command; Xhost + 2. Switch to an Oracle user and run the following command:Su-oracle 3. Specify the variables and values of the database instance. Assume that

PhpMyAdmin is a PHP-based MySQL database management tool based on the Web-Base architecture on the website host.You can manage the entire MySQL Server (requires a Super User) or a single database. To implement the latter, You need to properly set

1. Install Python. The Python version is 2.4.2. 2. Install Mysql in/usr/local/Mysql 3. Obtain the MySQLdb Library 1). Download MySQLdb Library: http://sourceforge.net/projects/mysql-python from: MySQL-python-1.2.2.tar.gz Put this library

An error occurs after lock_sga is set in Linux: Ora-27102: Out Of Memory: Linux Error: 12: Cannot Allocate Memory with LOCK_SGA = TRUE[Oracle @ db ~] $ Ulimit-Core file size (blocks,-c) 0Data seg size (kbytes,-d) unlimitedFile size (blocks,-f)

Today, MySQL cannot be started under normal users. I found that I had a problem installing MySQL in Linux. Now I have to reinstall mysql again, The following are the specific steps and descriptions. In this record, we will try again later for

Redo content Oracle uses redo to implement the same fast commit. On the one hand, it is because redo log files can be written continuously and sequentially. On the other hand It is also related to the simplified content of the redo record.   To

Use of instance update for Oracle Stored Procedure usage Body section -- Update changes Procedure proc_sy_syjs_updateChangeItem (fcoursecode in Rule XT. sy_syjs_proitem.fcoursecode % type,Fcoursename in Rule XT. sy_syjs_proitem.fcoursename %

Installation Background: due to the need of Graduation Project, Oracle 10g is installed on CentOS6.2 platform, mainly referring to the documents I think are more reliable on the Internet. It turns out that this is also true, here are my installation

Background A typical operation of a log-type application involves a large number of insert Operations periodically. This type of operation requires extended tablespace. Analysis In InnoDB, the extended tablespace operation is called directly by

Oracle Basic Data Structure Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx? Where = nkey & keyword = 19824 2.1 Control File The control file contains the status information of all other files in the database. The

The redo log describes all changes to the data block. This section describes the operations performed when a database is opened and logs are written. Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx? Where = nkey &

This article is from a series of articles by Simon Maynard, co-founder of bugsng. Based on the experience in using Redis over the past few years, the author systematically summarizes the Redis monitoring methods. There are a lot of things available,

Assume there are two data types: (Table Name: user) 1) username = admin, password = 000000 2) username = admin, password = 123456 The effect we want to achieve is that you can enter multiple keywords for query. Multiple keywords are separated by

SQL> CLEAR SCREEN;# Create a database tableSQL> start e: \ SQL. SQL;18;The table has been created.SQL> select table_name, tablespace_name from user_tables;TABLE_NAME