Database Administrator

Install MySQL 5.6.23 in Linux Install MySQL 5.6.23 in Linux Create userLog on as a root user and create a mysql user to maintain the mysql service. [Root @ localhost ~] #[Root @ localhost ~] # Groupadd mysql[Root @ localhost ~] # Useradd-g

Xtrabackup stream backup, incremental and compression Summary [Problem background] 1. databases with large MySQL files that need to be compressed. For example, in a 500 GB database, the xtrabackup backup file is GB, and then compressed and packaged

Oracle 11g TNS connection error ORA-12532 troubleshooting TNS connection errors are common problems for Oracle users. In practice, due to the complexity of the user terminal environment, various TNS connection problems often plague daily users.

Add, delete, modify, and query hibernate associated objects ------ query, hibernate ------ This blog post is the addition, deletion, modification, and query of hibernate-related objects in the previous blog. the settings of this Code have been

New Feature of oracle12c-Pluggable Database (PDB) and oracle12cpluggable 1. Advantages of new features of 12c PDB 1) Multiple PDBs can be integrated into one platform. 2) A new PDB or an existing PDB clone can be provided quickly. 3) through the

SQL split string, SQL split string /* The Delimiter is ',' */declare @ depid varchar (100) declare @ location intdeclare @ length int -- Sample string set @ depid = '2017, 13434, 34, 567,12, 9998, 'set @ location = 1 set @ length = 0 while @

Mysql technology insider InnoDB Insert (Insert) operation, mysqlinnodb What is the internal reaction of an innodb table after the client sends an insert command? This article will reveal this story to everyone. Of course, I am not very easy to

There was no endpoint listening at net. pipe: // localhost/PreviewProcessingService/ReportProcessing, endpoint When you develop a reporting service report, an error is reported in the report preview. You can skip this error directly and view the

MySQL (14) ---------- transaction processing, mysql ---------- The previous article's blog on transaction processing was not clearly written, difficult to read, and difficult to understand. So I have organized some documents to help me understand.

MySQL database master-slave synchronization, mysql database master-slave 1. PreparationsPrepare two machines and install a MySQL database respectively. For example 10.254.141.23 as the primary database10.254.166.60 as the slave Database For MySQL

Oracle password management allows a user to log on up to three times with an oracle Password If a user fails to log on three times in a row, the user is locked for two days. After two days, the user can log on again.Create a profile file: Update

SQLyog v11.24: How to query Chinese garbled characters in MySQL5.6.24 sqlyogmysql5.6.24 After searching for this problem online for half a day, I did not find a solution. Finally, I used a small skill to solve it myself. Reprinted please indicate

Redis document translation_key sets the expiration time, redis_key Available since 1.0.0. Use the Start version 1.01 Time complexity: O (1) Time complexity O (1) Source: http://blog.csdn.net/column/details/redisbanli.html Set a timeout onkey.

Win or win? Pig vs Hive !!!, Pighive From: http://www.aptibook.com/Articles/Pig-and-hive-advantages-disadvantages-features This article discusses the features of pig and hive. Developers usually choose a technical system that meets their business

Create view reports ORA-01031: insufficient privileges, insufficient Create view reported ORA-01031: insufficient privileges Create a script for the required experiment environment: create user lc0019999 identified by aaaaaa;create user lc0029999

Oracle-based SQL Optimization Methodology and oraclesql methodologyThe ultimate goal of SQL Optimization in Oracle databases is to shorten the execution time of target SQL statements. To achieve the above purpose, we usually have the following three

Mongodb Study Notes 01 and mongodb Study NotesMongodb Overview Mongodb is a document-type NoSQL database that stores bson-> json binary. The internal execution engine is a js interpreter that stores documents into a bson structure and converts them

RHEL5.8 if the ext3 file system is damaged, only the file system is not repaired (fsck, RHEL5.8 if the ext3 file system is corrupted, it will only detect and not repair (fsck-n) [root@lei1 ~]# df -ThFilesystem Type Size Used Avail Use%

Encountered ORA-14047: alter table | index rename may not be combined with other operations error, altertablerename Encountered ORA-14047: alter table | index rename may not be combined with other operations Error [oracle@rhel63single ~]$ sqlplus lc0

Updates to join table queries and table updates Background: I wrote a blog about database join Table query, "read database -- (6) Connection". It mainly talks about the connection type and how to use the connection for multi-Table query. This blog