在查看mysql的配置文件my.ini时看到这俩个参数,于是研究了一下
# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system. Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=8M
与MyISAM不同,InnoDB使用缓冲池来缓存索引和 行数据。 设置得越大,需要的磁盘I / O就越少访问表中的数据。 在专用数据库服务器上,您可以设置此项参数高达机器物理内存大小的80%。 但是不要设置它太大,因为物理记忆的竞争可能会太大导致操作系统中的分页。 请注意,在32位系统上你每个进程可能限制为2-3.5G的用户级内存,所以不要设得太高了。
# The number of regions that the InnoDB buffer pool is divided