Database Administrator

Reset the MySQL root Password in CentOS There are many ways to reset the MySQL password in CentOS. The official website also provides convenient and quick operations. For details, refer to resetting permissions. To reset the password, follow these

The simplest 11g Active deployment uard (ADG) configuration process (project steps) I. Environment Introduction:I first installed a set of database software on the two Linux virtual machines db01 and db02, and created a database named woo on the db01

Use YCSB to test MongoDB's performance MongoDB database-Level Lock MongoDB is currently the most popular NoSQL database. It is favored by many developers with its natural document-type data structure, flexible data models, and easy-to-use horizontal

Ambari Hive cannot be properly queried 1. An error occurred today. After connecting to hive, no command can be executed. $ Beeline-u "jdbc: hive2: // hostname.domain.cn: 10000/default; principal = hive/_ HOST@domain.com ;"Connecting to jdbc: hive2: /

Changing the Linux host name causes MySQL to fail to start and restart MySQL cannot be restarted, shut down, started, or used. If you modify the host name, you can disable all MySQL processes and start MySQL. Today, I saw that my host name was

Using rename table in MySQL to quickly and efficiently RENAME a database (schema) Once a new database (schema) is created in MySQL, it cannot be renamed, therefore, if you need to rename a database, the general practice is to dump the data in the

Usage and difference of in, exists, not in, and not exists in SQL queries 1. in and exists In connects the External table to the internal table as a hash (Dictionary set), while exists loops the External table and queries the internal table after

Oracle knowledge sorting DBA thoughts and skiesThe Inventory Oracle Installation Tool OUI is used to manage the Oracle parameter files in the Oracle installation directory. After startup, it reads the parameter files in the following order. If

Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i, provided that Oracle 9i has been installed. 1. Download the corresponding ORACLE client

Quick install of MongoDB in Linux MongoDB is a non-relational database (NoSql) that is very popular in the IT industry. Its flexible data storage method is favored by current IT practitioners. MongoDB implements the object-oriented idea (OO idea),

PostgreSQL database in the year, MySQL score dropped sharply, postgresqlmysql To determine the DBMS for the year 2017, DB-Engines deducts the score for the year January 2018 from the latest score for the year January 2017 to get the score

Mysql installation-free version configuration and mysql installation-free version Configuration Decompress mysql-5.7.17-winx64.zip to D: \ database Modify configurations Create my. iniThe configuration is as follows: [Client] # set the default

How to install PostgreSQL 9.6 In CentOS 7: centospostgresql Preface PostgreSQL is a powerful open-source object relational database system that runs on almost all major operating systems, including Linux, Unix (AIX, BSD, HP-UX, sgi irix, Mac OS,

PostgreSQL Partition Table (partitioning), postgresql Partition Table PostgreSQL has a very useful function, partition table, or partitioning. When a TABLE has many records, tens of millions or even more records, we need to split it into subtables.

Commonly used time and date scripts in PostgreSQL tutorial, postgresql tutorial Obtain System Time Functions select now(); --2013-11-28 16:20:25.259715+08select current_timestamp; --2013-11-28 16:20:38.815466+08select current_date; --2013

Guidance:This article introducesDatabaseThis article is suitable for beginners who have just begun learning databases. I believe that everyone can find their own needs, so everyone can get what they need. 13 database terms: 1. Relational Model: A

Hardware The root of aiming speed To increase the speed of your database program, you will naturally think of the basic parts that affect the speed. We will start from processing these parts. When you try to improve the performance of your database

How to migrate? We learned from the MySQL documentation that InnoDB tablespaces can be shared or independent. For shared tablespaces, all tablespaces are placed in one file: ibdata1, ibdata2 .. ibdataN, in this case, there is no way to migrate

Monitor database performance SET TIMED_STATISTICS = TRUE in the init. ora parameter file and alter session set statistics = TRUE in your SESSION layer. Run svrmgrl and register it with connect internal. During the normal activity of your

I. High Availability of the system (High Availability) 1. High Availability Solution With the development of computer applications, people have higher and higher requirements on the High Availability and High Availability of computer systems. In