Database Administrator

Sort the number of rows in a MySQL database from large to small. As the company's business grows, it is necessary to split the tables of a MySQL database at work. In order to make more detailed, in this database, all the tables, sort by rows in

InnoDB two-phase log Submission mechanism ViewThe innodb_flush_log_at_trx_commit official website has some questions.For more information about the innodb_flush_log_at_trx_commit parameter, see the official website.One of them is written as follows:

Oracle Index Clustering Factor (cluster Factor) I. Description: During the test today, we found that there was an index on the field, but the execution plan did not go through the index. After searching on the internet, we found that it was caused

An instance of RAC cannot be mounted due to the configuration of the DG Broker. Today, I encountered a fault in my own lab. It seemed very simple at first, but it was actually interesting and easy to ignore if I was not careful. We believe that

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 --

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

How to install and configure MariaDB10.0.14 in CentOS 7 System Environment: CentOS 7MariaDB version: MariaDB 10.0.14: Http://mirrors.neusoft.edu.cn/mariadb/mariadb-10.0.14/source/mariadb-10.0.14.tar.gzOther package address: https://downloads.mariadb.

Install MongoDB in Linux MongoDB provides 32-bit and 64-bit installation packages on Linux. You can download the installation packages from the official website. : Http://www.mongodb.org/downloads Download the installation package and decompress

MySQL 5.6.26 mistaken deletion of ibdata for restoration MySQL 5.6.26 mistaken deletion of ibdata for restoration [Root @ hank-yoon ~] # Ps-ef | grep mysqlRoot 1129 1 0 00:00:00 pts/0/bin/sh/export/servers/mysql/bin/mysqld_safe -- datadir

Use Docker to deploy MySQL (data persistence) and dockermysql Link: http://walterinsh.github.io/2015/01/17/use-mysql-with-docker.html This article briefly describes how to use Docker to deploy mysql and persist data. We will use the

The WEB project on the server repeatedly fails to connect to the MySQL database. One reason is that the scheduled task plan for MySQL is not closed. MySQL runs an automatically updated scheduled task plan by default every morning. If the

The States Field Usage specification you should know, and the States Field Usage Specification Preface I recently encountered some things in my work. I think it is necessary to share with you that we want to unify the status fields of database

SQL Injection (literacy) and 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 programmers during programming. through SQL

DECLARE @ OldId varchar (50) DECLARE @ CustomerID varchar (50) DECLARE My_Cursor CURSOR -- Define the cursor for (select CustomerID, oldid from Customer where Area = 'bj ') -- locate the desired set and put it in the cursor OPEN My_Cursor; -- OPEN

1. create data table space, index table space 2. create user jerry and authorize 3. create a table, index, and insert data for user jerry. export data of jerry 5. create user peter and authorize 6. import the data of jerry to the peter user (the

With the data pump expdp, impdp can import and export data on the server, with high efficiency.You do not need to set the environment variable NLS_LANG. By default, it will go to the character set of the database. Create directory backup as '/backup

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

Indexes without sorting must meet two conditions:① The sorting field is exactly the same as the INDEX key used in the execution plan (or the previous INDEX keys)② The table access method is index, ref, or range. [Note: Type in the explain output can

-- Method 1: Query dba_tab_columns Select COLUMN_NAME, DATA_TYPE, DATA_LENGTHFrom dba_tab_columnsWhere table_name = upper ('table name ')Order by COLUMN_NAME -- This method requires the DBA permission. -- Method 2: Query user_tab_colsSelect