Database Administrator

Binary installation of MariaDB5.5.36 Binary installation of MariaDB5.5.36 1. Obtain the source code package and decompress it. Make sure mysql-server and mysql of the rpm package are not installed. [Root @ http1 mysql] # rpm-qa mysql [Root @ http1

Install Redis in CentOS 6.5 Install Redis in CentOS 6.5 Version: redis-2.8.19.tar.gz Check whether the following dependencies are installed. If not, install them first. Otherwise, an exception occurs. Yum installgcc-c ++ Yum install-y tcl. 1. Obtain

Oracle Stored Procedure instance memo Oracle Stored Procedure instance memo Statistical report: the number of user logins (platform clicks) at the beginning of each month. The scheduled tasks count the number of logins, number of Logon accounts, and

Database optimization principles and Optimization PrinciplesRecently, I have summarized the database optimization methods in the database course design and hope to help people who need them:1. Optimize the query to avoid full table scanning. First,

ORACLE cannot fetch plan for SQL _ID, fetchsql_id When I tested the SQL Execution Plan today, I found that sqlplus could not print the execution plan normally. According to the online information, I sorted it as follows: ..... SYS @ orcl> select *2

Linux does not allow MySQL to distinguish the case sensitivity of table names.Problem description: Today, a project database is transplanted to the liunix server, and the table cannot be found. The query database does exist. After analysis and

Configure the authentication password for redis and the authentication password for redisRedis Password Configuration1. Configure through the configuration fileThe redis configuration file installed in yum mode is usually in/etc/redis. conf. Open

Timesten obtains SQL-related execution plans and timesten execution plans Command> host ttxactadmin ttwind Command> call ttsqlcmdcacheinfo (135710768 ); 16:07:54. 311/App/timesten/TimesTen/ttwind/info/datastore/ttwindTimesTen Release

Mysql obtains the time from last week to Sunday. Declare _ LastWeekStartTime date; -- last week's start time declare _ LastWeekEndTime date; -- last week's end time; because the system is Sunday, it is required to subtract 1 set @ A = date_add

Kettle _ example of data extraction, kettle example  Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

Mysql library import (Graphic parsing), mysql library graphic Parsing 1. First, create the database you want to import in your Mysql database. For example, I want to import the database hacker and create a new hacker database in the Mysql database.

Install redis and centosredis in centos 6.5 Version: redis-2.8.19.tar.gz Check whether the following dependencies are installed. If not, install them first. Otherwise, an exception occurs. Yum installgcc-c ++ Yum install-y tcl.   1. Obtain the

OPatch reports Prerequisite check CheckMinimumOPatchVersion failed, opatch Prerequisite check CheckMinimumOPatchVersion failed Symptom: [oracle@db01 18522509]$ /DBSoft/Product/11.2.4/db_1/OPatch/opatch applyOracle Interim Patch Installer version 11

Oracle has many pitfalls.Oracle has many pitfallsExisting pitfalls include:1. Cold backup. The steps from Win32 to Win64 are required.2. Open the database gradually.Close: shutdownOpen: startup nomount alter database mount; alter database open;The

Delete all objects (tables, views, triggers, stored procedures, and functions) of the current user.Zookeeper  DECLARE TYPE name_list is table of VARCHAR2 (40 ); TYPE type_list is table of VARCHAR2 (20 ); Tab_name name_list: = name_list ();

[MongoDB] MongoDB aggregation framework (I): mongodb aggregation framework Question: There are three days to end on March 13, 2014. The plan for this month has been completed in addition to the plan for summarizing Mongodb. Recently, due to laziness,

[Incomplete recovery], [non-recovery]Incomplete recoverySet until scn Set until time | timestamp... the most commonSet until logseq <>Example of Incomplete recovery:SQL> conn scott/tigerConnected.SQL> select to_char (sysdate, 'yyyy-mm-dd hh24: mi:

MySQL series: page Structure Analysis for innodb source code analysis, mysqlinnodbIn the tablespace structure analysis, we know that the minimum physical storage allocation unit of innodb is the page, in the MySQL-3.23 version of the source code,

SQL Server deadlock analysis, processing and prevention, SQL Server 1. Basic Principles The so-called "deadlock" is defined in the operating system: each process in a group of processes occupies resources that will not be released, however, a

Java Oracle Stored ProcedurePL/SQL is an extension of ORACLE's standard database language. ORACLE has integrated PL/SQL into ORACLE servers and other tools, in recent years, more developers and DBAs have started to use PL/SQL. This article describes