What if mysql load data cannot bypass innodb cache

This article introduces mysql load data can not bypass innodb cache how to do, the content is very detailed, interested friends can refer to, hope to be helpful to you.

When oracle loads data, you can use direct write to write this part of data directly to the data file, without first writing this part of data into db cache in sga. On the one hand, the speed is greatly improved, on the other hand, the impact on cache can be avoided.

At present, a similar method has not been found on mysql. Importing a large amount of data will have a great impact on the original cache, resulting in the increase of physical reads of the database and the increase of disk io.

As an alternative, using the save / restore buffer pool feature provided by percona can quickly save this cache shock, but after all, the symptoms are not the root of the problem.

It is hoped that when oracle takes over mysql, it can also be implemented on mysql. Sometimes there is such a need, such as load historical data on the system, these data need to be entered by load, but now rarely need to access, direct write load has a great advantage.

About mysql load data can not bypass innodb cache how to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.