Database Administrator

Solution to MySQL startup failure due to insufficient memory 1. Failed to start MySQL. Check the error log/var/log/mysql/error. log. 2. The main error messages are as follows: [ERROR] InnoDB: mmap (136151040 bytes) failed; errno 12[ERROR]

When does MySQL use indexes or do not use indexes? Index: You can use indexes to quickly access specific information in database tables. An index is a structure that sorts the values of one or more columns in a database table, for example, the name

Compile and install MariaDB-10.0.20 under CentOS 6.6 System Environment: CentOS6.6 (Final)MariaDB port: 3309 (because MySQL is already installed on the local machine and you do not want to delete MySQL) # Wget http://mariadb.nethub.com.hk//mariadb-10

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary 1. Preparations before installation: Operating System: RHEL6.5 Storage: Huawei, multi-path configured Bind the business network card and heartbeat network card and pass the

Select sum (bytes) from dba_segment: waiting for 'gc cr request', dba_segmentgcSO: 0x5533efea0, type: 4, owner: 0x554631060, flag: INIT/-/0x00 if: 0x3 c: 0x3Proc = 0x554631060, name = session, file = ksu. h LINE: 12624 ID:, pg = 0(Session) sid: 388

SQL primary key constraints and foreign key constraints, SQL primary key constraintsPrimary key constraint SQL PRIMARY KEY constraint The primary key constraint uniquely identifies each record in the database table. The primary key must contain a

The prefix index of MySQL is similar to that of Oracle. MySQL has an interesting index type called prefix index. It can index the front part of a text field separately to reduce the index size. In fact,Oracle has similar implementations. For text,

Python module knowledge 2: Time and date Calendar module Time, Datetime, Calendar, pythondatetime 1. time Module Why did the time start in 1970? Because Linux was used in that year, the time is usually represented by the following methods:

In-depth interpretation of sequences in PostgreSQL and their related functions, and interpretation of postgresql I. Introduction A sequence object (also called a SEQUENCE generator) is a special single-row table created using create sequence. A

After the Oracle manufacturer recently installed the monitoring plug-in for OEM 12C in the primary database in the production environment, an exception occurred to the Oracle GoldenGate instance that has been synchronized to more than a dozen

In this Document   Goal   Fix   References Applies to: Oracle Server-Enterprise Edition-Version 11.2.0.1 and later Information in this document applies to any platform. Goal This document

The latest error message "unable to extend temp segment by 8192 in tablespace..." was prompted during rebuild index. This is a common error. When creating an index, you need to use the user's default temporary tablespace for sorting and generating

BI business intelligence training series-(3) Introduction to SSAS and business intelligence ssasIntroduction: A client tool provides the ability to design, create, and manage multidimensional datasets from a data warehouse, and access the OLAP data

Oracle purchase price research (2): oracle purchase price researchRead Oracle purchase price researchFocus of this Article The previous article wrote online materials and theoretical research. This article mainly describes the actual enterprise

Redis Research (11)-data persistence, redis Research DataRedis's strong performance is largely due to the fact that it stores all the data in the memory. In order to ensure that Redis will not lose data after the restart, data needs to be

Php supports connection to the SQL server database and SQL server 1. Software Configuration Win7 64 + wampserver2.2d-x32 + SQL Server 2008 R2 database. The php version in wamp2.2 is 5.3.10. The Php environment can also be changed to php + apache. 2.

Analysis of Three-tier architecture, analysis of three-tier architectureThree-tier architectureLet's take a preliminary look at the three-tier architecture through several questions.1. What is a three-tier architecture?2. Application Scenario-why

MySQL parameter binlog-do-db affects binlogs writing, mysqlbinlogdodb1. Environment Description Objective: When binlog-do-db is set in the database, the impact on binlog write under different binlog_format = statement | row | mixed may be poor in

In the process of using the Sybase database, we often encounter locks in the Sybase Database System. In most cases, users must log on to the system as Super Users to process the process. To ensure the security of the Sybase Database System, the

This article will discuss the similarities and differences between simple nested queries and non-nested queries in SQL, through which you can better understand SQL statements. One day's work was to fix the bug of a project, and then we found that