MySQL Forums
Forum List  »  Performance

Re: mysql inserting performance is slow
Posted by: jief llefe
Date: May 03, 2017 09:20PM

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.


Options: ReplyQuote

Written By
Re: mysql inserting performance is slow
May 03, 2017 09:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.