MySQL, server time-consuming test

Test A

Field: Id,test,number

Computer Configuration: 8g Memory

Write more than 5w at the same time, it will be jammed.

Error hints

134217728  -

Test Two

Field: Id,test,number

Computer Configuration: 8g Memory

Write record 5w, time: 10s

Read 5w, time consuming

Field: Id,name,number

100w record sum time only requires 0.233s

100w Record Count (*) time required only 0.165s

100w Recording Select takes only 0.615s

100w Record Select a field takes only 0.398s

Field: Id,name,number

Insert 5,000, time consuming 1s

Insert 1w, time consuming 3s

Insert 3w, time consuming 6s

Insert 5w, time consuming 11s

Add Time field

MySQL, server time-consuming test