Database Administrator

MySQL has become one of the most widely used databases on the network, especially for Web applications. It occupies the absolute advantage of Small and Medium applications. All of this comes from its small and easy-to-use, secure and effective, open

SQL statements are frequently used when dealing with databases. Unless you bind all controls, the method of binding controls has disadvantages such as poor flexibility, low efficiency, and weak functions. Therefore, most programmers seldom or seldom

This article analyzes how to use the Oracle optimizer to get twice the result with half the effort.1. select an appropriate Oracle optimizerThere are three optimizer types in Oracle:A. RULE (RULE-based) B. COST (COST-based) c. CHOOSE (selectivity

You do not need to reinstall the system, because I have experienced it once. The specific solution process is as follows: on that day, after redoing the system, I installed it again. install Oracle9i. my Oracle installation disk has been copied to

This article provides answers to some questions about the coredump command.1. Ensure that the directory where coredump is stored exists and the process has write permission on the directory. The directory that stores coredump is the current

1. First download the driver:(Cx_Oracle), pay attention to the version and select it based on your situation.2. installation:Run the exe installation program. It will copy a cx_Oracle.pyd to the {PYTHON_HOME} \ Lib \ site-packages directory.3.

Install Oracle9.2.04 in Linux AS3.0 1. Download Sun's Java Development Kit (JDK 1.4.2 ).J2sdk-1_3_1_09-linux-i586.rpm.binDownload the Oracle Installation Software otn.oracle.com.Lnx_920_disk1.cpio.gzLnx_920_disk1.cpio.gzLnx_920_disk1.cpio.gzDownload

At the end of last year, Oracle acquired a partner that provided Database Engine Services for MySQL over the years, forcing MySQL to only find other partners. It was reported that Oracle attempted to acquire an open source database MySQL. MySQL CEO

1. How to create a management user for the mysqld database? After the database is installed, we should create a management account for the mysql database. To set the root user as the administrator, we should run the following command; [Root @

-- SQL batch delete all field description attributes in a specified data table -- Symptom: Execute select * from sys. extended_properties where value is null. Multiple records are displayed, similar to [1 OBJECT_OR_COLUMN 2372069 1 MS_Description

The following script can be executed at every day through a scheduled task, so that warning logs are automatically saved to the corresponding directory by time classification. It is convenient to view the Alert logs generated by Oracle every

To make up for the limitations of nested loop connections, that is, when the data volume is large, to reduce the number of random reads in nested loop connections, and when the connection column does not have an index, nested loop connections can be

Record exit and return usage Exit is used to exit the loop. Loop IF V_KBP IS NULL THEN EXIT; End if; End loop; Return jumps out of the stored procedure Loop IF V_KBP IS NULL THEN Return; End if; End loop; Skip loop once The Oracle 11g

Start and close an ASM instance The startup and shutdown operations of the ASM instance are similar to those of the RDBMS database instance: Execute the STARTUP operation FORCE, this option is forcibly disabled, the shutdown abort operation is

Aggregate functions, multiline functions, and grouping functions are all types of functions.Group by and HAVING Group function: AVG \ SUM \ MIN \ MAX \ COUNT \ STDDEV \ VARIANCEUse DISTINCT in combination with the group FunctionProcessing of NULL

During database maintenance recently, data cannot be stored into the database during data parsing. The reason is that MySQL transactions have deadlocked. I restarted MySQL several times before. Recent frequent occurrences. So find a method. SELECT *

Redo Log Buffer is located in sga_max_size, which stores information about database changes. This information is stored in the form of Redo Entries (Redo Entries, also known as Redo Records ). Redo Entries contains important information for

APIS involved in this article: Hadoop/HDFS: http://hadoop.apache.org/common/docs/current/api/ HBase: http://hbase.apache.org/apidocs/index.html? Overview-summary.html Begin!How does HBase regularly and quantitatively delete records? Use Case

For more information about how to use the Export and Import functions of HBase to complete backup, see my previous HBase Incremental backup. Reprint the Python code that regularly backs up data using Export and Import. Complete backup is performed

Reasonable creation of strategic indexes for database tables can greatly improve query performance. But in fact, the index we create in daily life is not a strategic index. It is precisely because a large number of redundant or useless indexes