Database Administrator

Overview of MySQL btree Indexes Today, I have studied the B-tree index in mysql. Through this article, you can understand the principle of the B-tree index in mysql and the data retrieval process, different btree indexes in innodb and myisam engines,

Multi-source replication solution for MySQL Databases Overview Currently, mysql databases in the production environment are distributed on two servers. If the configuration is simple from a single master-slave perspective, the databases of the two

Amoeba for MySQL database read/write splitting I. Environment and software version:System: CentOS Linux release 7.2.1511 (Core)Mysql: Server version: 5.6.33Amoeba: amoeba-mysql-3.0.5-RC-distributionJDK: 1.7.0 _ 80-b15 (jdk is required for running

How to modify the MySQL administrator password 1. Turn off mysql first Service mysqld stop 2. Manual start Two methods A: service mysqld start -- skip-grant-tables -- skip-name-resolve start B: edit/etc/init. d/mysqld file. Add the --

Comparison of exp and expdp export performance Performance Comparison between General EXP mode, direct EXP path mode, and EXPDP Export 1. First, export the normal path of EXP: Exp bkjia/zhejiang file =/data1/zj_regular.dmp buffer = 20480000 The

Restoration test after Oracle 11gR2 database files are lost I. Test EnvironmentThe database version is Oracle 11gR2. After completing a full backup, shut down and create a snapshot. After each boot, the database executes the alter system switch

Troubleshooting OGG-03517 errors Environment Introduction: Source end: sybase Database, server Character Set iso_1, data Character Set cp936; Target end: Oracle11g, Character Set AL32UTF8. Replicat process error: ERROR OGG-03517 Conversion from

UNDO log systems The log system is the basic mechanism to ensure that the database management system correctly executes transactions. Based on different functions, the log system can be divided into UNDO and REDO. This article describes the

MySQL Performance Test-Sysbench practiceSysbench Industry-renowned performance testing tools Allows you to test disks, CPUs, and databases. Supports multiple databases: Oracle, DB2, and MYSQL Download, compile, and install the SDK by yourself.

Problems arising from over-using DBLINK for system integration Excessive use of DBLINK for system integration may cause many problems, mainly due to the following: 1. A large amount of database resources are consumed; Each time the local system

Oracle Releases high water level line /*************************************** **************************Cause: because the original exported database did not sort the table space, there are two main aspects. First, the user generated too many

Oracle cold Backup Recovery Process memoI. Fault approaching At noon one day, the mains supply was accidentally interrupted, and the UPS Power Supply in the IDC did not take over the power supply due to heavy load. All servers were restarted

Summary of methods to prevent SQL Injection in node-mysql, node-mysqlsql SQL Injection SQL injection is one of the most common methods of network attacks. It does not use Operating System bugs to launch attacks, but is aimed at the negligence of

Today, I checked the network connection status (netstat/ano) on the server and saw a bunch of TIME_WAIT connections, all of which were connected to port 1433. Obviously this is a malicious connection, therefore, to ensure the security of the server

Solution: a total of 24 databases, and one database cannot be cleaned up. You need to write a script to Perform Batch operations. The solution is roughly as follows: 1,Creates a master list with one master row. 2,Remotely obtain the binlog

Unable to connect to server 127.0.0.1: 27017: Unable to connect because the target machine is actively rejected. 127.0.0.1: 27017. type: MongoDB. driver. mongoConnectionExceptionStack: at MongoDB. driver. internal. directConnector. connect (TimeSpan

Private Sub cmdInquire_Click() FgStuinfo. clear' Clear the list before each query to avoid repeated Dim mrc As ADODB. recordset Dim txtSQL As String Dim msgText As String Dim dok1 As Boolean Dim dok2 As Boolean Dim dok3 As Boolean Dim Title (0 To 6)

The most difficult part of the system is the report. Compared with the student information management system, a report is a new content. To add a report to vb, you must add a third-party control. First, download the crystal report, the following

Flashback query is a flashback Based on the undo tablespace. The related parameters are as follows: SQL> show parameter undo NAME TYPE VALUE-----------------------------------------------------------------------------Undo_management string

When working overtime at night to call a remote copy of The local Mysql storage process, The error is: [Err] 1449-The user specified as a definer ('admin _ isbox' @ 'localhost') does not exist Based on the common root @ localhost error, assign all