Database Administrator

MySQL changes the password and forgets the ROOT password This document introduces how to modify the user password of MYSQL and how to handle the problem after the root password is forgotten. I. Three password modification methods 1. Modify the logon

Install MySQL 5.5 using CMake This article introduces how to install MYSQL 5.5.36 database through rpm. I. Environment Description OS: Oracle LINUX SERVER _ 64 6.3 software source code package storage location/usr/local/src Source code package

MySQL physical query optimization technology-index dive Analysis One guide In the MySQL official manual, there is one sentence: The optimizer can estimate the row count for each range using dives into the index or index statistics. This is to say:

Current online redo logfile loss Handling Method We have previously performed a recovery drill after the rm-rf operation, and there is no backup. Today, before performing destructive operations, we made an rman full backup, and then deleted all

Use Oracle analysis functions to randomly extract N records Simulate a song table with a song ID and Author ID, and initialize some data Create table music ( Music_id int primary key, Userid int ); Insert into music (music_id) Select rownum rn

The Oracle 11g empty table cannot be exported. The deferred_segment_creation parameter is added to the Oracle 11g. The default value is true when the database is created. This parameter means delayed loading. When no data exists in the table, no

MongoDB Installation Guide for Ubunu 14.04 0. Environment Description: Ubuntu 14.04, MongoDB2.6.1 1. Import the public Key value from MongoDB to the Ubuntu package system. 2. Create a MongoDB file in the Sources list 3. Reload the local file

Chapter 2 User Authentication, Authorization, and Security (9): prevents login names and users from viewing metadata, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for

Tracking the SQL statement execution process and related knowledge development in oracle, oraclesql select * from v$sqlarea; select * from v$sqlarea where first_load_time>'2010-11-27/09:30:00';Each record in the query result of this method displays

In the xxMapper. xml file of mybaits, the numbers are greater than the numbers and smaller than the numbers.Method 1: Because it is in xml format, it is not allowed to contain characters such as ">", but both can be used symbols are described, so

IReport4.6.0 chart operation, ireport4.6.0 chart For reports, charts are indispensable. Even if you are tired of working on Monday ,,, Step 1: Create a new blank project and create a lot of online data from the data source. Step 2: On the iReport

QlikView format a cell, qlikview Cell You can create a pivot Table and a vertical Table or a general Table in QlikView. If the style of a cell is different from that of other cells, such as the color or Border width, you can use the following

QlikView calculates the sales data from the beginning of the year to today. The sum of sales from the beginning of the new fiscal year to today is a common demand of many students. There are two ideas: 1. You can generate a field named YTDFlag when

[Sqlite] --> Embedded Database Transaction understanding and instance operations, sqlite Embedded DatabaseSQLite Transaction (Transaction) A Transaction is a unit of work performed on a database. A Transaction is a unit or sequence of work completed

HammerDB database pressure tool using simple steps, hammerdb database pressure Welcome to reprint, reprint please indicate the source: http://blog.csdn.net/notbaron/article/details/38879681 Simple Steps for using HammerDB database pressure

[Sqlite] --> detailed process of connecting to the Sqlite database using jdbc for various data operations, jdbcsqlitePreface:SQLite is a ACID-compliant relational database management system, which is contained in a relatively small C library. It is

Comparison of execution plan changes used by index_ss hint, index_sshint Comparison of execution plan changes used by index_ss hint Buffer indicates the number of memory reads in the current operation, including consistent read and current

Mongodb background running, mongodb background By default, if shell is disabled, mongodb stops running. To run it in the background, you only need to add the -- fork function at startup. You can add -- logappend to the Log Path to prevent logs from

Redis and MongDB data sharing, redismongdb Refer: Http://blog.nosqlfan.com/html/3537.html redis Data Summary Http://blog.nosqlfan.com/html/3548.html mongDB Data Summary Problems with session sharing in redis How did you create a

The SQL Server execution plan teaches me how to create indexes? I am not very familiar with the index, so the test results are of no value, or even some people are misleading. I am sorry here, but where did I fall. Application scenarios Or use the