Database Administrator

 1. Memory Management, add at the end of the file /Etc/sysctl. conffs. aio-max-nr = 1048576 fs. file-max = 6815744 kernel. shmall = 2097152 kernel. shmmax = 536870912 kernel. shmmni = 4096 kernel. sem = 250 32000 100 128 net. ipv4.ip _

Use cursor) 1. Declare a cursor Cursor for select_statementThis statement declares a cursor. You can also define multiple cursors in a subroutine, but each cursor in a block must have a unique name. A single operation is performed after the cursor

2.3.2. Store JavaScript. Developers can access JavaScript Functions and values on the server side without using stored procedures in relational databases.2.3.3. aggregation. MongoDB supports MapReduce and other aggregation tools, which provide

First, let's take a look at SQL server. Previously, we used the foreground to select a start time and an end time (in the smallest unit of day), and then used it as a condition for query, if we use "between starttime and endtime" as the condition,

(1) For complex data service-level constraints across multiple tables, triggers can be used to replace a large number of background judgment codes, which is highly efficient and convenient.(2) If you want to use a trigger to assist the business

If the two conditions are met, the standardization level of the database is still relatively high. Of course, these are two general indicators. To meet the requirements of database design standardization, the following five requirements must be

The following statements are Mssql statements and cannot be used in access.SQL classification:DDL-Data Definition Language (CREATE, ALTER, DROP, DECLARE)DML-data manipulation language (SELECT, DELETE, UPDATE, INSERT)DCL-Data Control Language (GRANT,

Common rules for creating an index are as follows: 1. The table's primary key and foreign key must have an index; 2. Indexes should be available for tables with more than 300 of the data volume; 3. For tables that are often connected to other

Splits strings. MYSQL version. Because MYSQL does not support recursion and does not support returning results of the table type, the code is cumbersome. I use two functions and a stored procedure. -- Obtain the total number of

More highlights availableLeonarding.blog.51cto.com 《Oracle comment onComment information methodology Introduction: some comments may be frequently written in DBA daily work, but I think there should be not many to write and use Oracle commands, in

MySQL 5.5The problems encountered during a test and optimization and the solutions to the problems. For your reference.I. Table Structure OptimizationProblem 1: using different character sets for tables and fields will cause index failure.I did not

When the Oracle database is started, it starts the Oracle instance based on the parameters provided in the parameter file. These parameters include the database name, sga, pga allocation, control file location, undo, process, and so on. Oracle RAC

Next, let's talk about an article. Easy to understand Use LIMIT to LIMIT the number of query results Number of lines at the LIMIT position offset Displays the first four rows of Table query results. Mysql> SELECT * FROM fruits LIMIT 4; + ------ + -

Lab environment: OS: Redhat 5.3 64bit Mysql: mysql 5.5.29 TCMalloc (Thread-Caching Malloc) implements the same functions as the standard glibc library's malloc, but TCMalloc is much more efficient and faster than standard malloc. TCMalloc is a

1. invalididentifier adds a comma at the end. 2. Change missingkeywordsreference to references. 3. missingrightparenthesisdefaultnotnullunique should be placed before the constraint 4. ORA-009922:

In this example, a 5 GB 8-mm tape drive is used, and its device file is/dev/rmt0. I. Backup Backup can be implemented through the command line or SMIT menu. 1. Command Line backup The AIX commands backup and restore are used for backup and recovery.

1. System Directory 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/212S43161-0.jpg "title =" 201303281601320.6.jpg" alt = "093838365.jpg"/> 2. logical volume Management Before learning how AIX processes the file system,

2.3 use basic commands 12. cat command It is used to display the file content on the standard output, but does not update the file. The syntax is cat + file name. For example, to display the content of the/home/long/example.txt file, run the

MySQL-> create database dbname; create database MySQL-> create table tablename; create table MySQL-> show databases; display DATABASE information and available DATABASES. MySQL-> USE dbname; select database MySQL-> show tables; displays table

Single-line functions-character Functions Although each database supports SQL statements, each database also has operation functions supported by each database. These are single-row functions. If you want to develop a database, in addition to SQL,