Re: randomly Very slow insert for one 2G size table
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?
Subject
Views
Written By
Posted
1646
July 14, 2015 01:40AM
820
July 14, 2015 02:02AM
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.