How to see where MariaDB 10 is getting data from (cache or disk)?

Question

caching

Hi everybody!
There is:

• MariaDB 10.0.31 under Centos 6 x64
  
• RAM: 16Gb
  
• Database: 8GB (InnoDB)
  
• innodb_buffer_pool_size: 12Gb
  
• file_per_table: TRUE
  

The database has a table with ip addresses (black list). There are about 10,000 records in the table with a small daily increase
This table receives 500-1000 requests per minute (only select id, blacklist from acl where ip_num=inet_aton('xxxx')
The application working with the database supports only MySQL and memcached.
In MariaDB 10, the interface memcached is missing.In
this regard, the question is how to see where MariaDB takes data from when accessing
tables.Thanks

Answer 1

From cache.
Hanging a memcache on a microscopic table, which is guaranteed to fit all in memory, is completely pointless.