MySQL Forums
Forum List  »  InnoDB

Re: randomly Very slow insert for one 2G size table
Posted by: Rick James
Date: July 15, 2015 08:07PM

Even 2s is unreasonably high for that INSERT.

So, let me look at some other issues:
* How much RAM?
* What is the value of innodb_buffer_pool_size?
* SHOW VARIABLES LIKE 'char%';
* How many rows have the `name` in a case when the INSERT takes a long time?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: randomly Very slow insert for one 2G size table
1184
July 15, 2015 08:07PM


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.