Shulou(Shulou.com)06/01 Report--

Generate large amounts of data to test:

Create table T1 (id int not null primary key auto_increment,age int,name varchar (20), createtime date)

Create index idx_age_name_create on T1 (age,name,createtime)

Vi create-data.sh

#! / bin/bash

ITunes 1

MAX_INSERT_ROW_COUNT=$1

While [$I-le $MAX_INSERT_ROW_COUNT]

Do

Mysql-uroot-p123456 test-e "insert into T1 (name,age,createtime) values ('HELLO$i',$i% 99 now ())"

Dwells $(date +% MMI% d\% H\:% m\:% S)

Echo "INSERT HELLO $I @ @ $d"

ITunes $(($item1))

Sleep 0.05

Done

Exit 0

Execute:

Sh create-data.sh 10000

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.