mysql insert was too slow

2019-09-07 10:48发布

问题:

isn't mysql too slow? i downloaded latest version and install to linux ,i do develop while found the performance isn't satisfied. i found the write operation take down the whole system.

so i did a test.a simple sql as this

INSERT INTO `mydb`.`mytable` (`abc`, `cde`) VALUES (1, 1346753112)  1 row(s) affected 

take 70ms.

select is pretty fast though ,take less than 1ms.i remember in sqlServer take much less time. how to make the insert faster?reduce it to 10ms.