Re: mysql inserting performance is slow

[jief llefe]

sorry I didn't explain clearly:
insert with for loop by golang, each loop result in 5 random value and then used for the insert SQL sentence.

sudo /usr/bin/mysqladmin -u -p extended-status -r -i1|grep -i Com_insert

I am using extended-status to monitor, but even with no index the inserting performance is 3000-5000 per second, and the cpu is not fully used.

I am creating 500 golang threads to insert at the same time, but seems it's not inserting for all the 500 threads.

Thanks