Database Administrator

How to query implicit Oracle Parameters Based on v $ parameter Oracle implicit parameters are not displayed in Oracle official documents. These parameters are mainly used in Oracle to control certain functions, or, as described by eygle today,

How to view the content in the Oracle11g Control File A Control File is one of Oracle physical files. It records the database name, data File location, and other information. The importance of the control file is that the database will go down once

Standard installation of MySQL binary files Demo Environment Operating System: CentOS 6.7 (64-bit) Binary Package: mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz MySQL: http://dev.mysql.com/downloads/ 1. Download MySQL # Mkdir/root/mysql # Cd/root/mysql #

Master-Slave MySQL and read/write splitting (Amoeba) in Linux I. Why do I need to perform Mysql master-slave replication (read/write splitting )?In general, if the read and write operations on the database are performed on the same database server,

Regularly Delete MySQL binary log files All updates (add, delete, and modify) to the MySQL database are saved to the binary log file of MySQL. With this binary file, we can roll back the database and restore the database. At the same time, the

MySQL dynamically creates and deletes a partition table Due to project requirements, I recently studied how to dynamically create and delete partition tables in the MySQL database. If all stored procedures are used, creating and deleting partition

MySQL 5.6 quickly locates unreasonable Indexes # If CARDINALITY/TABLE_ROWS is less than 10% (experience value), it indicates a high data repetition rate. Generally, you need to consider whether it is necessary to create this index.###################

Differences between statements for querying by page in Oracle, MySQL, and SQL Serve ★First, define the parameters to be used in the paging statement: Int currentPage; // current pageInt pageRecord; // number of records displayed per pageTake the

Connect PHP to a MySQL database instance For those familiar with websites, if they want to make websites dynamic, they must have database support and use specific scripts to connect to the database, extracts resource H from the database, adds data

Oracle Database language-Structured Query Language SQL I. Data Definition Language DDL 1. Create a TABLESPACE: creat tablespace lyy DATAFILE 'C:/app/lyy. dbf' SIZE 10 M; (create a 10 m tablespace and store it in the C drive app folder) Delete

How to connect Java to the MySQL database How to connect Java to the MySQL database Download: mysql-connector-java-5.1.38.tar.gz Http://dev.mysql.com/downloads/connector/j/ Tar zxvf mysql-connector-java-5.1.38.tar.gz Decompress the package Bkjia @

Oracle Database Table fragmentation required Recently, a mysql user asked me if the table in the Oracle database needs to be split regularly because of the storage of the Oracle data table. Unlike the clustering organization table (IOT) used in

Python scripts for migrating MySQL Data to MongoDB MongoDB is a document database with a natural advantage in storing small files. As the business requirements change, you need to import the Row Records in the online MySQL database to the document

How to efficiently write large amounts of data to Redis Recently, a buddy asked in the Group how to quickly import these IP addresses to Redis when there is a log containing IP addresses (one row per row. I initially recommended the Shell + redis

Configure the OCI environment in Linux Oracle Call Interface (OCI) provides a set of Interface subroutines (functions) that can be accessed to Oracle databases) to access the Oracle database. Required environment and software: Automake: automake 1.11

CentOS 6.5 install MySQL-5.5 via yum 1. Install the yum source for the mysql-5.5 rpm -ivh http://repo.mysql.com/yum/mysql-5.5-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpm 2. Modify the installed yum Source Edit the/etc/yum. repos.

Oracle 11.2.0.4 manually create EM Failed to start dbconsole after installing Oracle [Oracle @ elearning admin] $ emctl start dbconsoleEnter the name of the Host Name _ elearning not found. After oracle was installed, no em was configured. The

How to configure MySQL5.6 Master-Slave in Linux The installation of MySQL is very simple compared with that of Oracle. I personally think it is closer to the installation configuration of TimesTen, and the configuration of the Master-Slave or Master-

MySQL views the number of connections and status information I. Problem Description Today, I was asked by my O & M colleagues that the number of connections to two MYSQL databases has exceeded the monitoring threshold (700). Of course, their

MySQL force operation and order by usage We use hint commonly used in MySQL for detailed parsing. If you use Oracle frequently, you may know that Oracle has many hincvt features and provides many methods to optimize SQL statements. Similarly,