Database Administrator

MySQL 5.6.29 source code compilation and installation recordsMySQL 5.6.29 source code compilation and installation record 1. installation environment 1. Operating System: CentOS 6.7 x86_64 # Yum install make cmake gcc-c ++ gcc-g77 flex bison file

How to change the asm sys User Password You must use the orapwd command to recreate the password file to modify the password of the sys user, instead of using the alert user command: 1. Set Oracle_HOME and ORACLE_SID of the ASM instance 2.

Install MySQL and Security Optimization Using yum on CentOS 0. Description The advantage of yum installation is that you don't have to solve the dependency problem between software by yourself. Basically, after yum is executed, the software is

ORA-12154, ORA-12560 Solution Process Application Server: Windows Server 2008 R2 EnterpriseFault symptom: Project-side colleague reported application server program Connection database error: ORA-12560: TNS: protocol adapter Error 1. Fault

Enumeration of common MyCAT sharding rules MyCAT supports multiple sharding rules. In the following example, partition enumeration is used. In applicable scenarios, the number of column values is fixed, such as province and month. Here, three values

MySQL common functions I. mathematical functions 1. Absolute value Function abs (value) Mysql> select abs (-120 );+ ----------- +| Abs (-120) |+ ----------- +| 1, 120 |+ ----------- +1 row in set (0.00 sec) 2. floor function floor (value) to obtain

In MongoDB, time stamps are converted to common date formats in batches. 1. mongodb traversal script provided on the official website:Official documentation: https://docs.mongodb.org/manual/tutorial/remove-documents/> Var arr = ["AB", "cd", "ef"]>

ORA-00824: cannot set sga_target due to existing solution When I got home from work today, I received a call from a colleague, saying that after I used the Oracle9i client to connect to Oracle10g, some parameters were modified, so that Oracle10

Precautions and troubleshooting for connecting a single Oracle 11.2 instance to ASM Notes for accessing ASM from an Oracle 11.2 instance: 1. Oracle users and grid users must have the same group, and the ASM Disk group must be consistent with this

Subtotal on MySQL Master/Slave latency I have encountered several MySQL master-slave latency issues recently, and some of my colleagues complained about this. Sort it out a little bit. ------------------------------------ Body ---------------------

MySQL database Chinese garbled Problem Solution After migrating a set of internal systems (confluence), the page is opened and all the question marks are garbled. Cause analysis: Create a database as follows: Mysql> create database confluence

Using filesort caused by order by optimization by MySQL Using filesort is generally used in the order by statement. Using filesort does not necessarily cause mysql performance problems. However, if the number of queries is very large, sorting in

MySQL Tutorial: Philosophical Thoughts on unauthenticated users Symptom 1 In the production environment, we occasionally encounter connections such as "unauthenticated user", with load at the database server level, high sys cpu, or thread running

RedHat Linux 6.5 enterprise Redis 3.0.3 Installation System Environment preparation RedHat Linux 6.5 Enterprise Edition 1. Download Redis 3.0.3 Address: http://download.redis.io/releases/redis-3.0.3.tar.gz 2. decompress the file using the tar

Use the Flashback Transaction method to restore data in a data table Misoperations and recovery of fine-grained data are common scenarios in our actual work. Based on the Redo Log and Undo mechanisms, Oracle provides many branch technologies, such

When pl/SQL developer is enabled, the NLS_LANG and Character set (Character set) problems occur. plnls_langStart pl/SQL developer and the NLS_LANG and Character set (Character set) problems occur. The company recently trained pl/SQL. After

[Translated from mos] How to check whether Oracle Advanced Security Option is installed ?, Mosoracle How can I check whether Oracle Advanced Security Option is installed? Source:How To Check if Oracle Advanced Security Option is Installed?

Error reported when the cli_autoincrement auto-Increment Variable is defined in Fastdb, fastdbcli I recently tried to use fastdb for development. The test in c ++ version is basically OK. Because the project team adopts C # development, I switched

Backup and restoration of MySQL Databases and tables, and backup of mysql DatabasesBackup Export all database table Structures mysqldump -uroot -ppassword -d dbname > db.sql Export a table structure in the database mysqldump -uroot -ppassword -d

SQL syntax, SQL SQL refers to the structured query language.The following is a table named "Persons": id auto-increment, no need to worry Basic SQL statements include addition, deletion, modification, and query.Add: The insert into statement is