Database Administrator

Install MySQL5.6 in Linux compilation and modify Character Set Environment preparation:After mysql5.5, The./configure compilation method will be changed to the cmake tool for compilation.Install the dependency package: yum install-y cmake gcc-c ++

MHA Routine Management MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication architecture. This

Brief description of Oracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control File The control file is the root file of

OPatch reports Prerequisite check "CheckActiveFilesAndExecutables" failed, opatchSymptom: When patching with Opatch, the following error is reported: [root@customer bin]# /u01/app/ora11g/product/11.2.0/db_1/OPatch/opatch auto /soft/psu/20299013/

Data cleansing Note: determines whether it is a date function or a note date Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to

Import sqlsever and excelsqlsever in excel Now we usually add some data to the database when testing the software. If the amount of required data is small, it is easy to say, but it will be too slow to add multiple entries, in fact, we can download

Database review 4-view and database ReviewDatabase review the concept of CH6 view 6.1 ViewIs exported from one or more tables (or views)Virtual table, DBMS onlyData DictionaryWhile the view data is still actually stored in the exportedBase

The OGG process that cannot be seen in the ggsci command prompt, ggsciogg [Oracle @ lei1 ggs] $ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.1.1.1.2 customized Linux, x64, 64bit (optimized), Oracle 10g on Oct 4 2011 23: 50: 20

Data mining using excel (2) ---- analyze key influencing factors and excel Data Mining   Use excel for data mining (2) ---- analyze key influencing factors   After configuring the environment, you can use excel for data mining. For environment

About innodb purge thread and master thread, innodbpurge ByInnodb_purge_threads controls the number of purge threads. (> = 5.6.5) The default value is 1 and the maximum value is 32. The default value 1 indicates that the purge operation of innodb

Oracle copy column value, oracle copy Column Requirement: Add a field to an existing table in the test environment, and manually add data to this column of some data in the table, now you want to add this field in the formal environment and copy

Basic use of mongoDB (II), use of mongodbConnect to the mongoDB server for basic database operations./bin/mongo 127.0.0.1: 12345View the current database> show dbsadmin (empty) local 0.078GBut change the database (it will be automatically created if

Oracle converts numbers to formatted strings, oracle strings Problem description If oracle stores number (0.00) data, the value 0 indicates 2.1, the value 2.10 indicates 3.88, and the value 3.88 indicates,If the corresponding information is taken

Static synchronization configuration process of OGG "Loading data from file to Replicat" table data, loadingreplicat Static synchronization configuration process of OGG "Loading data from file to Replicat" table data 1. mgr Process GGSCI (lei1) 3>

Data cleansing Note: determines whether it is a numeric function. Note Function Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to

Principles and cases of gc buffer busy acquire and gc buffer busy release, acquirerelease Yesterday, there was a database CPU 100% problem in the official environment. The database had 128 CPUs, GB of memory, and the power series. The database was

Synchronization practices between Mysql and Redis and mysqlredisI. testing environment in Ubuntu kylin 14.04 64bit You have installed Mysql, Redis, php, lib_mysqludf_json.so, and Gearman.Click here to view the test database and Table referenceSome

PL/SQL and SQLPLUS query results are different-Never forget commit !, Sqlpluscommit For the same SQL statement, the query results in PLSQL and SQLPLUS are different. Have you ever seen them? Today, we executed a query select * from t_user in the

Mysql Regular Expression Regular ^ match the start part of the string $ match the end part of the string. represents any character in the string, including carriage return and line feed [Character Set combination] matching any character in

Mysql database backup mysqldump, database backup mysqldump The mysql database server needs to be backed up recently. The following problems are solved in sequence. 1. [SQL] mysqldump-uroot-proot tms> tms_201505133 SQL [Err] 1064-You have an error in