MySQL How to determine if my table is stored in RAM?

I run:

MySQL v5.0.67 
InnoDB engine 
innodb_buffer_pool_size = 70MB 

Question: What command can I run to ensure that my entire 50 MB database is completely stored in RAM?

+3
source share
1 answer

, . , . , , . , , , . , MySQL , . , , , . , , .

show table status

.

IO/buffer/cache

show server status

, (, , ) , - -.

, , 70 . , .

Jacob

+1

Source: https://habr.com/ru/post/1737081/


All Articles