阅读背景:

如何使用MySQL将表预加载到INNODB缓冲池中?

来源:互联网 

I have an e-commerce application that uses MySQL, and I'd like it to be faster. When a part # is accessed on the website that has been accessed before, the part loads quickly because all the necessary data is already in the INNODB buffer pool. However, if the part # has never been loaded before, that data isn't in the buffer pool yet, so it needs to be read from disk, and that is slow. I set my INNODB buffer pool to be 2GB, and this entire database is only about 350MB, so there is plenty of room to load the entire database in the buffer pool. I can see from the INNODB statistics that only about half the buffer pool is used right now.I have an e-commerce application that uses MySQ




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: