MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.
Posted by: Rick James
Date: August 03, 2012 07:47PM

What order are the records coming in? If they are being inserted in PK order, it is more efficient.

Consider "batch" INSERT statements.

Consider LOAD DATA.

What is the value of innodb_buffer_pool_size? How much RAM do you have?

What is the value of autocommit?

Are you using BEGIN...COMMIT?

What is the value of innodb_flush_log_at_trx_commit

Is the binlog turned on? What is the value of sync_binlog?

Bottom line:
* There are a lot of possible reasons for sluggishness, and for the differences you are seeing.
* You can load the data much faster than that.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Need help in understanding the diffrence in responce times by mysql for two diffent use cases.
2055
Shantanu B
August 01, 2012 12:05PM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.
984
Aftab Khan
August 02, 2012 02:10AM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.
825
Shantanu B
August 02, 2012 04:56PM
Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.
958
Rick James
August 03, 2012 07:47PM


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.