Shulou(Shulou.com)05/31 Report--

How to compare the insertion time of Mac stand-alone MySQL database records, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

Mysql > mysql > show create database test\ G

* * 1. Row *

Database: test

Create Database: CREATE DATABASE `test` / *! 40100 DEFAULT CHARACTER SET utf8 * /

1 row in set (0.00 sec)

Mysql > show create table test1\ G

* * 1. Row *

Table: test1

Create Table: CREATE TABLE `test1` (

`a`varchar (10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

Mega-level insertion test, takes 4.3 seconds-second response

Mysql > insert into test1 (a) select a from test1

Query OK, 1048576 rows affected (4.30sec)

Records: 1048576 Duplicates: 0 Warnings: 0

Ten million level insertion test, takes 1 minute 18.32 seconds-minute response

Mysql > insert into test1 (a) select a from test1

Query OK, 16777216 rows affected (1 min 18.32 sec)

Records: 16777216 Duplicates: 0 Warnings: 0

30 million level test, takes 2 minutes 38.10 description-minute response

Mysql > insert into test1 (a) select a from test1

Query OK, 33554432 rows affected (2 min 38.10 sec)

Records: 33554432 Duplicates: 0 Warnings: 0

View current table status

Mysql > SHOW TABLE STATUS LIKE "TEST1"\ G

* * 1. Row *

Name: test1

Engine: InnoDB

Version: 10

Row_format: Dynamic

Rows: 112834468

Avg_row_length: 32

Data_length: 3633315840

Max_data_length: 0

Index_length: 0

Data_free: 1518338048

Auto_increment: NULL

Create_time: 2017-08-31 22:30:19

Update_time: 2017-08-31 22:40:46

Check_time: NULL

Collation: utf8_general_ci

Checksum: NULL

Create_options:

Comment:

1 row in set (0.00 sec)

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.