Mysql_ Storage Engine Layer-innodb buffer pool

The buffer pool is a InnoDB storage engine with a pooled cache, querying data, first querying the data from memory if the memory exists in the direct return. InnoDB the difference between buffer pool and Qcache: Qcache caches the result set corresponding to the SQL statement, and the data in the table is cached in buffer pool (hot). The buffer pool is set to the larger the better, generally set to physical server memory%parameters: innodb_buffer_pool_size innodb_buffer_pool size Innodb_buffer_pool_dump_now default to market off, if you start this parameter, stop the mSQL service, InnoDB saving data from the InnoDB cache pool to the local hard disk Innodb_buffer_pool_load_at_startup default to off off. If you turn on this parameter, start the MySQL service to load the local hot data into the INNODB cache pool to see if Buffer_pool is connected to show VARIABLES like'%innodb_buffer_pool%'innodb_buffer_pool filename Thermal data file monitor buffer pool usage Show status like'%innodb_buffer_pool%'; parameters: Innodb_buffer_pool Read requests total number of buffer pool queries InnoDB buffer _pool reads the number of times the data was fetched from the physical disk through both of these you can know Bufferpoo L's hit rate

Mysql_ Storage Engine Layer-innodb buffer pool