mysql - Isint Memcached doing the same job as Buffer pool in Innodb? -


is that I consider it as:

buffer pool in INODAB < / Strong>: This stores the index and data from the SQL table and caches it for future queries, so it does not need to disturb MySQL at all times.

Memkachad : It is used to store data from the insod and cache, so there is no need to ask Enodab every time.

Does not they both do the same thing, caching the feedback in Rama, then it gets faster and decreases I / O and SQL Parsing? Then why add another layer of memcatch to the top of the Indob buffer pool is managed by InDebby. Everything needed to do the query should be in the buffer pool, so read new data from the disk used in existing data On the go, the data already present there is ejected.

Adds between tables is still expensive, even if table buffers are in the pool.

On the other side, Memcatch is an important-value store where no relational operation can be performed on the data stored, just inserted and retrieval.

Usually the results of long lasting or heavy questions are stored in Memkatch in the time period, they carry the load of the database.


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

java - Messages from .properties file do not display UTF-8 characters -

javascript - amcharts makechart not working -