MySQL

First, installation1. Download. Tpcc-mysql of the TAR package2. Upload to Server (RZ)3, Decompression (TAR-ZXVF Tpcc-mysql-src.tar)II. Preparation of the databaseEnter the database, run the Create_table.sql,add_fkey_idx.sql two tables (these two

What are the 1.mysql traffic?(1) received traffic (bytes_received)(2) traffic emitted (bytes_sent)2. How do I get the incoming and emitted traffic?To get the received traffic:[Email protected] usr]# Mysqladmin extended-status | awk '/\/{print $4} ' 7

First of all, I've been confusing the concept of partitions and sub-tables here to summarizeI. What is a partitionMySQL database data in the situation of the file exists on the disk, a table mainly corresponds to three files, one is the FRM storage

1. Import the TXT file from MySQL query datamysql-h 10.3.20.251-u addata_r-p 3417-parreboehw9mijien_ep6bykoxktikunl ad_data-e "SELECT ID, Advertiser_id,date,cos t,0 as Cash_cost, 0 as Reward_cost, 0 as Return_goods_cost, Income,balance, Create_time,

Query Library The file size of the table below has MySQL library as an exampleSelectTABLE_NAME,Concat (Truncate (data_length/1024/1024,2), ' MB ') as Data_size,Concat (Truncate (index_length/1024/1024,2), ' MB ') as Index_sizeFrom Information_schema.

The importance of database backup Improve the system's high availability and disaster recoverability, when the database system crashes, no data backup can not find data. Restoring a database using a database backup is the best solution

In the MARIADB environment introduced yesterday,Turn on MySQL in the two host m1,m2, respectively,First Enter VI/ETC/MY.CNF/To see what's in "mysqld":The server_id in the configuration file is to be modified, corresponding to the serial number of

1. Back up the MySQL database on the server [[email protected] ] # mysqldump -h localhost -u root -proot --databases Surpass --routines > /home/SQLBackup/Surpassme_20180801.sql 2. View the SQL script after backup [[email protected]

The eighth chapter studies like operator, hundred percent (%) wildcard character, underscore (_) wildcardP47Select Prod_id,prod_name from products where prod_name like ' jet% '; #表示检索prod_name列中的值 all words that start with Jet,% indicates that the

Tag: Execution end also has share Picture nbsp Filter. com must know must be ROMThe seventh chapter: Data filteringP43Select Prod_id,prod_price,prod_name from Products where vend_id =1003 and Prod_price Select Prod_name,prod_price from Products

The first is the modification of the database:-- Delete a database called bbb111 DROP DATABASE bbb111;Modification of a table in a database: renaming a table-- three kinds of effects in the same form TABLE to new name; ALTER TABLE formerly known

#-------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------# error 1 Reading table information for completion of table and

For the installation steps, a large number of online, I will not repeat, we can degree Niang together, today only talk about the installation process of some pits:1. When authorized by the system user, a log file is generated containing the initial

Recently, the lock operation of insert is more puzzling, so do it yourself, a look at exactly. The main thing is to take a look at three SQL to see what locks are being used in the execution of SQL.SELECT * FROM INFORMATION_SCHEMA. Innodb_trx\g;

1, from the OSS download mysql-2018-07-31_22-01-22.tar.gz, Huawei Cloud is too perverted, every second on the 100mb!!2, upload files from the Windows host to the Linux host, through the SFTP protocol, 47MB per second.3. Kill the process that

1. InnoDB consistency Read and lock differences at different isolation levelsUnder different isolation levels, the consistent read policy and the required locks for INNODB processing SQL are different, and the characteristics of the data recovery

For established index (surname, first name, data)5.1, the index of the query type is valid1, full value matching: can find the surname + named Allen, the date of birth is 1990-11-05 person;2. The leftmost prefix matches: You can find the person

1. First download MySQL The version I selected is 5.7.19 based on the 64-bit Windows operating system. MySQL Portal: https://dev.mysql.com/downloads/mysql/There are different operating systems installed in the installation package you need to

1. Download MySQL Yum Repositorywget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm2. Add MySQL Yum RepositoryRPM-IVH mysql-community-release-el7-5.noarch.rpm3, verify whether to add the successYum Repolist enabled | grep "Mysql.*-

1. Role of the index:(1) Improve query speed(2) Improve the sorting speed(3) Increase the speed of group statistics2. Parsing of the index:Explain select * from T4 where a1=3 and A2>4 and a3= 53. Clustered index and non-clustered indexNon-clustered